Thanks alot for your help

Thanks for your reply. So how much does it cost to buy a user license? Is there a possibility to change my license from user license to something more flexible?

Thank you so much. This will do. Appreciated.

Yes, The link to OBIEE home page. Instead of https://host:port/Analytics/saw.ddl?bieehome, I need to show "CIB Data Portal", just a text instead of the link.

Okay, I built the snapshot fact table. I dont understand how will I filter the measure from the snapshot to captrue the end of last year data, as im filtering on a specific date from the time dimension?

thank you so much for replying. Actually this has caused the amount to be aggregated incorrectly. The link provided above soted it out

Yes you are right. It took so long to run the report and I also couldnt manage to calculate the change. Can you please illustrate your approach in more details? How can I get the measure from the snapshot to filter on month12/year -1 while filtering on a specific date from the time dimension? Thanks, Noha

Hi Thomas, Thank you for the reply. I'm not sure I understand how can this be implemented. However, I used AGO function with a presentation variable holding the Month as an offset parameter. And it worked just fine.