• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 450
  • Last Modified:

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!
0
mitai
Asked:
mitai
  • 3
2 Solutions
 
James MurrellProduct SpecialistCommented:
0
 
mitaiAuthor Commented:
I took a look at this but there is nothing that seems to be the silver bullet.   Any other ideas?

0
 
mitaiAuthor Commented:
no answer provided...
0
 
mitaiAuthor Commented:
no answer provided
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now