Cross tab measure use text value as data iteam

Text item in crosstab measure are : Change the property *Define Contents* to '*YES*" for crosstab Fact cells.

Convert cognos drop down prompt to type in / text box prompt

Convert cognos drop down prompt to type in / text box prompt

If you wants add drop down to type in prompt use caption() : Caption([Query1].[SR_AREA])=?prompt?

Wildcard text prompt - use like in prmpt

You are not sure what user is going to enter values in prompt, so design like this way.

Wildcard text prompt: [Query1].[SR_SUB_AREA] like '%'+ ?Parameter1? + '%'

Sorting based on user selected column - Dynamic sorting by prompt selection

Dynamic sorting by prompt selection

=====================================

> drag two cols like country and revenue

> drag value prompt to prompt page

> Static choice country and revenue used value and display value

> Drag one query expression mean create new cols in list

> case

when paramdisplayvalue='country' then 'contry'

when paramdisplayvalue='revenue' then 'revenue'

else end

> select that particular col country / revenue then grouping/sorting keep that cols

> select another col grouping and soring keep that cols

> remove sort that cols from list

IBM Cognos Business Intelligence 10.2.2 NEW features

Cognos 10.2. Features number - 1

My data sets - User can create his own without any assistance of IT. 

a) Much high volume of data set can import into like excel, text files
b) imported data can process on server as long as user wants
c) stand alone package can be created

1. Go to welcome screen of cognos connection
2. Click on IBM cognos content
3. click on user icon
4. click on my data sets (this will show all data sets which i have and can see package i generated for data sets, it can show no of records, files size)
5. New data sets : by clicking icon employee button
6. import screen i can import like xls, exls, text file(comma separated, tab separated, pip separated) value i can port.
7. after import i can metadata left side and data preview right side pan
8. I can remove unwanted columns from my meta data screen (left side pan)
9. I can change default summery to none, which change icon of data items to attributes
10. Then I can publish package by just click on publish button.
11. I can select location like public / my folder to publish this package, i can give name of the package

My data  sets - administration.

1.  click on cognos administration
2.  Go to status tab in administration, there is a Data sets option
3.  Click on Data sets right side pan will show all details about the data sets like (name, owner, refreshed, file size, rows, tenant)
4.  Left pan we can apply filter to as you want to see.
5.  we can delete any of data set by selecting like data source
6.  User access to my data sets capabilities :
7.  capabilities : click on security and then click on capabilities  then my data sets
8.  click on set properties
9.  go to permission tab add user/group, can add execute and traverse
10. After giving capabilites persimission to user then user can see data sets when login into cognos connection.
11. Data from files user uploade is loading to one of more repositories, you can configure connection to these repository in data source configuration area in cognos administration.
12. Create new data source, in wizard data source type drop down select my data sets repository, its like any other JDBC data source.
13. From initial release of cognos 10.2.2 DB2 only repository for my data sets repository, going forword this will update to SQL server and Oracle

Cognos 10.2. Features number - 2

In Cognos 10.2.2, you now have the ability to create customized User Interface (UI) profiles to control the features and functionality that are available in the User Interface for Workspace Advanced Users. The default user interface profiles still exist, but now, once enabled by your administrator, you have the ability to create new profiles and customize them in the Library tab in the Cognos Administration console. You also have the ability to choose whether to automatically show next generation functionality in the UI when the software is upgraded.


Cognos 10.2. Features number - 3

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.