Forum Stats

  • 3,817,447 Users
  • 2,259,334 Discussions
  • 7,893,776 Comments

Discussions

one dimension and two fact report in OBIEE

Dear All,

I have one dimension "region" and two facts (Sales value & Gross margin%). Gross margin% is logical column which has been derived from two other facts column and it's value is in range from Zero to 100.

Now, I want to generate below report. For each gross margin% range of 5%, I want to sum the sales value for each region. Please assist (Just a small snapshot of report)

GM% Region_1 Region_2
<0 254 619
0-0.05 524 799

Thanks & Regards,
[email protected]
Tagged:

Answers

This discussion has been closed.