Change settings for current period in Transformer

[bencri]

I am currently using Transformer and Architect from the EP 7 Series. I created an architect model that I used as data source for my transformer model. In the Transformer step-by-step guide, it is noted that you need to define a column to set the current period. Now, as your data source is architect, I assume you cannot change the properties anymore from your data source in Transformer. This is quite reasonable as Architect is the central repository where you define your objects, so you should not start changing objects in Transformer. But how can I then define an attribute to be used for setting the current period because I cannot find a similar option in Architect. So how do I define the current period now? In my current model, I wasn't able to set any date for current period-definition but it does define 2002-05-21 as the current period. This is because I didn't define any attribute for "Sets current period" and it then takes the latest date from all data sources. As you will understand, this is not what I want. How would you define an object such as NOW() or CURDATE() and use this in Transformer to set the current periode?

 

[Draoued]

You can create an IQD , with the Now() as a calculated field. You add this in your cube model, and set the current period for this one ,and disable it for the Architect package.

The field name containing the Now() function , should have exactly the same name as your date field in your architect package.

it should work this way.