Want to make fiscal quarters from fiscal periods in Info design tools

[Former Member]

Dear Gurus:

I have new reporting requirement for fiscal quarters, currently I have fiscal periods and fiscal years in my business layers. I have two questions from you guys.

1) Which is the better way to achieve this. Should I try to make it in IDT or Should we make it in BW and then load data again. Also if there is an impact on performance choosing any of the options.

2) If I made it IDT how should I achieve this, considering I need prompt on fiscal quarters dimension.

Best Regards:

Jawad K. Sheikh

[former_member4998 · Accepted solution]

Hi

If BW as back-end of your dashboard, as per the best practice, pushed down to database level all the predefined time periods and include at the Bex Query level.

So in the BO dash board we can just drag and drop. So it’s will improve the performance also.

Please find the below like’s  Universe Optimization Techniques, pushed down all the calculation to database level

http://scn.sap.com/community/semantic-layer/blog/2014/05/14/universe-optimization-techniques

[Former Member · Accepted solution]

HI Sreenivasulu Dasari

THANKS FOR THE GREAT INFORMATION.