Default selection on current month, week and date

[Former Member]

Hi,

We are on Dashboard 4.1 sp3 the same version as BI.

The dashboard report is using LiveOffice connection. We are now facing an issue with default selection on current month, week and date.

The dashboard report drilled down from month, to week, then to date. The dashboard feed -live office report is on month/week/date ascending order - becuase we have running average calcualtion on LO report, it seems have to be in ascending order to get the correnct runnning average.

I tried to on Insertion to change default seletion, it works on month, but it doesnt working on week and daily.

but when LO report is on ascending order, on dashboard column chart the default selection is not on the current month, week and date.

Is there a way to solve the issue. Could anyone please help.

Thanks,

[former_member182541 · Accepted solution]

Hi Dave,

This is functionality is not possible in Column chart, if you check the selector components we have a provision of selecting the item box where we can specify the default selection at the time of invoking the dashboard, but in case of chart there is no option.

As a workaround can try displaying the chart in descending order to make the default selection in current month.

--SumanT

[Former Member · Accepted solution]

Hi Suman,

Thanks for the quick reply.

Do you mean I Enable sorting -by categrory labels on Behaviour - common tab.

Thanks,

[former_member182541 · Accepted solution]

No, this is will make you month to display in alphabetical order rather than the normal order JAN -DEC. If you have used webi then custom sort is possible to change the order.

[Former Member · Accepted solution]

Thanks Suman

[former_member182541 · Accepted solution]

Hi Dave,

Have you solved the issue, or else have found any workaround on this.

--SumanT

[Former Member · Accepted solution]

Hi Suman,

Yes, I found a workaround, and the problem is solved.

Thanks for the input

[former_member182541 · Accepted solution]

if possible can i know that.

[Former Member · Accepted solution]

Hi Suman,

I solved it on webi, as the dashboard report is based on LiveOffice. So i did the workaround on the webi report. please refer http://scn.sap.com/thread/3581599 if you are having similar issue.

Thanks,

[former_member182541 · Accepted solution]

Thanks Dave.