en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Shun Lu  
#1 Posted : Tuesday, June 11, 2013 3:35:11 AM(UTC)
Shun Lu
Rank: Member

Groups: extranet\Forum
Joined: 5/28/2013(UTC)
Posts: 9

I tried to place "Is Working Day" under the dynamic period hierarchy but seems the dynamic period still pick up the date of yesterday. How can I skip the Sunday or public holiday while setting the TimeDef ?
David L. Bojsen  
#2 Posted : Thursday, June 13, 2013 11:21:25 PM(UTC)
David L. Bojsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 3/21/2013(UTC)
Posts: 19

slu@psw.com.au wrote:
I tried to place "Is Working Day" under the dynamic period hierarchy but seems the dynamic period still pick up the date of yesterday. How can I skip the Sunday or public holiday while setting the TimeDef ?


Hi Shun

Are you trying to return only the last X working days in an object?

Another way to do this could be
Select last X+10 days with dynamic period
Select that a separate attribute "Is Working Day" has to be true
Use a visibility agent to only display the top X rows

Does this accomplish what you want?

I personally don't think that "Is Working Day" belongs in the dynamic period, but as a separate attribute hierarchy in the Date dimension,
but this is just my personal opinion - i don't know if you can do it the way you described.
I can however not recall seing anything about "Is Working Day" in the documentation for setting up dynamic periods.
Venlig hilsen / Best regards

David L. Bojsen
Kapacity A/S

UserPostedImage

Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of my employer Kapacity A/S.
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error