en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Karel Moijson  
#1 Posted : Monday, August 31, 2015 4:02:18 PM(UTC)
Karel Moijson
Rank: Member

Groups: extranet\Forum
Joined: 8/31/2015(UTC)
Posts: 7

I don't find the right syntax to 'lookup' the value related to a certain dimension member of a hierarchy. Last thing I tried is the formula beneath, but I still get errors. It does work for a 1 level dimension, so I guess I'm on the right track. It is parent child dimension.

sum(d1, @"[MEMBERNAMELEVEL1]";"[MEMBERNAMELEVEL2]", m1)

Thanks for your help!
Ole  
#2 Posted : Friday, September 4, 2015 8:01:01 AM(UTC)
Ole
Rank: Administration

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

Hi Karel,

The syntax you are using will work for a combined hierarchy - i.e. an ad-hoc hierarchy made up by adding two attributes to that same axis in a TARGIT crosstab.

If you have a normal hierarchy - i.e. a hierarchy that has been designed in the Data Warehouse - the syntax should be a little different:

sum(d1, @"[MEMBERNAMELEVEL1].[MEMBERNAMELEVEL2]", m1)

Let me know if this is the case for you - otherwise you may need to supply screenshots to explain the issue in more detail.

BR / Ole
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
Karel Moijson  
#3 Posted : Saturday, September 12, 2015 2:18:06 PM(UTC)
Karel Moijson
Rank: Member

Groups: extranet\Forum
Joined: 8/31/2015(UTC)
Posts: 7

Dear Ole, it is not working. How can I attach an image from disk?...
regards
UserPostedImage

Edited by user Sunday, September 13, 2015 3:01:25 PM(UTC)  | Reason: Not specified

Steffen Davidsen  
#4 Posted : Monday, September 14, 2015 7:56:56 AM(UTC)
Steffen Davidsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 7/8/2014(UTC)
Posts: 28

Originally Posted by: Karel Moijson Go to Quoted Post
Dear Ole, it is not working. How can I attach an image from disk?...
regards
UserPostedImage


http://www.targit.com/en/resources/forum?g=posts&t=66#post91
Karel Moijson  
#5 Posted : Monday, September 14, 2015 8:39:59 AM(UTC)
Karel Moijson
Rank: Member

Groups: extranet\Forum
Joined: 8/31/2015(UTC)
Posts: 7

Here it is: UserPostedImage
Hope you can help me out
regards
Karel
Páll Bjarkason  
#6 Posted : Friday, September 18, 2015 9:06:17 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 164

Hi Karel

Your calculation referencing a specific row seems to be ok.
Maby there is a 'typo' in the referencing syntax or hidden blank spaces i the source data?

You can recreate this example from demo data, to experience a live working demo.

UserPostedImage
Best regards

Páll, CTS
Ole  
#7 Posted : Tuesday, September 22, 2015 6:58:49 AM(UTC)
Ole
Rank: Administration

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

Hi Karel,

Páll's example points in the right direction - but I think he just produced the same problem that you are seeing. I.e. that calculations on the third level (month level in Páll's example) is still undefined because the calculation is specified to something on the second level.

In Páll's example, to get the 2012 Q1 value shown on the month level as well, the syntax should have been

sum(d1, @"[2012].[Q1]"(l2), m1)

The "(l2)" level modifier may be thing missing from your calculation as well.

BR / Ole

Edited by user Tuesday, September 22, 2015 7:00:06 AM(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
Karel Moijson  
#8 Posted : Monday, October 5, 2015 7:08:36 AM(UTC)
Karel Moijson
Rank: Member

Groups: extranet\Forum
Joined: 8/31/2015(UTC)
Posts: 7

Indeed solved with your input guys, thank you all!
Karel
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