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

Measure with aggregate None ...

  
   Database Forums (Home) -> Data Warehouse RSS
Next:  Logging in to a database  
Author Message
Harry Leboeuf

External


Since: Sep 28, 2007
Posts: 16



(Msg. 1) Posted: Mon Jan 21, 2008 1:00 pm
Post subject: Measure with aggregate None ...
Archived from groups: microsoft>public>sqlserver>datawarehouse (more info?)
I have a measure that can't be aggregated (forecasted average item price per
month per productgroup), only values calculated based on this measure can be
calculated.
I have set its Aggreagatefunction to none.

But when i'm browsing the cube and go down to the 3 dimensions wich this
MeasureGroup in used in i still can't see any values. No other dimensions
are used in thos browse.

This used in means that in the Dimension Usage this measure group is linked
to these dimensions.

I thought that at this level at least i should have seen values.

 >> Stay informed about: Measure with aggregate None ... 
Back to top
Login to vote
Harry Leboeuf

External


Since: Sep 28, 2007
Posts: 16



(Msg. 2) Posted: Mon Jan 21, 2008 1:00 pm
Post subject: Re: Measure with aggregate None ... [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Sorry wrong Forum, i've re-posted it in Olap.

 >> Stay informed about: Measure with aggregate None ... 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Measure data disappears - help!! can someone please help me. I built a simple cube with three tables in. When i clicked on the data tab within the cube editor i can see my cube data. When i clicked on save the measure data disappear and just my dimensions stayed there and i could...

Measure Count where CustID is -1 - I have changed the underlying database so all NULLs are now -1 with a corresponding dimension of -1 as -- Not Known -- But now i am having trouble doing the counts I want. How do I create a measure where I can: get a count of all CustID = -1 in my FAC...

MDX: Retrieving same Measure based on 2 Different Dimensio.. - Hi, I am new to MDX and is stuck up on a problem which i feel is quite common. We have a Cube named 'User' Measures for the cube: 1.. M1 2.. M2 Dimensions for the cube: 1.. D1 2.. D2 Both D1 and D2 have been created as named querie...

Measure change updates in Fact tables - Is there an industry standard method to populate Fact table columns with the amount of change of a measure from one row to the next? I have a FactSubscriptions (1 row = 1 week), and I wold like to have a column of the price change from the previous..

[SSAS] Display no measure for time aggregation? - Hi, I have daily mesures that I do not want to aggregate (sum or whatever) along the Time dimension because it does not makes sense. These values are for example the daily exchange rate of currencies. How a yerly exchange rate can makes sense??? So Whe...
   Database Forums (Home) -> Data Warehouse 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 ]