TOPN Function in OTBI

Sheneli98

Summary:

Content (required):

Hi,

The ultimate requirement is to create a dashboard;

Analysis 1 - Annual Revenue in a Bar chart

Analysis 2 - Revenue for each cost center in the year prompted (Bar Chart)

Analysis 3 - Top 5 revenues for the cost center prompted.

However, when analysis 3 is run, the ranking is done based on the cost center WITHOUT considering the year. For the ranking I have used TOPN("Base"."Base Equivalent Period Net Activity"*-1,5 BY "Cost Center Segment"."Cost Center Description"). How do I group this with year?

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Mihaela Cozma GL-Oracle

Dear Sheneli,

For the best response to your question, I moved the post under General Transactional Reporting (OTBI) forum, where members of the Customer Connect community will be able to share their own experiences, best practices and helpful solutions with you.

Regards,

Mihaela