Hi ,
this question might be prety simple , I wanted to know how to ocmbine members in realtional data .
For example in dimensional data if we need to combine some members sales,
Total(CurrentMeasue within set set([a],) etc..
I can add members from any level .
Same case in relational ,
I have five columns which is equivalent to five dfferent levels .
So how to do i say this member, for example i might have need to use 2 column values to get a member i need.
Thanks,
Quote from: cognos05 on 04 May 2020 01:40:11 PM
Hi ,
this question might be prety simple , I wanted to know how to ocmbine members in realtional data .
For example in dimensional data if we need to combine some members sales,
Total(CurrentMeasue within set set([a],) etc..
I can add members from any level .
Same case in relational ,
I have five columns which is equivalent to five dfferent levels .
So how to do i say this member, for example i might have need to use 2 column values to get a member i need.
Thanks,
Hi,
Sorry, I'm not really clear on what you are trying to achieve here. Can you go into more detail? With a relational model you don't have levels or members - just data items. If you want two measures combined you would create a query calculation that adds them. For things like cherry-picking item values and grouping them, you would need a query calculation utilising a case statement or if-then-else construct. Can you give us more details on what you need to do?
MF.
Seems to me what you wanted to have is a tuple in a relational source?
Hi MFGF,
Yes its cherrypicking item values and grouping them . so for example I have column as product team and then product group column and few more columns .
Now say I need to have a list report with 5 items which are all picked .
CustomProduct1
CustomProduct2
CustomProduct3
CustomProduct4
say Custom product 1 is some thing where the produc team is 50 and product group is A,B and C .
so how do i make a custom data item that would combine my items on two columns.
Quote from: cognos05 on 04 May 2020 07:42:03 PM
Hi MFGF,
Yes its cherrypicking item values and grouping them . so for example I have column as product team and then product group column and few more columns .
Now say I need to have a list report with 5 items which are all picked .
CustomProduct1
CustomProduct2
CustomProduct3
CustomProduct4
say Custom product 1 is some thing where the produc team is 50 and product group is A,B and C .
so how do i make a custom data item that would combine my items on two columns.
Hi,
You'd need a query calculation utilising a case statement or if-then-else construct for this.
eg
case
when [Product Team] = 50 and [Product Group] in ('A','B','C') then 'CustomProduct1'
when [Product Team] = 40 and [Product Group] in ('D','E','F') then 'CustomProduct2'
when...
end
Cheers!
MF.