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.

PROBLEM: Output in Excel 2003 with Cognos 8.1 the window just disappears

PROBLEM: Output in Excel 2003 with Cognos 8.1 the window just disappears

SOLUTION: Alter/set the following conditions in Internet Explorer

1. Open Internet Explorer

2. Click 'Tools' -> 'Internet Options..'

3. Click the 'Security' tab

4. Click on 'Internet'

5. Click 'Custom Level...'

6. Ensure the 'Automatic prompting for file downloads' and 'File download' are enabled.

7. Click 'OK'

8. Repeat for 'Intranet' and 'Trusted Sites'

Dynamic Sorting Based on Selection in Cognos Report Studio

Dynamic Sorting Based on Selection in Cognos Report Studio

Requirement: User should be given a choice to select the columns on which the output should be sorted. Ex: A List has Month and Quantity.  If the user selects Quantity, output should be sorted based on Quantity in ascending order.

Solution: Create a ‘Sort’ data item in the same query subject and perform ‘Advanced Sorting’ based on the ‘Sort’ data item.

Detailed Steps:

1.     Create a List report with Month and Quantity columns

2.     Create a ‘sort’ prompt with static choices as 1-Month and 2-Quantity

3.     Create a Data Item ‘Sort’ in the query subject as
     case
when ?sort? = 1 then [Month]
when ?sort? = 2 then [Quantity]
end

4.      Select 'Month' column in Report Page, select ‘Advanced Sorting’ and  add ‘Sort’ under ‘Detail Sort List’

                 5.  Repeat the above step for “Quantity” also.

Limitations: The above solution sorts both columns in the same order. i.e either by Asc or by Desc. This works only when both columns are of same data type

Scope Relationship

Scope Relationship

Scope Relationship: which is exist between measure dimension and regular dimension to define the level at which the measures are available for reports- This is available in DMR model.

What are summary filters? Grouped filters?

Summary filter: If the filter applied after aggregation then aggregated records are filtered.

Group filter: A filter which is applied to the group is known as group filter

a	10
c	12
c	8
d	6	Details	> 10	2 records
d	7	Summery	> 10	3 records
b	6
b	15