Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
RSUM in OBIEE with other fields other than date
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 |
Answers
-
Field2 Value1 & Field1 Value4 are adding what value to the information displayed? It is unclear given how you've represented your pivot table.
0 -
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?
0 -
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
0 -
how does your logical star look like? I assume Revenue is indeed a measure column from a fact table ...
0 -
Hi, Sir Dodds.
It's just a simple star (Fact - Calendar). Revenue is computed as Txn count * Face value amount.
0 -
What table is the column headers coming from?
0