Solved: How to get quarter from the current month in bpc 1... - SAP Community

Hi,

I am struggling to get the quarter for the current month. Is it possible from the memberoffset?

Please suggest.

Regards.

Surya

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Accepted Solutions (1)

HI Surya,

Use below formula

=EPMMemberOffset(,F8,,1)

where F8 is member and select level =1

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Surya,

In my time dimension i have hierarchy like Year--- Qtr----Month

in level parameter if i select 0 then it will return year and if i select 1 then it will show in it's qtr

Thank you sir

Answers (0)

Ask a Question