on 03-31-2016 10:44 AM
Hello everyone,
I need to know if it is possible to do a drill down with a raking on Business Object.
In my case, i have the turnover of each BU for the year 2016 for example, i want to use the ranking to have only the top 10 of turnovers, and in the same time to use a drill down to have results by months.
My problem that is works for the years, but when i explore by months it does not works.
Thank you for your help
Hi Soufiane,
How have you defined the rank measure? You would have used logic something like:
=Rank ([Turnover measure];[Year];Top)
Is it correct? If yes, then it is calculating the rank with respect of [Year]. Drilling down will change the dimension to [Month] and ranking might get affected.
Workaround #1:
An idea can be:
- Remove drilling.
- Create another query for Month data and put prompt on Year value.
- Create another tab 'Month' in same report.
- Create block with Month , turnover measure and rank (applied w.r.t. month).
- Put a hyper link in Year column in first tab 'Year' as follows:
< a href= '../../opendoc/openDocument.jsp?iDocID=<<CUID>>&sIDType=CUID&sType=wid&sReportName=Month&sWindow=Same> [Year] </a>
- Define the first column as "Read content as Hyperlink" inside Properties.
- Once this link will be clicked, the Year value will be passed to 'Month' tab & you will get monthly data with proper ranking.
It is just an idea as I have not tried it practically!!
Workaround #2:
You may also use DrillFilter () and define the Rank function. Something like:
=If ( DrillFilter([Month]) = <<Year_value>> ) Then =Rank ([Turnover measure];[Year];Top)
Else Rank ([Turnover measure];[Month];Top)
Hope it will help in some way.
Regards,
Yuvraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Soufiane,
Would you be able to attach few pics with sample data? Those pics should be able to answer the below questions, so we can help you better.
Thanks,
Mahboob Mohammed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.