Static choice defined in value prompt

Requirement:

I have 4 countries in my database as USA, UK, INDIA, and CHINA. In value prompt control list, I want WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country names (USA, UK, INDIA, and CHINA). When I click on WESTERN_COUNTRIES I should get USA, UK respectably.

Solution:

• Develop values prompt name of the prompt : 'Countries'
• In Static choice define 2 values like : WESTERN_COUNTRIES, ASIAN_COUNTRIES
• Use value of the prompt : [Country] IN ('INDIA','CHINA')
• Display value of the prompt : Eastern Countries
• Query explorer open query and apply filter.
• In the Expression Definition:
• #prompt ('<prompt parameter>', 'token', '<default filter>')#
• #prompt ('Countries', 'token', '[Country] in ('USA', 'UK', 'INDIA', 'CHINA')')#

 Thank you.

 

How cube joined data sources ??? cube machanism

How cube makes join in transformer between two data sources or multiple data sources.

This is unique features provided by cognos cube, link magic provided by cognos.

When you create cube with multiple data sources cube transformer do not have provision to create join between data sources. Then how cube is establishing join and when we open cube in power play studio its showing data without any issue even there are no relation defined in data sources.


Answar :

• Transformer Cube mechanism itself making join between facts and dimensions.
• How its making join : Dimension table key ( primary key ) with Fact table key ( foreign key ).
• Cube making eque join automatically in between facts and dimensions.

Any body know out of these please advise.