.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Cube design problems

Posted By:      Posted Date: September 11, 2010    Points: 0   Category :Sql Server
Hi. I am working on an assignment which is aimed at building a cube which will be used by 14\15 different department of the organization.As per meeting with the users, and their needs, we decided to have 15 dimension and one measure group for the prototype. Now , the users from those departments are different and the way they see this cube is also very diff. The finance wants to slice and dice data and seems to have understanding about BI.but the some departements want to see detailed data after a certain level.. they are providing huge challenge to us. they want the cube to deliver them detailed information about those high cardinal members with very less processing time. We thought of designing actions , but  the user can following multiple navigation to reach the detail data.We thought of putting that in a dimension table but it killed the cube..like the users always faced out of memory issues ..to me it seems, we do not have proper knowledge on design..I would request your help to understand this real time challenge, which i am sure ,some one must have come accross.  

View Complete Post

More Related Resource Links

Design Patterns: Problems and Solutions with Model-View-ViewModel


The Model-View-ViewModel (MVVM) design pattern describes a popular approach for building Windows Presentation Foundation or Microsoft Silverlight applications. Robert McCarter shows you how the ViewModel works, and discuss some benefits and issues involved in implementing a ViewModel in your code.

Robert McCarter

MSDN Magazine July 2010

Performance Problems with calculate member in a cube

Hi,  I'm having performance issue with calculated member (Running total) which is created on one dimension in the cube.  Cube is having three dimension Product Details(Product Model, Product Type) , Time(Year & Month) & Qty type(In Qty & Out qty). See below for details Dimtime Year (Values 2000 to 2020) Month DimProd Product No Product Type Product Group DimQty Type In Qty Out Qty Fact Table Product No Year Month Qty Type of Qty( In Qty or Out Qty ) My MDX query for calculated member is  CREATE MEMBER [Qty Type].[Qty Type].[All].[Total] as      SUM(NULL:[TimeDim].[Hierarchy].CurrentMember , ([Qty Type].[Qty Type].[In Qty], Measures.[Qty]) - ([Qty Type].[Qty Type].[Out Qty], Measures.[Qty])  The formula is --> Total = Previous Period Total Qty + Inqty - Out Qty   This works perfectly when i browse at higher level (Qty Type on Rows & Time On Columns),   but when  i browse the cube adding dimension Product Details( Product group or Product Type) to Drill-through the In Qty & Out Qty,  the query is running and after one hour also it's not finished. Can anyone help me to solve this or propose new structure to resolve this issue.   

Problems deploying Adventures Works 2008 Cube

Hi,When I try to deploy (build is fine) the Adventure Works 2008 Cube, nothing happens (Green circle just spins, and no progress indicators). I had no problems installing the Adventure WOrks databases.I have a newly installed SQL Server 2008 box, and currently, all accounts/services are running under "Local System"I tried googling this issue, but haven't found anything useful.Ideas anyone?

Excel problems to browse the Cube.

Hi,    I have a cube and i'm facing problems with to access the SSAS 2008 cube from Excel 2003.  Initially i tried to access from one machine (Windows XP & Excel 2003)  it worked. When i try to access from another machine (Windows 7 & Excel 2003) i'm getting the below error message. Excel Was unable to get necessary information about this cube. The cube might have benn reorganized or changed on the server. Contact the OLAP cube administrator and, if necessary, set up a new data source to connect to the cube. Please help me.

Pipeline Data Cube Design Question



The Analysis team wants to analyze sales pipeline data. Our CRM system(Source system) send the Data Warehouse team transaction as the Product moves through the different stages.


To mention a few: Creation, CallMade,LeadEngaged,CreditCheck,PapersReceived,Closed.There are more than 100 tracking statuses like mentioned above.


Sample transactions fact table:


how to design this cube? HELP Please!!


Hi I am new to SSAS. I was able to build a cube if the data view includes only the clear-cut type of fact table and dimensions.
Now I am confused as what to do when thing get a little bit "complicated". Here is the made-up simplified version of the scenario.
A delivery company that deliver goods to several states. Some work orders require delivery to multiple states.

There are 3 tables:

Table 1 (a measure) - WorkOrder w/ fields: workOrderId (pk), Amount.

              Example:            WorkOrderId               Amount
                                         1                   5,000
                                         2   &nbs

Measures for Additive vs Non-Additive Data. What is cube design best practice?


I'm looking more for SSAS 2008 best practice design advice, rather than for an answer to a specific question (although I have a specifc set of examples).

First issue:  Creating a non-additive measure group and an additive measure group.  We have some fact data in our current cube that is additive, and some fact data that is non-additive; all stored in the same fact table.  We do not currently have measures implemented that reflect this aggregation distinction.  Question:  Is it considered good practice to segregate additive and non-additive fact data into a) different fact tables and/or b) different measure groups?  My thought is that it would be an acceptable design approach, but am looking for feedback.

Second issue:  Non-additive fact data is only available at a non-leaf grain.  The example here is that we have non-additive fact data which is only available for the 4th or 5th levels of our 6-level geography dimension.  Our solution has been to create a custom geography branch, which now essentially serves as our 'aggregation treatment' for non-additive fact data.  I don't believe it's a good practice to have the geography dimension serve this function because we end up having to create a custom geo member for each non-additive fact data element.  Question:  What is considered best practice

unable to design the cube and query

I am v new to MDX and its driving me crazy. I designed a fact table with count, region id. and there is a dimension table for region which has continent, countryname,countryCode,region_id as fields..
In the cube, I hav Location as one of the dimension and Continent,Country(map to Country Code column in table) are the levels under the default hierarchy.I want to know the count for all the countries I have. so i used

WITH MEMBER Measures.[Towers] AS '[Measures].[TowerCount]' select NON EMPTY ({Measures.[Unique Towers]}) ON COLUMNS, NON EMPTY ({ [Location].[Country].MEMBERS}) ON ROWS FROM [Cube] WHERE [Time].[2010].[4].[OCT]

It worked with results like
Axis #0:
Axis #1:
Axis #2:
Row #0: 111
Row #1: 222
Row #2: 22333
Row #3: 34354
Row #4: 1212
Row #5: 11
Row #6: 41
Row #7: 11

The o/p has the country code and the count, but I also want to have the country name in the o/p...I dont know how to change the cube and query...Could some1 help me here?

Thank you

Problems reconciling design time and runtime size of WPF Canvas


Hi, there I am using Visual Studio 2010. I am having trouble with the calculation of the size of my canvas and the positioning of the objects thereupon.

Please consider the following simplest of XAMLs:

<Window x:Class="test01.MainWindow"



 Title="MainWindow" Height="350" Width="525">

 <Canvas Margin="0">

 <Label Canvas.Left="505" Canvas.Top="310" Content="Label" Height="28" Name="label1" Background="Blue" />

 <Label Canvas.Left="-36" Canvas.Top="310" Content="Label" Height="28" Name="label2" Background="Red" />




1) The margins of the canvas are 0

2) at design time I see no part of either the blue label or the red label overlapping my canvas as displayed in Visual Studio

I am unable to explain why at runtime:

1) I see a portion of the blue label.

What is happening here? How can I get a better grip on the real size of my canvas at design time?


Edit: OK in case it isn't clear, the problem here is that I wou

Cube Design in BIDS - Best Practise

Hi all,

Not a technical query more a 'how do you do it' type thing.

I have 3 AS databases on my test server that I use for the following:

Cube_Scratch        - This is my gash, can throw it away any time test bed
Cube_Development    - Proper development instance
Cube_Staging        - Deployed to users for testing

In BIDS I have one solution that I use for all my development work.

So if I am going to make changes to a cube/dimension I import a backup of say Development and
unload the project in BIDS.

Then I do another import of Development and rename that to just the cube I am working on.

In that project I remove all cubes, dsv's and dimensions except the one I am working on.

If it all goes pear shaped I can just redeploy the backup.

Does this sound like a good idea or am I missing an easier way of doing this.

Many thanks.

Cube design guidelines



My dataset have 1 Fact table with around 1000 columns and 1000 dimensions, for each dimension, i need non null count, percentage,  and mean.

What will be the most effecitve design? 1 cube or many cubes or 1 measure group or many measure groups, will partitions help ?

Currently i created 1 cube, 1 measuregroup when output all, the quesry runs for ever.

Can I put count in 1 mearure group, percentage in 2nd and mean in 3rd measure group ?





Abstract Factory Design in C# , Vb.NET

Provide an interface for creating families of related or dependent objects without specifying their concrete classes

Prototype Design Pattern in C#. Vb.NET

Specify the kind of objects to create using a prototypical instance, and create new objects by copying this prototype

Adapter Design Pattern in C#, VB.NET

Convert the interface of a class into another interface clients expect. Adapter lets classes work together that couldn't otherwise because of incompatible interfaces.

Singleton Design Pattern in C#, Vb.NET

Ensure a class has only one instance and provide a global point of access to it.

Top .NET Performance Problems and how to avoid them

Every time I work with one of our .NET customers to help them with managing their application performance I come across the same problems as seen with other clients before: lots of ADO.NET queries, many hidden exceptions in core or 3rd party .NET libraries, slow 3rd party components, inefficient custom code

Solidify Your C# Application Architecture with Design Patterns

design pattern can solve many problems by providing a framework for building an application. Design patterns, which make the design process cleaner and more efficient, are especially well-suited for use in C# development because it is an object-oriented language. Existing design patterns make good templates for your objects, allowing you to build software faster. This article describes several popular design patterns you can use in your own applications, including the singleton, the decorator, the composite, and the state classes, which can improve the extensibility of your applications and the reuse of your objects.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend