Current Day calculation in Days dimension

[Dev1975]

Hello everyone,

I'm trying to setup a dimension that lists all the days in the current tax year. What I want to add is a "flag" which marks the current day depending on what today's date is. Is there a way of setting this up during the creation of the dimension, or would I need to create the dimension first and then add some sort of rule/calculation afterwards?

Any advice would be greatly appreciated.

Many thanks,
Dev

[rmackenzie]

Create a dimension called 'Day' and fill it with n-level elements in the format YYYY-MM-DD. Then create an attribute called 'IsCurrentDay'. Then write a rule on the attributes cube:

Code: Select all

['IsCurrentDay']=S:IF(!Day@=TODAY(1),'TRUE',STET);

Here is the doco on the TODAY function.

[lotsaram]

Generally I have a consolidation called "Current Day" which is maintained overnight by TI. Pretty simple to set up.

[Dev1975]

Thanks for the responses, much appreciated. I should mention that I'm using Performance Modeler to setup the dimension, so I've got the "Days" dimension setup successfully. If I right-click on the dimension, I get the option to "add a new attribute", which I then select and created "IsCurrentDay".

From this point, though, I'm not able to setup a calculation for this column. Is there a particular menu option I'm missing, or should I be using a different method?

TIA!

[rmackenzie]

From this point, though, I'm not able to setup a calculation for this column. Is there a particular menu option I'm missing, or should I be using a different method?

If PM doesn't let you set up a rule on an attribute then you may have to look at using Architect/ Perspectives. If that doesn't work for you, then consider using a TI to set the attribute, or per Lotsa's comment, use TI to set a consolidation that has a child that is the current day. Either of the TI methods are pretty simple and still leverage the TODAY function.