Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Daily period in Financials

Summary:

What's the best way to model a sales cube with daily data for a pre-built module application

Content (required):

Hello, My client requires loading the company's daily sales into Planning. It currently has a pre-built application (Financials). I have thought of building a dimension of days that would have Day 1 to Day 31, with parents of weeks and fortnights. But I think it would prevent me from applying the capabilities of Predictive Planning and now IPM because it is not the time dimension for Planning. Is it possible that I can handle all the calendar detail in the period dimension? Any suggestion? I was thinking of creating a hierarchy of weeks and days and then mapping it to

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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