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?
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
Chris Field Head of Presales BOARD NE
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.
Retrieving data ...