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

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

Calculate variance based on property of account

Posted By:      Posted Date: September 02, 2010    Points: 0   Category :Sql Server
Hi all, I'm having a problem implementing a requirement in SSAS. The case: There is a parent-child dimension Account which contains different accounts on which figures can be booked. This dimension has a unary operator. In this example I have three accounts: "Net interest income" and "Global operation allocations". These two accounts have the same parent "Net result". Besides the account dimension there is a scenario dimension which contains three scenarios: Actual, Budget and Variance. On every account can be indicated whether it is a "Expense Reporting" account. If this is the case the Variance is calculated by "Budget - Actual", otherwise this is calculated by "Actual - Budget". I implemented this by the following calculation script in the cube: -- Calculate Variance scenario SCOPE ([Scenario].[Scenario].[Variance]); SCOPE ([Account].[Expense Reporting].&[True]); THIS = [Scenario].[Scenario].[Budget] - [Scenario].[Scenario].[Actual]; END SCOPE; SCOPE ([Account].[Expense Reporting].&[False]); THIS = [Scenario].[Scenario].[Actual] - [Scenario].[Scenario].[Budget]; END SCOPE; END SCOPE; So far, so good: the variance is calculated correctly for the accounts on which the data is loaded: "Net interest income" and "Global operation allocations". However, on the account

View Complete Post

More Related Resource Links

Creating a volume control slider/setting one template property based on another

So, what I want to do, is to make a volume control that looks like a right angle triangle with the 90 degree angle on the bottom right, and then when you click on it, the area to the left of the selected point is shown in a different color.  In other words, I've created a slider with the right background, what I can't do, is work out how to show the selected area by filling in the triangle.  I have worked out how to bind the height of my triangle on the left to the value of the control, but right now, the rate of rise is exactly half of what I need it to be.  I need to know how to change the template for the area to the left of the selection ( which is the repeat button ) so that the background is twice the height that it is right now.  No matter what size I make the slider, the area is always 1/2 the size it needs to be, so I am sure if I could get it to double inside my template, it would work fine. <ResourceDictionary xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"     xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml">       <Style x:Key="SliderButtonStyle" TargetType="{x:Type RepeatButton}">         <Setter Property="SnapsToDevicePixels" Value="true"/>         <

How can I get a user list based on a specific profile property.

Hi,I am trying to query a DB and get a list of users based on a specific boolean property stored in the aspnet_profile for that user.I am aware that it wasn't possible a few years ago (http://forums.asp.net/p/988051/1277359.aspx), but was wondering whether that had changed in recent releases, or it was still not possible without trawling through the entire list of users and testing them one by one.  (My DB may become way to big for that.)Thanks in advance for any help.Regards,Ben

set the Report URL property to a specific report dynamically based on the selection in the list.

Hi I want to use  embedding the Report Viewer Web Part in a Web page, and I know we  should set the Report URL property to a specific report. but  is there a way by which we can set the url  dynamically based on the selection of the report  from  the list How can I customize this  feature Any Help on this is appreciated. Thanks

UseExplicit property in infopath with form based context

Hi everyone, I have a problem with my infopath form. The context, user of the site mustn't have acces to lists that provision infopath form field. Administrator should have acces to these lists. When i test the useExplicit property of udc file for impersonate the connection to the list i have no problem ( all my account are local account) But when i try to integrate user from FBA, infopath form services don't take care of the UseExplicit property and try connect to the list with the credential of the connected user ( who don't have access to the list since only the user that i use to impersonate the connection have read acces). Here is my UseExplicit property :  <udc:Authentication>    <udc:UseExplicit CredentialType="NTLM">      <udc:UserId>dev\svc-reader</udc:UserId>      <udc:Password>password</udc:Password>    </udc:UseExplicit>  </udc:Authentication>    09/06/2010 15:06:50.46                w3wp.exe (0x09BC)                                      0x1A08 SharePoint Foundation                General                      

How to calculate a SQL Server performance of a query based upon table schema, table size, and availa

Hi What is the best way to calculate (without actual access to a SQL Server) the processing speed of a query (self-inner-join) based upon table schema, table size, and hardware (CPU, RAM, Drives)? ThanksThanks Jeff in Seattle

DataTemplate binding based on object property


I have a collection of objects that I'm giving visual representation in my UI through DataTemplates. Each object has a string property "field". 

Is it possible for my UI to exclude specific objects in my collection from being shown based on the "field" property if it contains a string "foo"? 



Enable/Disable Buttons based on another control property


Say i have a tab control that displays data of various types, eg EditorTabViewModel (eg. code view of WYSIWYG), PreviewTabViewModel (eg. preview of WYSIWYG) both inheriting from TabViewModel . The implementation is similar to the tutorial on MSDN

I want to enable/disable buttons depending on the active tab, whether its an EditorTabViewModel or a PreviewTabViewModel and maybe based even on properties of the ViewModel?. How can I achieve this?

Calculate a Field Based on Approval Status


I have a list that coordinates purchasing approval and tracks our budget.  Someone submited a new item to the list with Estimated Cost, Vendor, Description, etc.  When a new item is submitted, it triggers a workflow that sends it to me as the purchasing approver.  I approve the task and it noties everyone and puts the Approval colum as Approved.  This is all out of the box functioning.  I don't have designer on our network yet (working on it).

What I want to do now is create a column that checks the approval status and if it's approved puts the estimated cost in the column, if it's not approved, it puts 0.  This way I can sum that column to track the expenditures of only approved purchases and ignore the ones I disapproved.  This will allow me to have an accurate picture of how much money we have without having to totally delete a purchase request out of the list.

I've tried using the calulcated field for a new column but it doesn't like having to look at approval status.  I've tried it as both text and integer.  IE "=IF([Approval Status]='Approved',[Estimated Cost],0)" as well as "=IF([Approval Status]=16,[Estimated Cost],0)" as 16 is the number in datasheet view for approval.  Neither of them works as it doesn't like the approval status column use in general.

Adjust document permission based on custom property-field (owner person or group)


I would like to setup a workflow so everytime a user adds a new document to a document library the workflow adjusts the documents permissions.

I've added a new field to the document library settings which I called "Owner". This field searches persons or groups in the active directory. The person of group that I fill in here has to get contribute-permissions for this document. This process needs to be automatic so I think I have to build a workflow.

Who has got experience with this? Who can help me? Can I do this with the Sharepoint Designer?

The system we use is a sharepoint server WSS3.0

How do I automaticaly change one property based on another with MVVM?



I have a grid connected to a ViewModel class with two properties, public Address SelectedAddress and public ObservableCollection<Address> Addresses.

Address has, among other things, int? PersonID and int? CompanyID. My validation code in the Model checks that one of them is filled, but not both.

How do I set up code in the grid or ViewModel so that whenever PersonID is filled, CompanyID is automatically set to null, and the other way?



MDX to calculate average based on the diemension of Analysis



I have a scenario where the count of dimension values need to be used in the calculation.

For Example:

Lets have 2 dimensions

Dim_SalesGroup and Dim_Product. And, I have one measure as Count of Items Sold as MEAS_CNT.

Now, I need to create a calculted member which should satisfies the follwing calculation

MEAS_CNT / (Count of Dimension members in Axis)

If we slice with Dim_SalesGroup then it should be like

MEAS_CNT / (Count of Dimension members in Dim_SalesGroup)

If we slice with Dim_Product then it should be like

MEAS_CNT / (Count of Dimension members in Dim_Product).


Please suggest me some calculation.


Thanks in advance.



Web part to retrieve List Items based on configurable property


I want to create a web part that will do the following

1) Have a custom choice property based on teh Choice List Column in the list.

2) Return the records based on the custom choice selected by the user.


Is this possible?


5 GridView Themes Based on Google's Personalized Homepage (igoogle)

One of the silly features I have found that I like about igoogle is how the pages color palette changes depending upon the time of day. So as the day progresses from morning to afternoon to evening the colors on the page change as well. Like I said, I know this is a silly feature, but I like it. And I have asked around a little bit and seems like other people like it to. To get a better idea of how the colors change, here are the background images from a few of the HTML elements.

WPF / Silverlight tutorial: Visibility property and binding

Visibility property is a very powerful and yet often overlooked property available in both WPF and Silverlight. It enables you to set Visibility of certain UIElement objects to different states like: Visible, Collapsed and Hidden (not supported by Silverlight). This tutorial shows you how to use it and how to bind to Visibility property

abstract away the source of the connection string using a class with a static property.

ASP.NET provides a configuration system we can use to keep our applications flexible at runtime. In this article we will examine some tips and best practices for using the configuration system for the best results.

The element of a web.config file is a place to store connection strings, server names, file paths, and other miscellaneous settings needed by an application to perform work. The items inside appSettings are items that need to be configurable depending upon the environment, for instance, any database connection strings will change as you move your application from a testing and staging server into production.

Let's abstract away the source of the connection string using a class with a static property.

Calculate distance, bearing and more between Latitude/Longitude points

This page presents a variety of calculations for latitude/longitude points, with the formulæ and code fragments for implementing them.

All these formulæ are for calculations on the basis of a spherical earth (ignoring ellipsoidal effects) - which is accurate enough* for most purposes. [In fact, the earth is very slightly ellipsoidal; using a spherical model gives errors typically up to 0.3% - see notes for further details].

How to calculate the distance between two points on the Earth

We offer many Global Database Products that you can use with the below formulas to calculate distances and many other uses. Not sure how to use distance calculations or global databases within your company? See our Global Database Examples for more information on how to use our data within your industry. Be sure to Download a Free Sample of one of our many Global Database Products.
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