You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need Help to Calc Number of Days for Daily Cube

in EPM Platform and Freeform 2 comments

Summary:

Need Help to Calc Number of Days for Daily Cube

Content (please ensure you mask any confidential information):

I need to calculate number of days but it is not calculating correctly for day of the week rollup member DOW. DOW is Dense dimension. It is the third dense dimension in the outline: Account, Period, DOW

Data is loaded by day. For example, Nov 1 is Sat, so it should be 1 for Sat and the parent DOW because users will be using DOW for reporting purposes. However, it is calculating 8 for DOW. No_DOW is ~ member.

IF (@ISMBR ("Mon","Tue","Wed","Thu","Fri","Sat","Sun","DOW","Total_DOW","DOW_Adj"))

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!