Hello Friends,
I have the below scenario:
We have few conformed dimensions and 1 non-conformed dimension.
As of now, I have only displayed 1 conformed dimension(i.e, Project Number)
We have 2 Facts: Revenue and Cost
| Date | Project | Gross Revenue | Net Revenue | Cost | Event |
| 1-Mar-16 | 31250 | 0 | 0 | 300 | |
| 2-Mar-16 | 31250 | 1000 | 500 | 500 | A |
| 3-Mar-16 | 31250 | 2000 | 500 | 1500 | B |
| 3-Mar-16 | 31250 | 2000 | 500 | 1500 | C |
| Event | View |
| A | Operational |
| B | Operational |
| C | Fiscal |
We have a prompt of Event View on the dashboard
Event has a relation with Revenue fact only.
Currently, we have our revenue measures being calculated by population of session variable from the Event View prompt.
The issue, is whenever I display the Event from the dimension, I loose the record of the cost on the report.
There can be transactions associated with cost and without revenue.
Hence, I cannot have Event at All level for the cost. We would end up in missing the cost records when the report is generated for Mar 1 2016 which has no revenue and only cost.
Now, the requirement is to display Event on the report.
As the Event from the dimension has the above issue, I tried populating the event into the revenue fact, and I use the event from the revenue fact on the report,
I am still not able to report the event .
The OBI is not firing the query with the Cost fact.
Can anyone please suggest on how to handle this scenario?
Thanks
Shravan