cube locks up....

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!
mitaiAsked:
Who is Participating?
 
mitaiConnect With a Mentor Author Commented:
I took a look at this but there is nothing that seems to be the silver bullet.   Any other ideas?

0
 
James MurrellConnect With a Mentor Product SpecialistCommented:
0
 
mitaiAuthor Commented:
no answer provided...
0
 
mitaiAuthor Commented:
no answer provided
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.