Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 232 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Grouping measures and counting group members in OBIEE 10g
I have a requirement, a sales transaction table with the customer & Product details. Need to create ta report in OBIEE 10g in the following format
Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā
| Particular | Period1 | % of totalĀ Ā Customer | Period 2 | % |
| Total CustomerĀ Ā Billed | 36,636 | 100% | 40,195 | 100% |
| CustomerĀ Ā Billed SKU :Ā Ā Ā 31+ | 317 | 1% | 404 | 1% |
| CustomerĀ Ā Billed SKU:Ā Ā Ā 21-30 | 557 | 2% | 1,147 | 3% |
| CustomerĀ Ā Billed SKU:Ā Ā Ā 16-20 | 1,039 | 3% | 1,295 | 3% |
| CustomerĀ Ā Billed SKU:Ā Ā Ā 11-15 | 3,011 | 8% | 3,590 | 9% |
| CustomerĀ Ā Billed SKUe:Ā Ā Ā 6-10 | 9,003 | 25% | 10,623 | 26% |
| CustomerĀ Ā Billed SKU:Ā Ā Ā 1-5 | 22,709 | 62% | 23,136 | 58% |
| Particular | Period1 | % of total Customer | Period 2 | % |
| Total Customer Billed | 36,636 | 100% | 40,195 | 100% |
| Customer Billed SKU :Ā Ā Ā 31+ | 317 | 1% | 404 | 1% |
| Customer Billed SKU:Ā Ā Ā 21-30 | 557 | 2% | 1,147 | 3% |
| Customer Billed SKU:Ā Ā Ā 16-20 | 1,039 | 3% | 1,295 | 3% |
| Customer Billed SKU:Ā Ā Ā 11-15 | 3,011 | 8% | 3,590 | 9% |
| Customer Billed SKUe:Ā Ā Ā 6-10 | 9,003 | 25% | 10,623 | 26% |
| Customer Billed SKU:Ā Ā Ā 1-5 | 22,709 | 62% | 23,136 | 58% |
How can we achieve this in OBIEE 10g?
Thanks
Prakash
Answers
-
-
Thanks for your reply, this will definitely help in terms of deriving the % values. Can you please also suggest some approach on creating the data bucketing from the transaction table. for instance deriving the no of customer billed 31+ SKUs for the specific period.
Thanks
0 -
Not sure what a SKU is but have you looked into case logic or buckets to fulfil this requirement?
0 -
Thanks for your Reply, SKU is the product . Who to create buckets in OBIEE 10g?
0 -
Sorry, senior moment, I meant to say BINS, you should find the functionality under the formula editor, essentially it just wraps a case statement, so if this is not available in 10 then look into using case to group your products, it is on the formula examples.
0 -
For an example see =>
https://oraclebizint.wordpress.com/2007/12/05/oracle-bi-ee-101332-bins-and-groups/
0 -
Quoting Venkat...man that makes one feel old
0