Grouping measures and counting group members in OBIEE 10g

user8680861

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

Thomas Dodds

"Percent of" in OBIEE pivot-tables - Andreas Nobbmann - Blogs - triBLOG

user8680861

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

Robert Angel

Not sure what a SKU is but have you looked into case logic or buckets to fulfil this requirement?

user8680861

Thanks for your Reply, SKU is the product . Who to create buckets in OBIEE 10g?

Robert Angel

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.

Robert Angel

For an example see =>

https://oraclebizint.wordpress.com/2007/12/05/oracle-bi-ee-101332-bins-and-groups/

[Deleted User]

Quoting Venkat...man that makes one feel old