Aging the time/period

Previous Member

Hi All,

 

I'm confused to do an aging of time (that I know Aging use for grouping/mapping about age of sth). This time I'm trying to make Aging for Date. I have Day which is only the Date formate inside so there will be 01 - 31, from that Date I divide by 3 part : First week 10 Days (Date 01-10), Second week 10 Days (Date 11-20), and Third week 10 Days (Date 21-31). How could I do that? Is it posible in Board? without change the time range of database, because if I change database's time range there were some procedures can't run well. In the end my dataview will be like pic in attacthment. At this time I tried to make an entity but I'm little bit confused to make it show.

 

Thank you. Hopefully there any suggestion.

 

Regards,

Febri.

Björn Reuber

Hi,

 

why not use a custom time entity above day? So you can group the days to certain Elements

 

Regards

Björn

Previous Member

Björn Reuber Could you help me to get in detail?

Björn Reuber

Hi,

 

I created a day based DB, Added a custom time entity Aging, with follow three members

This new Entity is a parent entity of the Day

Then I extracted entity Day to automatically load the aging using an ETL:

With following formula in F3 =IF(E3<11,"01-10",IF(E3<21,"11-20","21-31"))

 

So I was able to have an aging reporting for day based cubes

 

Regards

Björn

Previous Member

Thanks Björn Reuber I'll try