Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Calculated measure based on dimension property

 
   Database Help (Home) -> OLAP RSS
Next:  Stock Market NewsPaper-Trial Offer  
Author Message
jazpar

External


Since: Dec 02, 2008
Posts: 2



(Msg. 1) Posted: Wed Jan 21, 2009 6:55 am
Post subject: Calculated measure based on dimension property
Archived from groups: microsoft>public>sqlserver>olap (more info?)

Hi

I have a measure called
[Measures].[Beløb DKK] (that is Amount in danish exchange)

I have a dimension called Finanskonto.
On the dimension is a property

[Finanskonto].[Finanskonto].Currentmember.Properties( "Calc Gruppe")

What i would like is to sum of the amount of all finanskonto where
the
Properties is "IRRE".

But I cant get this to work.
I have tried this
([Measures].[Beløb DKK],[Finanskonto].
[Finanskonto].Currentmember.Properties( "Calc Gruppe")= "IRRE")

but this returns only #VALUE!

Hope anyone could be of help for me.

BR/Thanks

Jan

 >> Stay informed about: Calculated measure based on dimension property 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Calculated measure based on a dimension - I have a dimension called servicer group with 2 levels ServicerGroup Servicer Here are some members in each group SerivcerGroup Not Assigned Outside Internal Servicer Agency 1 Agency 2 Agency 3 I create a calculated measure which work..

Look up Dimension value based on Measure.. plz Help! - Guys, I have what I hope is a VERY simple MDX problem. I am building a SSAS 2005 cube and I have a "minimum product type" measure like this: Min Product Type ===================== Jason 5 Adrian 1 Jesse ...

Returning a value for a measure evaluated over a set in a .. - I'm having a lot of problems trying to create a calculated measure that returns the value of another measure over a specified time series. If I run a select to return the data there is no problem and the select statement I'm using looks like the..

Find Dimension Measure.. - Sorry for the repost - I haven't heard from anyone as of yet: Guys, I have what I hope is a VERY simple MDX problem. I am building a SSAS 2005 cube and I have a "minimum product type" measure like this: Min Product Type..

Linking a dimension to the intermediate measure group - Hi all, I'm trying to build a cube that involves a many-to-many relationship (i.e. two measure groups, where every measure group contains a measure that I have to display to the user). When I use the dimension related to the intermediate fact table of m...
   Database Help (Home) -> OLAP All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]