Solved

cube locks up....

Posted on 2008-10-16
4
430 Views
Last Modified: 2012-06-21
I am trying to create a static report using Visual Studio 2005 Report Server Project.  My datasource is an Analysis Services cube.  

I wanted to create some Calulated Member fields to use at the reporting level, but when I drag in the 6 Dimensions I need, with the 4 or 5 Calculated Members, the cube just hangs.  I let it query for a few hours before killing the process.  

These are simple calculations, ie, Col1 + Col2 + Col3, or "CASE WHEN product = 'GAS' THEN 0 ELSE value END.  

When I take out the calculated members and drag in the cube's measures, its super fast, maybe 1 second to display the report.

Is is not recommended to use Calculated Member fields with a report built on Analysis Services?  Has anyone successfully put in a Calculated Member field in a report with an Analysis Services datasource?

Please advise.

Thanks!
0
Comment
Question by:mitai
  • 3
4 Comments
 
LVL 31

Assisted Solution

by:James Murrell
James Murrell earned 20 total points
Comment Utility
0
 

Accepted Solution

by:
mitai earned 0 total points
Comment Utility
I took a look at this but there is nothing that seems to be the silver bullet.   Any other ideas?

0
 

Author Comment

by:mitai
Comment Utility
no answer provided...
0
 

Author Comment

by:mitai
Comment Utility
no answer provided
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now