en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Lotte Bjørn Jensen  
#1 Posted : Wednesday, September 18, 2013 12:29:48 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68

Hi

I'm trying to calculate only visible siblings, but it isn't working. What am I doing wrong?

First the quarters are visible

UserPostedImage

and now they're hidden, but the % column is still the same.
Look at the month row, it's still calculating % of quarter, not of year

UserPostedImage


Best regards

Lotte Bjørn
Ole  
#2 Posted : Wednesday, September 18, 2013 1:16:41 PM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 320

Hi Lotte,

Hiding the Quarters does not change the parent/child/siblings relationship to the Months. Months will still be children of Quarters in your hierarchy. This is why you do not see any change on the month level calculations.

Of course, if you run into this particular problem frequently, I would recommend to create a new Time hierarchy on your cube, e.g. a Year/Month/Day hierarchy. With such a hierarchy, months will always be children of years.

However, there is a solution with your current hierarchy. You should use a formula something like this:

if count(d1, all(c), m1) = 0 then sum(d1, 0, m1) / sum(d1, all(s), m1) else sum(d1, 0, m1) / sum(d1, 0(l(1,0)), m1)

In this case, only the lowest members of your custom hierarchy (the age groups, having no children) will use the "then" part of the formula. The months (that do have children) will use the "else" part.

Best regards,
Ole

Edited by user Wednesday, September 18, 2013 1:19:58 PM(UTC)  | Reason: Not specified

I work as an employee with TARGIT A/S. 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 TARGIT A/S.

UserPostedImage Ole Dyring
Lotte Bjørn Jensen  
#3 Posted : Thursday, September 19, 2013 10:47:54 AM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68

Thanks - it's working perfect.
Best regards

Lotte Bjørn
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