If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

how to combine members in a relational data

Started by cognos05, 04 May 2020 01:40:11 PM

Previous topic - Next topic

cognos05

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,





MFGF

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.
Meep!

sdf

Seems to me what you wanted to have is a tuple in a relational source?

cognos05

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. 

MFGF

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.
Meep!