Skip to main content
Solved

Cube view


Forum|alt.badge.img+1

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.

 

 

Best answer by Erwin Ekkel

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).​​​​

View original

Forum|alt.badge.img+17

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).​​​​


Forum|alt.badge.img+1
  • Vanguard
  • July 1, 2025

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.

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings