en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Tim R. Hansen  
#1 Posted : Tuesday, June 20, 2017 8:40:26 AM(UTC)
Tim R. Hansen
Rank: Advanced Member

Groups: extranet\Webinar
Joined: 4/25/2016(UTC)
Posts: 16

Hi.

I'm having some issues getting a calculation to work the way i would like to.

Here is what i'm trying to do:

I have a crosstable with 2 calculations and then i have added the "posting date" dimension
UserPostedImage
UserPostedImage

I would like to see the total number of workingdays without the "posting date" dimension:
UserPostedImage
UserPostedImage

Is this possible to achieve?
Páll Bjarkason  
#2 Posted : Tuesday, June 20, 2017 12:40:51 PM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Webinar
Joined: 1/13/2012(UTC)
Posts: 182

Hi Tim

In the last screenshot, you have the correct values for the two measures on the all level. (0 and 13)
The all levels is one level higher than the year level. The year level is (0 and 13)
In addition, the Month level for June is (22 and 13)

On what Year-Month-Day level and for what period do you wish to report the two measures?
KR Páll
Best regards

Páll, CTS
Tim R. Hansen  
#3 Posted : Tuesday, June 20, 2017 12:48:33 PM(UTC)
Tim R. Hansen
Rank: Advanced Member

Groups: extranet\Webinar
Joined: 4/25/2016(UTC)
Posts: 16

Hi Páll

Thanks for your reply.

My main goal is to show the number of working days in a month, and what workingday it is today (MTD).

But my problem might be, the way i have constructed the measures
Páll Bjarkason  
#4 Posted : Tuesday, June 20, 2017 4:06:37 PM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Webinar
Joined: 1/13/2012(UTC)
Posts: 182

Ok. Now I understand.
I hope that I Can give you an idea of a possible design. The design requires deep TARGIT knowledge. 😞

Assuming a correct implementation off the measure...
You shold look into the TARGIT comparison element and dynamic time.

Using TARGIT comparison you could create 2 elements

1) Today
2) Max this month

Then you get a result that resembles the Your last screen shot.
I.e. Today's workDayNumber and the total number of workDays this month.

KR Páll
Best regards

Páll, CTS
Tim R. Hansen  
#5 Posted : Thursday, June 22, 2017 11:49:26 AM(UTC)
Tim R. Hansen
Rank: Advanced Member

Groups: extranet\Webinar
Joined: 4/25/2016(UTC)
Posts: 16

Thanks alot for your help.

I solved it by editing my measures in the SSAS
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