Value Banding linked to a calculation

robhale at 04h51
08
Oct
2009
Value Banding linked to a calculation

I have an interesting problem - how to hook up value bands to fact rows that require a computation.

I have a fact table where the measure I'm interested in is a percentage. In order to cope with roll-ups I am storing the actual and the divisor as separate additive facts.

For example:
ROW1: M_ACTUAL = 10, M_DIVISOR = 40
ROW2: M_ACTUAL = 10, M_DIVISOR = 20

I can aggregate the above two

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
1 Dimension used multiple times in 1 fact table?
Hello, I have a dimension used to store several types of 'bands' like monthly income bands, available income bands, risk bands, settlement bands etc. If I leave out all the lineage columns this is what the dimension looks like: DimBandID BandType
inventory snapshot - GMROI calculation
Hoping someone can advise on this. I've got the DW Toolkit book and it's been invaluable in setting up a simple retail sales fact table with conformed dimensions. We've now moved on to chapter 3: inventory and our users have requested a stock snapshot,
Inventory Snapshot - GMROI Calculation
We are developing a solution for our company. We currently have a sales cube and we are in the process of building an inventory cube. We are having a design problem in that we are not sure if we should include some of the measures which currently exist in
Measures as Dimensions: Banding Approach Help
I have a standard fact table with a number measures; several of which are in the form of time (e.g., minutes) and others in the form of integers. The fact table and related dimensions are exposed to users via BusinessObjects XI v2 Web Intelligence. One of
My forum is linked to another address.
My forum is http://gabamiencs.forumvi.net. Today, I can't go to my forum because it is linked to http://http://pagesinxt.com/ Please help me check this problem. I don't configure anything in Administrator. Thanks a lot.
Forums from same category
See also
more_less
Informations

1 Replies For the topic :
"Value Banding linked to a calculation"

This topic has been viewed 988 times.

Last message :
08/10/2009 at 04h51 by "robhale"