How cube is making join data source

How cube is making join in multiple data sources and building .mdc file and preparing package.

Cognos transformer has unique mechanism to gather multiple data sources (Reports, IQD's (Queries), model, packages) to build cube.

Question is how transformer doing magic
Are we define any join one IQD's to another IQD's ?
Are we define any join between two tables?
Are we define any join between two database?


After cube published .mdc file In power play studio we can do analysis using those all dimensions.
All dimensions made based on unlinked data sources, how this magic?

Answer : Cube machanism search in backgroud to join one table to anther by just finding common column, and same also doing in case for multiple databases. it will gather common column join to each other.


Thanks.

Conditional Bar Chat cognos report

Requirement : Cognos Bar chat report color with different contion.

1. Create sting variable with different values (Drag data item month in string values like 'R','B','G','Y'
2. Click on series
3. Click  conditional pallet
4. Select new conditional
5. Select data item (Series data iteam)
6. Select type = string
7. Select option Enter string criteria
8. Select contains from dropdown
9. Enter  R
10. Define the color 'Red'
11. Select option Enter string criteria
12. Select contains from dropdown
13. Enter  B
14. Define the color 'Blue'
15. Repeate this steps 7-10 upto you like (you can define multiple number of color)
16. ok
17. ok

Thanks.

Cube package connection issue

Error code : 3000007

Problem : Analysis studio package / cube package connection issue / connection issue with data source
Solution :

1. Go to cognos administration
2. Click respctive data source (which connected to package)
3. Action menu > click on test connection
4. Check connection string properly without missing anything
5. Select the correct dispatcher
6. If you feel you need to correct connection string then, click on close to go back
7. In action menu click on SetProperties
8. Click on connection tab
9. Correct the proper path of .mdc file or cube file and click on ok

Thanks


 

Cognos Cube not allowed to update

Cognos Cube / mdc file not allowed to updated.

Problem: Window job fail to updated cube automatically and cube manual update fail.
Cause : Some body opened with .mdc file so that and playing with Power Play studio, so you can not update cube till that time .mdc file close - in network location.

Solution: Please close .mdc file and try to update cube after.

Thanks.

Cube not allowed generate Categories.

Cognos cube not allowed generated categories manually and Error in Transformer.

Problem : When tried generate categories manually, cube Cognos transformer not allowed.

Solution:

1. Find out which dimension cube not allowed generated categories manually
2. Right click on dimension
3. Properties of dimesion
4. General Tab
5. Check box click on "Prohibit automatic creation of new categories"
6. Click OK
7. Again generate categories manually
8. Done

report run multiple times with multiple prompts values

Requirement : One cognos report need to run multiple times with multiple prompts values, schedule.
Solution:

1. Prepared excel sheet with all values with respect prompt
2. Load into Event studio agent package (package should hold query iteam which keeps all report prompt values)
3. Create one agent in event studio using event studio packge
4. Configured report in newly created agent
5. Schedule that agnet to run date/time (hourly,daily,weekly)
6. Example :
1.  Agnet will run on every 1 hour.
2.  1st time agent and report will run on 8PM, then agnet will pass prompt values "India" to report
3.  2nd time agent and report will run on 9PM, then agnet will pass prompt values "China" to report
4.  3nd time agent and report will run on 10PM, then agnet will pass prompt values "Japan" to report

Excel sheet data

----------------

Country                  Time

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

India                       8 PM

China                      9 PM

Japan                      10 PM

UK                         11 PM

US                          12 PM

 

 

Thanks

  

Cognos Excel report tab Issue using & Sing

Hello,

Problem : I have faced issue "& " sign cognos excel report tab naming example 'Sales & Service'.
Solution : Just remove & sing just put and.
                 Example: Wrong : 'Sales & Service'
                                 Right : 'Sales and Service'

Thanks