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 ParticularPeriod1% of total CustomerPeriod 2%Total Customer Billed36,636100%40,195100%Customer Billed SKU : 31+3171%4041%Customer Billed SKU: 21-305572%1,1473%Customer Billed SKU: 16-201,0393%1,2953%Customer Billed SKU: 11-153,0118%3,5909%Customer Billed SKUe: 6-109,00325%10,62326%Customer Billed SKU: 1-522,70962%23,13658% ParticularPeriod1% of total CustomerPeriod 2%Total Customer Billed36,636100%40,195100%Customer Billed SKU : 31+3171%4041%Customer Billed SKU: 21-305572%1,1473%Customer Billed SKU: 16-201,0393%1,2953%Customer Billed SKU: 11-153,0118%3,5909%Customer Billed SKUe: 6-109,00325%10,62326%Customer Billed SKU: 1-522,70962%23,13658% How can we achieve this in OBIEE 10g? Thanks Prakash

Oracle Communities

Oracle Analytics and AI

Child Item

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

Find more posts tagged with

Accepted answers

All comments

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