Solved

cube locks up....

Posted on 2008-10-16
4
438 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 31

Assisted Solution

by:James Murrell
James Murrell earned 20 total points
ID: 22735377
0
 

Accepted Solution

by:
mitai earned 0 total points
ID: 22741465
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
ID: 24002385
no answer provided...
0
 

Author Comment

by:mitai
ID: 24002391
no answer provided
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

627 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