.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

How to model a cube when actual and budget have different granularities

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
My budget and actuals occur in different levels. I am using Pivot Tables in Excel to load this from a 2005 SSAS cube & display these figures.  The problem is, when I go the leaf level (lowest for actual and under leaf for Budget) I get the correct Actual but the budget replicates the parent value. For instance: I have a Sales Budget which has been defined at a geographical State level, but the Sales Actuals occur at the geographical city level. I've built a cube with a Geography dimension: Country - State - City Measures: Actual, Budget when I use Excel 2007 to browse the cube via a Pivot Table and I drill-down to State (New York) it  correctly shows me  Actual: 10,000  Budget: 20,000 But If I drill down one more level I will see for Actuals: Princeton:  6,000  New Jersey: 4,000   and for the budget I will see both Princeton and New Jersey presenting 20,000.  How can I replace the Budget value with N/A or at least NULL or zero?    

View Complete Post

More Related Resource Links

Report Model based on Analysis Services Cube doesn't work


Hi all,

I am working in BIDS and would like to create a Report Model based on a cube.

Creating a Data Source based on SSAS goes well, but when I want to make a Data Source View, the earlier created Data Source doesn't show up, which is necessary for the final resulting Report Model.

Could somebody help me out in solving this issue? (And also tell me why this is issue is rising?)


SQL Server 2008 & BIDS 2008 (Version 9.0.3x)

How to model my cube.

I am a new guy to mdx. i was working on a job of  analys the profit depend on customers from different counties. Maybe the structure of table is complicated.

The relationships of table are below.

Sort:: table which use to store the county.
User: table used to store user information
Account: table used to store user's account information, one user  has one or more account.
Order: used to store account's order information. one account has one or more orders.
OrderItem: used to store order items in the order, one account has one or more items.

Now I  need to know how many orders had been made depend on  different counties and time period. I can implement time dimention,  but the location dimention,
due to the county information are store in user table, I don't know how to implement it into mdx.

How to create buckets on measures from 2 fact tables, i.e variance between actual and budget coming


1. to put the gist of the problem, i am trying to make an expense analysis report that compares my actual with its budget.

2. actual is coming from 1 fact table e.g. fact_general_ledger (grain = voucher number) and budget is coming from another fact table (grain = account [much higher than voucher number])

3. i have to calculate the variance (actual minus budget) at an account grain and make a percentage measure. hence i will get data like

Account     Var%

a1             -115%

a2              -5%

a3              7%

a4              20%

a5              22%

a6              35%

a7              45%

a8              57%

a9              95%

a10      &

Issue with Report Model on a Cube (multiple measure groups)


Hi All, 

I have was asked to built a report model on the cube for some users and being new to report builder 3.0. 

I am having a weird issue. Lets Say I have following DIMS and FACTS. I have a cube built on top this Dimensional model. 

Two measure Groups/mearsures  : ClassFact/ClassHours and FacilitatorFact/FacilitatorHours.

used Many to Many relationship for FacilitatorDIM and ClassFact measuregoup. I now browse the cube it works excellent. 

The problem Starts

Now a report model is built on top of it, then in the query wizard when I pull both groups and then FName the Classhours(measure) Disappears. 

Does Report Modes supports Many to Many or am I missing something? Any help will be appreciated. 




ClassDIM (ClassID, ClassName) 

FacilitatorDIM ( FID, FName) 


ClassFact( ClassID, Classhours) 

FacilitatorFACT(FID, ClassID, FacilitatorHours)


Sample Data: 



SELECT     ClassID = 1 , ClassDurationHours = 100.0

FROM       ClassFact


SELECT     ClassID = 2 , ClassDurationHour

Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Model View Controller (MVC) for ASP.NET

Model View Controller (MVC) architectures, immediately wonder how the MVC pattern can be applied in an ASP.NET world. This article will demonstrate how the MVC pattern can be applied to an ASP.NET web application and still maintain the basic Microsoft supplied architecture.

Dynamic Systems Development Model (DSDM) Methodology

The Dynamic Systems Development Model was developed in the U.K. in the mid-1990s. It is the evolution of rapid application development (RAD) practices. DSDM boasts the best-supported training and documentation of any of the agile software development techniques, at least in Europe. DSDM favors the philosophy that nothing is built perfectly the first time and looks to software development as an exploratory endeavor.

Overview of SharePoint Object Model

SharePoint offers a set of structured server-side objects those are widely used to program SharePoint Applications. These objects are hierarchically arranged and you can drill down through the object hierarchy to obtain the object that contains the components of SharePoint Application you need to use in your code.

Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

'Model' cannot be declared in this scope


I have a complex partial view (ugly stuff), the view page has this line:- 

<% Html.RenderPartial("PartialIndicatorWeighting", indicator);%>
and inside the ugly partial view I have this,
<td><%: Model.Active %><%: Html.CheckBoxFor(Model => Model.Active)%></td>
I'm trying to display a list of checboxes to show if the item is active or not, I get the following error:-
A local variable named 'Model' cannot be 

lossing focus from model pop up window controls


hi i using a model pop up window with some textbox but when i click on textbox of model pop up focus move to back to page textbox control plz help me 

How to detect mobile phone name/model no from asp.net?


Hi experts,

Can I detect the Name/model no of the mobile phones ,which are browsing my asp.net website from C# code behind? I need to show welcome message, addressing their model numbers and redirect to appropriate pages.

Thanks in advance for your reply.


OneNote 2010: Creating OneNote 2010 Extensions with the OneNote Object Model


Learn how to build applications and plug-ins that interoperate with data from OneNote 2007 and 2010 using the OneNote Object Model library freely available on CodePlex. Andy Gray demonstrates how easy it is to integrate information from OneNote notebooks, sections and pages into smart client and Web apps.

Andy Gray

MSDN Magazine July 2010

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

Extreme ASP.NET: Model Validation & Metadata in ASP.NET MVC 2


Scott Allen shows how to improve your user input validation with new features coming out in ASP.NET MVC 2 that easily allow validation on both the client and server.

Scott Allen

MSDN Magazine March 2010

CLR Inside Out: Exploring the .NET Framework 4 Security Model


The .NET Framework 4 introduces many updates to the .NET security model that make it much easier to host, secure and provide services to partially trusted code. This article dives into the many features and benefits of the .NET security model.

Andrew Dai

MSDN Magazine November 2009

Domain Models: Employing the Domain Model Pattern


In this article, we'll go through the reasons to (and not to) employ the domain model pattern, the benefits it brings, as well as provide some practical tips on keeping the overall solution as simple as possible.

Udi Dahan

MSDN Magazine August 2009

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