Weeks in two months

Good Morning,

I am doing a stock project where I need that the weeks that belong to two months. I don’t know what is the best way to force BOARD, with a check in a layout or with a process or with something that I know right now, put the data in the month that I need.

For example: week 44 of the year 2019, belongs to October and November. As I do the calculations for weeks, I want to visualize the data only in the month of October.

Somebody could help me?

Thanks!

Find more posts tagged with

Accepted answers

All comments

Björn Reuber

Hi Marta,

as far as I know there is not a simpe solution.

I know that some customers do a Mapping (df) from Week Level to a certain Day of the Week (Monday if you want to assign it to frist Month a Week is belonging, Wednesday if you want to match it according to the Business days).

Now the Data is on one days which can be simply assigned to exact one Month.

Maybe this is also Helpful for you.

Regards

Björn

Previous Member

Hi Björn,

thanks for your answer.

The problem is that I don't know how to do that mapping.

With a cube without the time dimension?

Thanks!

Marta.

Björn Reuber

Hi Marta,

the easiest way (from my point of view) is to do the mapping wiht an additional cube

Regards

Björn

Dietmar Jeschkeit

Hi Marta Cuñado,

if you just want to dataflow a value from a week based cube to a specific day of the week you can set up a custom time entity (maybe you call it weekdays). Then assign every day to a weekday (e.g. 1=Sunday, 2=Monday etc.).

Now your dataflow can run with a selection in the procedure e.g. on Monday. Result is every week value on one day in the day based cube (here on Monday).

So with this solution you don´t need a mapping cube.

Hope it helps.

Dietmar

roberto wernikoff

Hi, Marta, how are you?

Many Board customers have different calendars like 4-4-5, so another option you have is to customize the time dimensions using the custom entities or even the normal time entities. Using a data reader you can update the time entities and relationships, defining your own time dimension. To allow functions like year cumulated and previous year on layouts, depending on how you define the code on the custom time entities, you have the custom entity mask.

Is it clear? you can write me, rwernikoff@board.com

Roberto