Bex Query Performance?

[Former Member]

Hi...i am designing a report where i need to show sales figures for current fiscal year period...should i take this fiscal year variant in filter of the query of create a restricted key figure...which is the best method and why...thank you for your replies....

[Ashwin]

Hi!

I think filtering the fiscal year is more convienient in your case. and I dont think there will be any significant performance difference between diltering the keyfigures using ristricted key figure and direct filtering of fiscal year.

if you want to improve the performance of your query try maintaining agregates in your cube.

with regards

ashwin

[former_member181964]

Hi,

You can take directly fiscal year period and restrict it.

Thanks

Surendra

[Former Member]

you can keep the fiscal year variant in filters and i don't understand why you want to create restricted key figure for current fiscal yeard period.

you can directly restrict sales figures with fiscal year period variable.