Skip to Content
0
Dec 06, 2006 at 01:45 AM

BEx Query Help with 0CALDAY

28 Views

Hi All!

I need help with a BEx Query.

I have a Cube, this cube update all days from a extractor. From this cube i make a lot of querys but i cant make this query.

In the row i have the characteristic 0PLANT, in the columns, i have the months (Jan, Feb, Mar... etc). The user must enter FISCPER3 AND FISCYEAR.

The query list all the months empty, only the FISCPER3 inserted must be showed. But not all registries of this month, only shows the registers of first day of entered month.

Ex: if the user enter FISCPER3= 8 and FISCYEAR= 2006, all the months are empty, only show Aug. But only for the day 01.08.2006

What can i do?

Thank you!