Level 2 Sprint 1 1.5.7.3

Hi Team,

When reviewing 'Check your Work' my output is similar with the exception of the dimension at the top.

Check your Work in the content section has no time dimension at the top only 'Has Data'?. My output includes a date, namely the relevant week.

When I try to omit a time dimension, in this case 'week', I'm unable to replicate the output. Since the formula is 'TimeSum', I expect the time dimension is required? How come it doesn't feature in Check your Work?

Thank you

Matthias

1_108715.png

Accepted answers

jairamkamath

@mstanisic TIMESUM can be used on a target line item that does not contain TIMESCALE. It is just that the source line item you reference must have used a time dimension.

I have not read the entire sprint user story but seems to me that the Week Dimension can simply be removed from the target module.
I hope this answers your query.

All comments

Kanishq17

hi @mstanisic

You can omit the time dimension from the module , the 'has data' boolean has timesum formula which checks whether for any period the value is there in source or not , so the module from where you are taking timesum (source should have time dimension) , here value will come if you exclude the time dimension from blueprint for the target module

jairamkamath

@mstanisic TIMESUM can be used on a target line item that does not contain TIMESCALE. It is just that the source line item you reference must have used a time dimension.

I have not read the entire sprint user story but seems to me that the Week Dimension can simply be removed from the target module.
I hope this answers your query.

mstanisic

Hi @Kanishq17

Thank you for clarifying this, I managed to remove the time dimension successfully. Your help is much appreciated.

mstanisic

Hi Jairam,

Thank you for your clarification and feedback regarding the TIMESUM formula. This does answer my question and I managed to resolve the query. I really appreciate your help.

Best,

Matthias

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
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.…