Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

cube locks up....

Posted on 2008-10-16
4
Medium Priority
?
449 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 80 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
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 …
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…
Viewers will learn how the fundamental information of how to create a table.

886 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