Is there a way to display current week in a label

Jack Footer

Is there a way to have a label to display the current week? My screen selection is set to the Financial Year so the @week function shows something like 18 / 419. So is there a way to make this label dynamic to always show the current week? 

 

Thanks!

Previous Member

Hi Jack,

This somewhat depends on the screen.  If you have a select on the week in place the @Week will return the week being used in a Label.  If the select is NOT on the current week consider this

 

1)   Create a cube called "current Week" dimension by week only

2)   Create a screen with dataview using this cube and enter a 1 on the current week.  You could also setup a procedure to do this for "production".  Note only one week must be selected !

3)   On the screen you want the current month to appear add a label with a layout. The layout has the cube "current week" and below to it the "entity" "Week". The row should be week. Add a filter on the "current week" cube to show only if the value is >0.5 and lastly in the value column show "week" in the value.  

 

This will work I have the same for current year and current planning version in one of my models

 

Regards

 

Chris Field Head of Presales BOARD NE

Paul Wyatt

Hi Jack,

 

I was going to suggest that you use NEXEL to determine and store your week number, which it can do, but then christopher field came in with a simpler solution using the substitution formula @Week which I too was unaware of. 

 

By way of showing my gratitude to your question and to learning a new skill, I've attached a capsule and database model which incorporates a procedure for dynamically populating the current week using Chris' solution

 

 

The attached model also including a NEXEL solution and some additional NEXEL date calculations which may be useful or provide ideas to solving future problems.

 

 

Hope this helps.

 Regards,

 

Paul Wyatt