Skip to main content

Hallo,

 

I would like to check, the chart on my cube view, under the row has a number 2 which is I'm not clear where it comes from or how it derive.

 

Please find below screenshots

 

The volume comes from a Company (only 1 company)

39 volume for 2 weeks 

and each weeks (start of the week) which are 30/06/2025 & 07/07/2025  has 22 and 17 volume.

 

 

 

What does day =2 means?  also how can i remove the 2 if i only require to show the week start date instead

 

 

on my Software factory, this is the setup on the cube

 

 

The Dimensions setup is below

 

 

Thank you in advance.

 

 

The 2 is refering to the 2nd day of the month (sunday is 1 in SQL). 

The 2 is showing because you have a week start day that is part of the week_start group. 
 


You could remove the week_start_week_day to show the data without the added 2 (monday).​​​​

Hi Erwin,

 

Thank you! removing /deleting week_start_week_day indeed remove the 2.

However I think the week day is visible because of the Group linked to week_start_week_day which is the week_start_week that I used. 

 

So, I tried removing week_start_week from the Group of week_start_week_day as well, and the "2" disappeared even without removing / deleting week_start_week_day

 

 

Thank you for the idea.

 

Terms & ConditionsCookie settings