RSUM in OBIEE with other fields other than date

2999400

Hi, OBIEE experts.

For your kind assistance, how can i do this in OBIEE:

Where in Daily average is computed by RSUM / Calendar Day. every time i try to add field1 & field2 in my pivot table i got different result for my RSUM.

   

	Field2 value1			Field2 value4
	Field1 value1			Field1 value4
Date	Revenue	Daily Average	RSUM	Revenue	Daily Average	RSUM
3/1/2016	10	10	10	20	20	20
3/2/2016	11	10.5	21	21	20.5	41
3/3/2016	12	11	33	22	21	63
3/4/2016	13	11.5	46	23	21.5	86
3/5/2016	14	12	60	24	22	110
3/6/2016	15	12.5	75	25	22.5	135

Thomas Dodds

Field2 Value1 & Field1 Value4 are adding what value to the information displayed?  It is unclear given how you've represented your pivot table.

SriniVEERAVALLI

Based on above all is good.

can you share different result value?

Btw: did you try with field1 & field2 with your own calculation instead of pivot table calculation?

2999400

Hi,

in OBIEE i got the wrong values, the rsum column is just the same as the revenue column.

*RSUM is the running sum of Revenue column.

*Daily Average = RSUM / Calendar Date Number

Thomas Dodds

how does your logical star look like?  I assume Revenue is indeed a measure column from a fact table ...

2999400

Hi, Sir Dodds.

It's just a simple star (Fact - Calendar). Revenue is computed as Txn count * Face value amount.

Thomas Dodds

What table is the column headers coming from?