WTD and Prior WTD

[shindhu]

I have a Transformer model with date dimension hireachy set as Week and Day.
And i have two data sources one for setting current date and another as a transactional query. i have checked the set current period option on data sources of first one and uncelared that option on the other one.

Now when i generated the categories. Prior WTD is not showing correctly. It is showing me whatever is the latest week( it is not showing the immediate prior week details)>i have the details only for April,it is showing me the prior wtd details as April details

 

[kdemulder]

Shindhu,
I don't think I totally get what the problem is. You want a Prior WTD. So let's say it's friday today in week 24, then you expect the total from monday to friday but from week 23, correct? What are you getting now then?

 

[DoubleD]

You need to ensure that your datasource which provides the "current date" is providing a recent enough date.
Create a datasource that consists of nothing more than today's date.
1. Write an IQD to just bring back current date.
2. Create a text file, updated daily, that contains only today's date.

Now use this third datasource to set the current period. This will ensure that although your cube only has data up to last Friday, last Friday will show as Prior Week.

Pain is stress leaving the body.

DoubleD