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