Dynamic reporting for weekly and monthly

Hi All,

I need a suggestion on below requirement.

I want to create a P&L report where by current month data should be shown at a weekly level for current month and show the month total and the remaining months in R12 will be planned at a monthly level

Can this be possible in a single grid(single module), to publish as a single report.

so, that when my current month is changed, it dynamically change my report view to current month as weekly and remaining as monthly.

Thanks & Regards,

Madhu

Accepted answers

All comments

ArunManickam

Possible. This is more like a telescopic non-linear view.

You need to create a custom time scale which has elements created accordingly. Your custom time scale will look like this,

Thanks

Arun

NakulAggarwal

Hi @MadhabikaM

few questions :-

1. Is it an output report or planning Grid (in rest 11 months will you Input or Just view) ?

2. Will your current month be from a List selector or Model Settings ?

3. Are you using a Native Time List or Dummy ?

Thanks,

Nakul

MadhabikaM

Hi Nakul,
Please find my response below:
1. Is it an output report or planning Grid (in rest 11 months will you Input or Just view) ?
Its a reporting grid, it will be just view in rest 11 months

2. Will your current month be from a List selector or Model Settings ?
My current month would be from my Model setting, and my calendar type in setting is weekly 5-4-4(Just FYI)

3. Are you using a Native Time List or Dummy ?
We are using anaplan native time List, but version used is customized we are not using native version provided.

Regards
Madhu

jackcplanning

Since you're using the native time series, I think you're after a time filter in the reporting view. Try the following and let me know if it works for you:

In the weekly time module, create a boolean Current Week? with PARENT(ITEM(Time)) = PARENT(PERIOD(CURRENTPERIODSTART())). This will show the weeks you've set in the Time settings.
In the monthly time module, create a boolean > Current Month? with ITEM(TIME) > PERIOD(CurrentMonth). This will show true for all months following current period.
Back in the weekly time module, create a boolean combining the two line items created above.
Apply filter to the reporting module

Best,
Jack

rob_marshall

@MadhabikaM ,

@jackcplanning is exactly on the right track, just beat me to the punch. Here are some pictures, slightly different than what Jack did, but I think it will work for you.

Time Settings:

Create a SYS Time - Month module and create a line item named Current Period from Time with a format of Boolean with the following formula:

In your SYS Time - Week module, create the following line item with a boolean format

Change the Summary to Formula

For a result of

Hope this helps,

Rob

MadhabikaM

Thank you @jackcplanning, this work perfect on weekly dimension ed modules.

Thanks For your help 🙂

MadhabikaM

Thank you Rob,

this work perfect on weekly dimension ed modules.
Thanks for your help 🙂
Madhu

Quick Links

Can you help?

Unanswered questions

Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…