Forum Stats

  • 3,851,925 Users
  • 2,264,053 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]


This discussion has been closed.