Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
row based calculations
Hi,
I am using OBIEE version 11.1.1.7.15. I have an analysis that compares months vs month previous year
For example
| Month | Sales | Sold |
| Jan-14 | 100 | 45 |
| Jan-15 | 80 | 60 |
| Feb-14 | 66 | 45 |
| Feb-15 | 77 | 35 |
| Mar-14 | 34 | 23 |
| Mar-15 | 23 | 12 |
I would like to add a row calculation for each month that looks at the variance between the months, like below. I tried to add a new calculated item but that would be required for each month
| Month | Sales | Sold |
| Jan-14 | 100 | 45 |
| Jan-15 | 80 | 60 |
| Variance | 0.8 | 1.3 |
| Feb-14 | 66 | 45 |
| Feb-15 | 77 | 35 |
| Variance | 1.1 | 0.8 |
| Mar-14 | 34 | 23 |
| Mar-15 | 23 | 12 |
| Variance | 0.6 | 0.5 |
Can anyone suggest the best way to add this calculation at row level into the pivot table?
Thanks
Answers
-
calculate your variance in the criteria tab, then put measure labels as the row and month-year as the columns ...
0 -
Hi,
I followed this method, placed all measures onto row axis, month onto measure labels and measure section(one measure is required) but not giving the required layout.
0 -
Your layout won't work as your Variance % is not a dimensional attribute of Time - it's a measure label.
The force of a good BI program is:
Answers at the speed of thought - can people get accurate information and does the system perform?
Delivery at the speed of business - can new insights be developed and made available before the 'window of opportunity' expires?
Don't waste good cycles after non-value-added items ...
0 -
Hehe good one.
0