Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

some kind of "dynamic" dimension

2 posters

Go down

some kind of  "dynamic" dimension Empty some kind of "dynamic" dimension

Post  nickall Thu Dec 10, 2009 5:46 am

Hi All,

I'd like to model a numeric value with range 0-100 in two different ways in the same cube.
Sometime it's helpful to have it as a dimension, and sometimes it's helpful to calculate the avg and have it as a measure.
When the user wants to see it as a measure the dimension will be hidden, on the other hand when the user wants to see it as a dimension the measure(avg) will be hidden.
Can I model a situation like this or do I have to use two different cubes?

Tnx in advance

nickall

nickall

Posts : 5
Join date : 2009-12-10

Back to top Go down

some kind of  "dynamic" dimension Empty Re: some kind of "dynamic" dimension

Post  ngalemmo Fri Dec 11, 2009 4:23 am

Don't know what MDDB sytem you are using, but couldn't you load the same value twice? Once as a measure and once as a dimension?
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

some kind of  "dynamic" dimension Empty Re: some kind of "dynamic" dimension

Post  nickall Fri Dec 11, 2009 6:17 am

ngalemmo wrote:Don't know what MDDB sytem you are using, but couldn't you load the same value twice? Once as a measure and once as a dimension?

I'm using pentaho community version.
Yes i can load the same value twice, but it doesn't make sense if i watch at the primary events.
In this case i have a measure (avg) and the dimension value that are the same thing.

nickall

Posts : 5
Join date : 2009-12-10

Back to top Go down

some kind of  "dynamic" dimension Empty Re: some kind of "dynamic" dimension

Post  ngalemmo Fri Dec 11, 2009 12:12 pm

But it would work at aggregate levels above the dimension, correct? Just use either the measure or the dimension in your analyisis...
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

some kind of  "dynamic" dimension Empty Re: some kind of "dynamic" dimension

Post  nickall Mon Dec 14, 2009 7:02 am

Yes, it would work at the aggregate levels! but i'd like to make it work with the primary events!

nickall

Posts : 5
Join date : 2009-12-10

Back to top Go down

some kind of  "dynamic" dimension Empty Re: some kind of "dynamic" dimension

Post  ngalemmo Tue Dec 15, 2009 2:55 am

What, exactly, is a primary event? Is the numeric dimension a definer of a primary event or may a primary event contain multiple numeric values? In either case, if you exclude the numeric dimension in the analysis of a primary event, the avg(measure) will calculate correctly.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

some kind of  "dynamic" dimension Empty Re: some kind of "dynamic" dimension

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum