Hi Guys,
Does anyone know how to decide how much memory server requires depending on user load.How to determine statistics and all that stuff.Its very important considering your server needs to be up all the time and also deciding what is the backup plan.
Considering you are asked to plan a cognos architecture from start.How would you do it.You need to give specs for a server, backup server and that server should hold the current users and you need to keep in mind that additional users are going to be added.
1)availability
2)capacity
3)scalability.
You need to keep all this in mind.While planning so depends how you do it.I am working on this architecture and deployement guide is the place to start it.
Monday, 7 November 2011
How to publish PDF/Word in cognos connection
Hi Guys,
I have done this before but right now cant recollect how.Will update this post soon
I have done this before but right now cant recollect how.Will update this post soon
Shorten cognos URL from http://server-name/ibmcognos to cognos10?
Hi Guys,
Instead of users typing http://servername/cognos10 everytime or accesing it from favourites .I want them to directly type cognos10 in browser and they should be able to able to access cognos. Now i know this is outside scope of cognos developer.But doing it just for fun .. Just another Geek
:-)
There are 2 things I have done to accomplish this at my company.
1 - Create a DNS Alias for the server -- Domain name service
2 - Set an HTML Redirector on the root web server
The alias allows my users to type in
http://cognos
To get to the cognos environment and since we have pass through authentication it takes them right to their default Cognos view.
The alias translates http://cognos to http://really_long_servername.that.is.fully.qualified
The redirector simply redirects traffic to the server to the Cognos cgi directory
Instead of users typing http://servername/cognos10 everytime or accesing it from favourites .I want them to directly type cognos10 in browser and they should be able to able to access cognos. Now i know this is outside scope of cognos developer.But doing it just for fun .. Just another Geek
:-)
There are 2 things I have done to accomplish this at my company.
1 - Create a DNS Alias for the server -- Domain name service
2 - Set an HTML Redirector on the root web server
The alias allows my users to type in
http://cognos
To get to the cognos environment and since we have pass through authentication it takes them right to their default Cognos view.
The alias translates http://cognos to http://really_long_servername.that.is.fully.qualified
The redirector simply redirects traffic to the server to the Cognos cgi directory
Saturday, 5 November 2011
Upgrading Cognos from 8.4 to 10.1
Hi Guys
Will update this with the things to consider later.
Step 1
If you are new to migration.Be sure that you understand each and every option under the Export tab.Usually most developer have only migrated reports from dev to production so are not fully aware of all the options.
Below are the steps that i found from IT toolbox.They are pretty straight forward
Development Phase:
1.Always setup a development or parallel environment first.
2.When you have the products installed create a blank content store.
3.Perform an Entire Content Store export in Cognos Administration.
4.Copy your Deployment file from the current environment to the development environment.
5.Perform an import of the deployment file that you copied over.
6.Check in your new environment that the data sources exist in Cognos Administration. I have seen them not come over before. If not then you need to manually create them.
7.Try running a small sample of reports to compare the output.
8.I usually create a test plan and divide the reports up in the user community. Log any issues that you find and correct them one by one.
9.Once you are happy that all issues are resolved you can move to the production phase of the upgrade.
Production Phase:
1.Export your configuration from Cognos Configuration including the encrypted data to an xml file in the \Program Files\Cognos directory.
2.Perform your vanilla installation of C10. Don't perform configuration tasks yet. If you are leaving C8 in place remember to change the port references from 9300, 9362 and 9399.
3.Once all installation tasks are complete, take the xml created in step 1 and overwrite the file cogstartup.xml in the configuration directory. Beware the C10 installation location is very different from the C8 one.
4.Open Cognos Configuration, save the configuration, test it and then start it. It should have remembered all your settings.
5.On your development environment, perform an entire content store export and copy the deployment file to the production deployment location.
6.Perform the entire content store import and check data sources as above.
7.Check to see if the everyone group is a system administrator, if so then remove them.
Testing or report in Cognos10 once they are migrated
1.You can check the reports manually by dividing it among user groups or tester groups.This task takes long time.You can use Life cycle Manager
Below is the extract from IBM site about Lifecycle manager
Lifecycle Manager connects to the source and target environments, validates and executes reports in both environments, and then compares them. The results of the comparison are presented in a dashboard.
In a benchmark project , you are working in a single IBM Cognos environment. Consider Run 1 as the source environment and Run 2 as the target environment when working in a benchmark project.
VIMP for those guys who have never seen lifecycle manager
" Lifecycle Manager is a Microsoft? Windows? operating system-based application ..."
"Lifecycle Manager is a standalone single-user application that you can install on any computer..."
"Note: Because Lifecycle Manager is a single-user application, there should be only one Web browser session connected to the Lifecycle Manager server at a given time. Multiple browser sessions can lead to loss of data."
Lifecycle Manager is a web application and you access it via the browser. However, don't let that fool you. I do not think Cognos intends for you to install this on a server. I think it is intended to be installed on a user's desktop more like a client side application
Lifecycle Manager
1.tests report output only by comparing results from one release (the source) to another (the target)
2.tests reports created in IBM Cognos Report Studio, IBM Cognos Query Studio, or IBM Cognos Analysis Studio
3.The studios are not used in the testing, only saved report specifications.
4.Analysis Studio reports are tested only when upgrading from IBM Cognos Business Intelligence 8.2 to 8.3, 8.4, or 10.1.0.
5.does not test any other aspects of the upgrade such as configuration, the studios, IBM Cognos Connection, skins, and customizations
6.tests only Public Folders content
7.does not perform the actual product or report upgrade
8.Upgrade is performed using the standard upgrade mechanisms documented for IBM Cognos BI.
9.does not test embedded HTML items except when they are used to control prompts and parameters
10.HTML items are not rendered in PDF output.
11.does not test embedded JavaScript™ item
12.JavaScript items are not rendered in PDF output.
13.does not test interactive functionality such as drill up, drill down, drill through, HTML links to external content, and bookmarks
14.runs as a single user application, so security by value and similar user dependent items are not tested
15.does not test report views, bursting, and performance or scalability differences
16.does not compare prompt pages
Will update this with the things to consider later.
Step 1
If you are new to migration.Be sure that you understand each and every option under the Export tab.Usually most developer have only migrated reports from dev to production so are not fully aware of all the options.
Below are the steps that i found from IT toolbox.They are pretty straight forward
Development Phase:
1.Always setup a development or parallel environment first.
2.When you have the products installed create a blank content store.
3.Perform an Entire Content Store export in Cognos Administration.
4.Copy your Deployment file from the current environment to the development environment.
5.Perform an import of the deployment file that you copied over.
6.Check in your new environment that the data sources exist in Cognos Administration. I have seen them not come over before. If not then you need to manually create them.
7.Try running a small sample of reports to compare the output.
8.I usually create a test plan and divide the reports up in the user community. Log any issues that you find and correct them one by one.
9.Once you are happy that all issues are resolved you can move to the production phase of the upgrade.
Production Phase:
1.Export your configuration from Cognos Configuration including the encrypted data to an xml file in the \Program Files\Cognos directory.
2.Perform your vanilla installation of C10. Don't perform configuration tasks yet. If you are leaving C8 in place remember to change the port references from 9300, 9362 and 9399.
3.Once all installation tasks are complete, take the xml created in step 1 and overwrite the file cogstartup.xml in the configuration directory. Beware the C10 installation location is very different from the C8 one.
4.Open Cognos Configuration, save the configuration, test it and then start it. It should have remembered all your settings.
5.On your development environment, perform an entire content store export and copy the deployment file to the production deployment location.
6.Perform the entire content store import and check data sources as above.
7.Check to see if the everyone group is a system administrator, if so then remove them.
Testing or report in Cognos10 once they are migrated
1.You can check the reports manually by dividing it among user groups or tester groups.This task takes long time.You can use Life cycle Manager
Below is the extract from IBM site about Lifecycle manager
Lifecycle Manager connects to the source and target environments, validates and executes reports in both environments, and then compares them. The results of the comparison are presented in a dashboard.
In a benchmark project , you are working in a single IBM Cognos environment. Consider Run 1 as the source environment and Run 2 as the target environment when working in a benchmark project.
VIMP for those guys who have never seen lifecycle manager
" Lifecycle Manager is a Microsoft? Windows? operating system-based application ..."
"Lifecycle Manager is a standalone single-user application that you can install on any computer..."
"Note: Because Lifecycle Manager is a single-user application, there should be only one Web browser session connected to the Lifecycle Manager server at a given time. Multiple browser sessions can lead to loss of data."
Lifecycle Manager is a web application and you access it via the browser. However, don't let that fool you. I do not think Cognos intends for you to install this on a server. I think it is intended to be installed on a user's desktop more like a client side application
Lifecycle Manager
1.tests report output only by comparing results from one release (the source) to another (the target)
2.tests reports created in IBM Cognos Report Studio, IBM Cognos Query Studio, or IBM Cognos Analysis Studio
3.The studios are not used in the testing, only saved report specifications.
4.Analysis Studio reports are tested only when upgrading from IBM Cognos Business Intelligence 8.2 to 8.3, 8.4, or 10.1.0.
5.does not test any other aspects of the upgrade such as configuration, the studios, IBM Cognos Connection, skins, and customizations
6.tests only Public Folders content
7.does not perform the actual product or report upgrade
8.Upgrade is performed using the standard upgrade mechanisms documented for IBM Cognos BI.
9.does not test embedded HTML items except when they are used to control prompts and parameters
10.HTML items are not rendered in PDF output.
11.does not test embedded JavaScript™ item
12.JavaScript items are not rendered in PDF output.
13.does not test interactive functionality such as drill up, drill down, drill through, HTML links to external content, and bookmarks
14.runs as a single user application, so security by value and similar user dependent items are not tested
15.does not test report views, bursting, and performance or scalability differences
16.does not compare prompt pages
How to get more than 65536 records in single excel file in Cognos10
Hi Guys,
As we know excel by default supports only 65536 records in single sheet. In Excel 2007 if you want more that this the data comes in separate tabs so how to get this in a single excel ??
we could try setting the ExcelSpreadSheetSize property in rsvpproperties.xml.sample but i dont think this solves it.Excle 2007 will still show it in separates tabs.
Working on this will update once i find a solution
As we know excel by default supports only 65536 records in single sheet. In Excel 2007 if you want more that this the data comes in separate tabs so how to get this in a single excel ??
we could try setting the ExcelSpreadSheetSize property in rsvpproperties.xml.sample but i dont think this solves it.Excle 2007 will still show it in separates tabs.
Working on this will update once i find a solution
How to create groups and add members in Cognos10
Hi Guys,
I will update this link shortly with screenshots .Working on this
I will update this link shortly with screenshots .Working on this
Friday, 4 November 2011
Great site with Lot of cognos learning videos for free
Hi Guys
If you are regular users of cognoise community.You will be already familiar with this site .If not check out the below link its great for anyone from newcomer to advanced developer to learn new things .
You need to login and create a userid to view this.But the registration process takes less than a minute.
http://www.bspsoftware.com/Support/PodcastChannel/tabid/228/Default.aspx
Ignore the Metamanager links.The cognos links are good
Post that i found useful
1) Taking a look at IBM Cognos 10 Active Reports
http://www.bspsoftware.com/Home/tabid/37/Support/PodcastChannel/tabid/228/Default.aspx
Things i liked is - Drillable with bread crumps .You can come back to where you want in drill.Like we have 5 level we can come from 5 to 3 without coming to 4 at all.
2)Moving values like how share market values are displays its flashy.
3)
If you are regular users of cognoise community.You will be already familiar with this site .If not check out the below link its great for anyone from newcomer to advanced developer to learn new things .
You need to login and create a userid to view this.But the registration process takes less than a minute.
http://www.bspsoftware.com/Support/PodcastChannel/tabid/228/Default.aspx
Ignore the Metamanager links.The cognos links are good
Post that i found useful
1) Taking a look at IBM Cognos 10 Active Reports
http://www.bspsoftware.com/Home/tabid/37/Support/PodcastChannel/tabid/228/Default.aspx
Things i liked is - Drillable with bread crumps .You can come back to where you want in drill.Like we have 5 level we can come from 5 to 3 without coming to 4 at all.
2)Moving values like how share market values are displays its flashy.
3)
Thursday, 3 November 2011
RSV-DST-0012 An error occurred while saving the output for the burst
I am facing the above issue.I have already tried the IBM standard help for this issue as well as IT toolbox discussion .But no help.I am having a business requirement where i am asked to burst report views in my folders . so i tried similar thing in go sales.
I have created a list with year as 1st column and revenue as 2nd column.Now i want to burst by year . only one query here .But the trick is i want report views created for all the years . I dont have a directory set up on server where the outputs gets saved .Now in my previous company i have saved outputs on file system and it used to work fine .But this time i need to created report views .
So on burst receipient i give list query as the query . Year as data item and type directory entries (Now this is the catch) .Since i dont have a directory set here to save the report outputs and saving them as report view in my folders .I am getting this error ??
Has anyone bursted report views in my folders before??Or we can do only 2 things with burst either email them and save them on directoy (Like C drive ,D drive on server)
Please let me know
Solution -
You cant burst multiple views .When you click on save as report view while bursting .You will get only one report view created and under that report view you will have multiple busted outputs according to your burst group .
How to burst a single burst view with multiple report outputs in it according to burst group
I have attached below screenshot .
When you say burst as email and do not click on send report by email in run with advanced options .Report outputs are created in same report view
Regards
Kapil
I have created a list with year as 1st column and revenue as 2nd column.Now i want to burst by year . only one query here .But the trick is i want report views created for all the years . I dont have a directory set up on server where the outputs gets saved .Now in my previous company i have saved outputs on file system and it used to work fine .But this time i need to created report views .
So on burst receipient i give list query as the query . Year as data item and type directory entries (Now this is the catch) .Since i dont have a directory set here to save the report outputs and saving them as report view in my folders .I am getting this error ??
Has anyone bursted report views in my folders before??Or we can do only 2 things with burst either email them and save them on directoy (Like C drive ,D drive on server)
Please let me know
Solution -
You cant burst multiple views .When you click on save as report view while bursting .You will get only one report view created and under that report view you will have multiple busted outputs according to your burst group .
How to burst a single burst view with multiple report outputs in it according to burst group
I have attached below screenshot .
When you say burst as email and do not click on send report by email in run with advanced options .Report outputs are created in same report view
Regards
Kapil
Wednesday, 2 November 2011
RSV-DST-0013 The list of recipients is empty for burst instance . The output for this burst instance was discarded.
Hi Guys
I am facing this issue though i am not giving any mails.Its directory entries that i am trying to burst the report to
I am facing this issue though i am not giving any mails.Its directory entries that i am trying to burst the report to
Monday, 31 October 2011
Cognos Reports Scheduling by using "By Trigger" Option
This post is not completed till now .I have not been able to configure scripts to run on server trigger.bat till now.Will update once done.If you are enthusiastic you can try the below step and let me know if you are able to generate the trigger.bat file
Setting Up Trigger-based Scheduling
To schedule an entry based on an occurrence and confirm trigger-based scheduling, you must have read, write, execute, and traverse permissions. You also require the following access permissions for all data sources used by the entry.
Data source :Execute and Traverse
dataSourceConnection:Execute and Traverse ,
With only Execute access, you are prompted to log on to the database.
dataSourceSignon:Execute
Before setting up trigger-based scheduling, ensure that your credentials exist and are up to date
Schedule an Entry Based on an Occurrence
As part of setting up trigger-based scheduling, you must schedule an entry based on an occurrence.
Steps
1. Click the schedule button next to the entry you want to schedule.
2. Under Frequency, click the By Trigger tab.
3. In Trigger name, type the name of the trigger occurrence.
Note: The trigger name that you enter may be provided to you by your administrator or developer. If not, you must inform your administrator or developer of the trigger name that you use.
4. The default start date is "now", and the default end date is "forever", which means the trigger schedule will always run when the trigger is fired (either from trigger.bat or from an SDK app). If you put in a valid start and end date, the trigger schedule can only be fired between those dates.
5. Click OK.
Set Up a Trigger Occurrence on a Server
As part of setting up trigger-based report scheduling , you must set up the trigger occurrence on a server. You link the external occurrence, such as a database refresh or an email, with a trigger on the server that causes the entry to run. You must also specify the name of the occurrence.
Trigger occurrences can also be set up by an SDK developer using the Cognos 8 software development kit (SDK). For more information, see the The Cognos 8 SDK Developer Guide.
Scripts
Using the Windows script named trigger.bat or the shell script named trigger.sh, you can trigger one or more schedules to run on the server.
The script syntax follows where URL is the Cognos 8 server URL, username is a valid username in the specified namespace, password is the password for the username, namespace is the namespace for the username, and triggerlist is a comma separated list of trigger names:trigger.bat URL [username password namespace] triggerlist
For example, if users want to schedule a report based on a database refresh and want to schedule a second report based on receipt of an email, your custom trigger command line may look similar to this:trigger.bat http://localhost:9300/p2pd/servlet/dispatch usernamepassword namespace databaserefreshtriggername,emailtriggername
3. Inform users that they can now schedule entries based on the trigger occurrence.
If a user scheduled an entry based on the occurrence, when the user clicks the schedule button for a report view, occurrence information replaces frequency information on the Schedule page.
If a user scheduled an entry based on the occurrence, when the user clicks the schedule button for a report view, occurrence information replaces frequency information on the Schedule page.
After the script runs, the trigger method returns an integer value representing the number of schedules that were run. The following integers represent errors:
· -1 is a usage error, such as invalid parameter or syntax
· -2 is a communication problem with Cognos 8 server
Disable Support for Trigger-based Scheduling
By default, trigger-based scheduling is enabled. An occurrence acts as a trigger, causing the report to run. You can disable this feature by modifying the system.xml file.
Steps
1. Stop the Cognos 8 service.
2. Open the c8_location/templates/ps/portal/system.xml file in an XML or text editor.
3. Locate the following XML code in the system element:4. 5. true6. 7. 8. true
9. Change the value of both trigger parameters from true to false.
The XML code should appear as follows: false false
10. Save the file.
11. Start the Cognos 8 service.
The By Trigger tab on the Schedule page no longer appears. Entries that are already scheduled for trigger-based scheduling continue to run, but no further trigger scheduling can occur while support is disabled.
Setting Up Trigger-based Scheduling
To schedule an entry based on an occurrence and confirm trigger-based scheduling, you must have read, write, execute, and traverse permissions. You also require the following access permissions for all data sources used by the entry.
Data source :Execute and Traverse
dataSourceConnection:Execute and Traverse ,
With only Execute access, you are prompted to log on to the database.
dataSourceSignon:Execute
Before setting up trigger-based scheduling, ensure that your credentials exist and are up to date
Schedule an Entry Based on an Occurrence
As part of setting up trigger-based scheduling, you must schedule an entry based on an occurrence.
Steps
1. Click the schedule button next to the entry you want to schedule.
2. Under Frequency, click the By Trigger tab.
3. In Trigger name, type the name of the trigger occurrence.
Note: The trigger name that you enter may be provided to you by your administrator or developer. If not, you must inform your administrator or developer of the trigger name that you use.
4. The default start date is "now", and the default end date is "forever", which means the trigger schedule will always run when the trigger is fired (either from trigger.bat or from an SDK app). If you put in a valid start and end date, the trigger schedule can only be fired between those dates.
5. Click OK.
Set Up a Trigger Occurrence on a Server
As part of setting up trigger-based report scheduling , you must set up the trigger occurrence on a server. You link the external occurrence, such as a database refresh or an email, with a trigger on the server that causes the entry to run. You must also specify the name of the occurrence.
Trigger occurrences can also be set up by an SDK developer using the Cognos 8 software development kit (SDK). For more information, see the The Cognos 8 SDK Developer Guide.
Scripts
Using the Windows script named trigger.bat or the shell script named trigger.sh, you can trigger one or more schedules to run on the server.
The script syntax follows where URL is the Cognos 8 server URL, username is a valid username in the specified namespace, password is the password for the username, namespace is the namespace for the username, and triggerlist is a comma separated list of trigger names:trigger.bat URL [username password namespace] triggerlist
For example, if users want to schedule a report based on a database refresh and want to schedule a second report based on receipt of an email, your custom trigger command line may look similar to this:trigger.bat http://localhost:9300/p2pd/servlet/dispatch usernamepassword namespace databaserefreshtriggername,emailtriggername
3. Inform users that they can now schedule entries based on the trigger occurrence.
If a user scheduled an entry based on the occurrence, when the user clicks the schedule button for a report view, occurrence information replaces frequency information on the Schedule page.
If a user scheduled an entry based on the occurrence, when the user clicks the schedule button for a report view, occurrence information replaces frequency information on the Schedule page.
After the script runs, the trigger method returns an integer value representing the number of schedules that were run. The following integers represent errors:
· -1 is a usage error, such as invalid parameter or syntax
· -2 is a communication problem with Cognos 8 server
Disable Support for Trigger-based Scheduling
By default, trigger-based scheduling is enabled. An occurrence acts as a trigger, causing the report to run. You can disable this feature by modifying the system.xml file.
Steps
1. Stop the Cognos 8 service.
2. Open the c8_location/templates/ps/portal/system.xml file in an XML or text editor.
3. Locate the following XML code in the system element:4. 5. true6. 7. 8. true
9. Change the value of both trigger parameters from true to false.
The XML code should appear as follows: false false
10. Save the file.
11. Start the Cognos 8 service.
The By Trigger tab on the Schedule page no longer appears. Entries that are already scheduled for trigger-based scheduling continue to run, but no further trigger scheduling can occur while support is disabled.
Cognos 10.1.1 display EXCEL 2003 instead of CSV format
CSV output not coming
Check IBM Administrator guide under customisation for below steps and detailed list of variables
you can set
1.Start IBM® Cognos® Connection.
2.In the upper-right corner, click Launch, IBM Cognos Administration.
3.On the Status tab, click System.
4.From the System drop-down menu, click Set properties.
5.Click the Settings tab.
6.Next to Environment, Advanced Settings, click Edit.
7.Enter parameters and values from CSV Properties and Values, as required.
2.Click OK.
RSVP.CSV.DELIMITER - The field delimiter character used for CSV output.
Enter one of the following:
•a single character
If you enter more than one character, only the first character is used.
•TAB (tab)
This is the default value.
RSVP.CSV.QUALIFIER
The string qualifier used for CSV output.
The default value is " (quotation mark).
Enter a single character. If you enter more than one character, only the first character is used.
If the qualifier appears as part of your data, it is duplicated. For example, if the qualifier is a quotation mark and your data is ab"cd, the CSV output is "ab""cd".
Check IBM Administrator guide under customisation for below steps and detailed list of variables
you can set
1.Start IBM® Cognos® Connection.
2.In the upper-right corner, click Launch, IBM Cognos Administration.
3.On the Status tab, click System.
4.From the System drop-down menu, click Set properties.
5.Click the Settings tab.
6.Next to Environment, Advanced Settings, click Edit.
7.Enter parameters and values from CSV Properties and Values, as required.
2.Click OK.
RSVP.CSV.DELIMITER - The field delimiter character used for CSV output.
Enter one of the following:
•a single character
If you enter more than one character, only the first character is used.
•TAB (tab)
This is the default value.
RSVP.CSV.QUALIFIER
The string qualifier used for CSV output.
The default value is " (quotation mark).
Enter a single character. If you enter more than one character, only the first character is used.
If the qualifier appears as part of your data, it is duplicated. For example, if the qualifier is a quotation mark and your data is ab"cd, the CSV output is "ab""cd".
CFG-ERR-0103 Unable to start IBM Cognos service
Hi Guys
I faced this error today while starting cognos services .
CFG-ERR-0103 Unable to start IBM Cognos service.
Execution of the external process returns an error code value of '-1'.
This error was due to LDAP that i was trying to configure .I deleted the LDAP and started cognos again and the error was not there.
I faced this error today while starting cognos services .
CFG-ERR-0103 Unable to start IBM Cognos service.
Execution of the external process returns an error code value of '-1'.
This error was due to LDAP that i was trying to configure .I deleted the LDAP and started cognos again and the error was not there.
GMAIL-Your Free SMTP server for Cognos
Hi Guys
Considering your are configuring a cognos on your laptop and need to have a SMTP server.The easiest way to do it is use a gmail account below are the steps for that.
To enable that feature you need to have email account, and also have access to SMTP server (outgoing message server). You may download any smtp server, but the easiest solution is to open an account at gmail.com (or any other free email site, witch allow you to use smtp server for free).
Open gmail account, and go to the Cognos configuration => Data Access => Notification. Change “SMTP mail server” to smtp.gmail.com:587. In “account and password” field provide your account name like your_account_name@gmail.com and your gmail password. In “Default sender” match email where you want to receive notification, for example your new gmail. Save changes and restart server.
Considering your are configuring a cognos on your laptop and need to have a SMTP server.The easiest way to do it is use a gmail account below are the steps for that.
To enable that feature you need to have email account, and also have access to SMTP server (outgoing message server). You may download any smtp server, but the easiest solution is to open an account at gmail.com (or any other free email site, witch allow you to use smtp server for free).
Open gmail account, and go to the Cognos configuration => Data Access => Notification. Change “SMTP mail server” to smtp.gmail.com:587. In “account and password” field provide your account name like your_account_name@gmail.com and your gmail password. In “Default sender” match email where you want to receive notification, for example your new gmail. Save changes and restart server.
OP-ERR-0144 Grouping on a property or property expression error
Hi Guys
I was getting this error while creating chart
As mentioned in ITtoolbox i checked for changing Auto group and summarise to NO and does and define member sets to YES but it did nothing
Thing to check is when you have a hierarchy you cant use distinct it gives you a error.Though you can use count(distinct ) it gives you a warning.
However you can use distinct safely in a relational model without warnings.
In a hierarchy or a dimensional model there are few things you can apply distinct or unique on. You cant apply to everything thats under a level .This is a basic cause of this error .Now you need to find a work around to get your work done as it cant be done straight as it is in the model.
If you have a chart where you want to see revenue by country and you put country as a x axis and revenue as y axis . when you validate you get this eerror - What is the cause . The country is defined as property in hierarchy branch and it cannot be used to group by in chart .. chart shows rrepeated country names .as shown below
If you want to replicate this error .Open go sales dw . sales and marketing folder > sales names space > branch hierarchy > country and revenue from fact in sales names space .You will get this error .The chart iwont be able to summarise values for united states and it will show values depending on how many individual cities are there ...
How this was solve
When working with dimensional model grouping is only applied on member keys by default .That is if you drag a item from hierarchy into a chart like region , branch , country make sure that the thing is the member key of the level because grouping in a chart will be by default done on this key . Suppose you drag country from branch level in go sales dw >sales marketing >sales >branch you will see that the groupin is done on brach code even though you have dragged country as x axis. and you have OP-ERR-0144 warning while validating .However your report runs fine .But data is not grouped by country in the chart its grouped by branch code.
Now since branch code is above country (Branch code - America ,Asia,Australia) .You will see country repeated multiple times .
To get rid of this issue
Click query . set overide dimensional info to yes .You will see one more tab in query . Go there make country as level and country name as key .Now you will see that your report is running fine.
I was getting this error while creating chart
As mentioned in ITtoolbox i checked for changing Auto group and summarise to NO and does and define member sets to YES but it did nothing
Thing to check is when you have a hierarchy you cant use distinct it gives you a error.Though you can use count(distinct ) it gives you a warning.
However you can use distinct safely in a relational model without warnings.
In a hierarchy or a dimensional model there are few things you can apply distinct or unique on. You cant apply to everything thats under a level .This is a basic cause of this error .Now you need to find a work around to get your work done as it cant be done straight as it is in the model.
If you have a chart where you want to see revenue by country and you put country as a x axis and revenue as y axis . when you validate you get this eerror - What is the cause . The country is defined as property in hierarchy branch and it cannot be used to group by in chart .. chart shows rrepeated country names .as shown below
If you want to replicate this error .Open go sales dw . sales and marketing folder > sales names space > branch hierarchy > country and revenue from fact in sales names space .You will get this error .The chart iwont be able to summarise values for united states and it will show values depending on how many individual cities are there ...
How this was solve
When working with dimensional model grouping is only applied on member keys by default .That is if you drag a item from hierarchy into a chart like region , branch , country make sure that the thing is the member key of the level because grouping in a chart will be by default done on this key . Suppose you drag country from branch level in go sales dw >sales marketing >sales >branch you will see that the groupin is done on brach code even though you have dragged country as x axis. and you have OP-ERR-0144 warning while validating .However your report runs fine .But data is not grouped by country in the chart its grouped by branch code.
Now since branch code is above country (Branch code - America ,Asia,Australia) .You will see country repeated multiple times .
To get rid of this issue
Click query . set overide dimensional info to yes .You will see one more tab in query . Go there make country as level and country name as key .Now you will see that your report is running fine.
Friday, 28 October 2011
How to rename burst output files
report output format .xlwa when scheduled
Hi Guys
I am using cognos 10 and i have set a folder on cognos server where i want to save report output for report that are scheduled/burst .What i notice is when i try to schedule excel 2007 report.They gets saved in this location as .xlwa now this is suprising and even html reports get saved as .mht
Below is the IBM setting to get rid of this issue .I always paste it here as you can be never sure of ibm link they tend to change over time and gives a broken link
Problem(Abstract)
When using the CM.OUTPUTLOCATION directive, Excel files are exported as .MHT files (the RSVP.FILE.EXTENSION.XLS directive doesn't apply here), and a method was requested to automatically rename the files to .XLS
Environment
The attached batch file is suitable for Windows 2000 / XP / 2003 environments.
Resolving the problem
Using the following in a CM.OutputScript will automatically rename each .MHT file to .XLS as it is produced.
@echo off
cd x:\{report location}
ren x:\{report location}\*.mht *.xls
Steps:
Create a batch file containing the above code.
Add the CM.OutputScript directive, pointing to the path containing the script, into the Advanced Settings for the Content Manager service.
Detailed instructions for setting the CM.OutputScript parameter are contained in the Administration and Security Guide (ug_cra.pdf) shipped with the product, in the chapter entitled "Server Administration"
You can check my earlier post about bursting reports .There its explained how to set this parameter .
http://cognossimplified.blogspot.com/2011/10/where-report-output-from-bursting-are.html
I am using cognos 10 and i have set a folder on cognos server where i want to save report output for report that are scheduled/burst .What i notice is when i try to schedule excel 2007 report.They gets saved in this location as .xlwa now this is suprising and even html reports get saved as .mht
Below is the IBM setting to get rid of this issue .I always paste it here as you can be never sure of ibm link they tend to change over time and gives a broken link
Problem(Abstract)
When using the CM.OUTPUTLOCATION directive, Excel files are exported as .MHT files (the RSVP.FILE.EXTENSION.XLS directive doesn't apply here), and a method was requested to automatically rename the files to .XLS
Environment
The attached batch file is suitable for Windows 2000 / XP / 2003 environments.
Resolving the problem
Using the following in a CM.OutputScript will automatically rename each .MHT file to .XLS as it is produced.
@echo off
cd x:\{report location}
ren x:\{report location}\*.mht *.xls
Steps:
Create a batch file containing the above code.
Add the CM.OutputScript directive, pointing to the path containing the script, into the Advanced Settings for the Content Manager service.
Detailed instructions for setting the CM.OutputScript parameter are contained in the Administration and Security Guide (ug_cra.pdf) shipped with the product, in the chapter entitled "Server Administration"
You can check my earlier post about bursting reports .There its explained how to set this parameter .
http://cognossimplified.blogspot.com/2011/10/where-report-output-from-bursting-are.html
Thursday, 27 October 2011
How to burst a Crosstab and Charts in cognos
Hi Guys
Below are the steps to burst a crosstab report
1) Add the burst key to a data container with one dimension, such as a list report. To burst a data container with multiple dimensions such as a chart or crosstab, create a master-detail relationship between this query and a single dimensional query, and then add the burst key to the single dimensional query.
2) Drop the crosstab within a list object that contains the burst key. Please see the attached Cognos 8.2 report spec going against the GO Sales and Retailers package.
3)Create a list report with the data item (Staff Name (Multiscript)) that you want to burst on as your first column. This will be the master list.
4)Insert your chart or crosstab as the second column of the list. This automatically creates a second query, which will be the detail query.
Add data items to your crosstab as needed. (Order Method as Rows, Order Year as Column, Quantity as Measure)
5)In the list, create a section with the item you want to group on. This is for formatting only.
Hide the list column title under the List property General -> Column Titles -> Hide.
6)In the Query Explorer, add the burst key data item that is in Query1 to Query2 (Staff Name and Email) Select a crosstab cell and use the ancestor tool to move up to 'Crosstab' In the properties for the crosstab, edit the Master Detail Relationship property to link the burst key in both queries. (Staff Name)
7)Click on the row section of the crosstab (Order Method in the example provided). In the properties pane under Data, open the Properties dialog and click on the box for the burst key so it is checked.
Set Burst Options to burst on the list object's burst key.
Burst the report and view the results.
Below are the steps to burst a crosstab report
1) Add the burst key to a data container with one dimension, such as a list report. To burst a data container with multiple dimensions such as a chart or crosstab, create a master-detail relationship between this query and a single dimensional query, and then add the burst key to the single dimensional query.
2) Drop the crosstab within a list object that contains the burst key. Please see the attached Cognos 8.2 report spec going against the GO Sales and Retailers package.
3)Create a list report with the data item (Staff Name (Multiscript)) that you want to burst on as your first column. This will be the master list.
4)Insert your chart or crosstab as the second column of the list. This automatically creates a second query, which will be the detail query.
Add data items to your crosstab as needed. (Order Method as Rows, Order Year as Column, Quantity as Measure)
5)In the list, create a section with the item you want to group on. This is for formatting only.
Hide the list column title under the List property General -> Column Titles -> Hide.
6)In the Query Explorer, add the burst key data item that is in Query1 to Query2 (Staff Name and Email) Select a crosstab cell and use the ancestor tool to move up to 'Crosstab' In the properties for the crosstab, edit the Master Detail Relationship property to link the burst key in both queries. (Staff Name)
7)Click on the row section of the crosstab (Order Method in the example provided). In the properties pane under Data, open the Properties dialog and click on the box for the burst key so it is checked.
Set Burst Options to burst on the list object's burst key.
Burst the report and view the results.
CNC-SDS-0408 There are email messages waiting to be sent
Hi Guys
I am facing this issue today .. so havent figured out much yet.Will post as soon as i manage to solve this
CNC-SDS-0408 There are email messages waiting to be sent.
Problem(Abstract)
Scheduled reports fail to send by e-mail even though the SMTP server tests fine in Cognos Configuration. Multiple error messages are generated.
Symptom
CNC-SDS-0408 There are email messages waiting to be sent.
CNC-SDS-0410 The email message was not sent. Approximate message size: [59 KB] The Mail server returned this error: [530 5.7.1 Client was not authenticated ]
CNC-SDS-0335 Error returned from SMTP Server. The error message was: [530 5.7.1 Client was not authenticated ]. The message could not be sent.
Cause
By default, SMTP servers are configured to block any relay messages from servers which are not on the authorized list. This is to prevent any unauthorized sender to send messages through that server.
Resolving the problemOn the SMTP server, add the IP of the Cognos application server(s) to the authorized sender list
Things that can be tried
I am trying to burst a report its giving me the above error .
Step 1
1) Try to create a normal report and schedule it.Send output by mail .If its working then atleast you are sure you have privileges to send mail .Sometimes admin block this privilege so just check to be sure.
I checked it and found its not happening .Contacted my cognos admin team and guess what the dev server does not have mail server configured :-) .
I am facing this issue today .. so havent figured out much yet.Will post as soon as i manage to solve this
CNC-SDS-0408 There are email messages waiting to be sent.
Problem(Abstract)
Scheduled reports fail to send by e-mail even though the SMTP server tests fine in Cognos Configuration. Multiple error messages are generated.
Symptom
CNC-SDS-0408 There are email messages waiting to be sent.
CNC-SDS-0410 The email message was not sent. Approximate message size: [59 KB] The Mail server returned this error: [530 5.7.1 Client was not authenticated ]
CNC-SDS-0335 Error returned from SMTP Server. The error message was: [530 5.7.1 Client was not authenticated ]. The message could not be sent.
Cause
By default, SMTP servers are configured to block any relay messages from servers which are not on the authorized list. This is to prevent any unauthorized sender to send messages through that server.
Resolving the problemOn the SMTP server, add the IP of the Cognos application server(s) to the authorized sender list
Things that can be tried
I am trying to burst a report its giving me the above error .
Step 1
1) Try to create a normal report and schedule it.Send output by mail .If its working then atleast you are sure you have privileges to send mail .Sometimes admin block this privilege so just check to be sure.
I checked it and found its not happening .Contacted my cognos admin team and guess what the dev server does not have mail server configured :-) .
Where report output from bursting are saved
CM.OutputLocation
The location where you want to store copies of report output files.
Old report versions are not deleted when a new one is saved. You must manage the content of the output directory to keep the report versions you want.
CM.OutputScript
The location and name of a shell script, such as a .bat or .sh file, that runs after a report output is saved to the target directory. The full file names of the output file and descriptor are passed to the script.
CM.OutputByBurstKey
When report output is distributed by bursting, it is assigned a burst key. Specify whether to store output in a subdirectory with the same name as the burst key.
Default: false (output not stored by burst key)
Steps
Start IBM Cognos Connection.
In the upper-right corner, click Launch, IBM Cognos Administration.
On the Status tab, click System.
In the upper-left corner of the Scorecard pane, click the arrow to view the Change view menu. Click Services, and then click Content Manager.
Click the arrow next to ContentManagerService to display the Actions menu, and then click Set properties.
Click the Settings tab.
Click Edit next to Advanced Settings.
Select Override the settings acquired from the parent entry.
In the Parameter column, enter the parameter name.
For example, enter CM.OutPutLocation.
In the Value column, enter the associated value for the setting.
Continue entering setting names and values as required.
Click OK.
On the Set properties page, click OK.
The location where you want to store copies of report output files.
Old report versions are not deleted when a new one is saved. You must manage the content of the output directory to keep the report versions you want.
CM.OutputScript
The location and name of a shell script, such as a .bat or .sh file, that runs after a report output is saved to the target directory. The full file names of the output file and descriptor are passed to the script.
CM.OutputByBurstKey
When report output is distributed by bursting, it is assigned a burst key. Specify whether to store output in a subdirectory with the same name as the burst key.
Default: false (output not stored by burst key)
Steps
Start IBM Cognos Connection.
In the upper-right corner, click Launch, IBM Cognos Administration.
On the Status tab, click System.
In the upper-left corner of the Scorecard pane, click the arrow to view the Change view menu. Click Services, and then click Content Manager.
Click the arrow next to ContentManagerService to display the Actions menu, and then click Set properties.
Click the Settings tab.
Click Edit next to Advanced Settings.
Select Override the settings acquired from the parent entry.
In the Parameter column, enter the parameter name.
For example, enter CM.OutPutLocation.
In the Value column, enter the associated value for the setting.
Continue entering setting names and values as required.
Click OK.
On the Set properties page, click OK.
Bursting report views in cognos
Hi Guys
Below is bursting explained
Bursting is made up of 3 components
The Burst Query or Report Query:
The report query that needs to be burst. The report could be a single query report or multi-query report. In case of a multi-query report, each data container in the report needs to have a master-detail relationship set up with the burst group query.
The Burst Group Query:
The query that decides the burst group. For each record in the burst group query the report is sliced.
Example:: A report needs to be burst for each Sales Regions. In this case the burst group would be the Sales Region.
The report is sliced for each Sales Region record generated by the burst group query.
The Burst Recipient Query: The query that provides the recipient information.
Scenario 1: A single Burst Query, Burst Group Query, Burst Recipient Query.
In this case the list in the report, the burst group and the burst recipient information is fed by a single query.
Example: Burst a Sales report based on Sales Regions to be made available to users through Cognos Connection
Directory.
Query 1 Data Items: Year, Sales Region, Sales, Recipient.
Recipient - CAMID('Everyone')
In the above Example, since burst group, burst recipient and list report are sourced from a single query, Cognos
runs this query once, retrieves the entire data set and then slices the report output for the various sales regions.
Hence only 1 query is fired by Cognos in this case.
Scenario 2: A single Burst Group and Burst Recipient Query but multiple report queries.
In this case the report has multiple queries. The burst group and burst recipient information is fed by a single
query.
Example: Burst a Sales report that has 2 lists based on Sales Regions and make the report available to users through
Cognos Connection Directories.
RecipientQuery (Master Query) - Sales Region, Recipient
ListQuery1 (List Query 1) - Year, Sales Region, Revenue
ListQuery2 (List Query 2) - Year, Sales Region, Sales Target
You would need to create master-detail relationships between the Master Query and the 2 List queries. The Burst
Group and Recipient query would be the master query
the above example, since the burst group and burst recipient is sourced from a single query, this query is run once before the start of bursting process. Then for each record retrieved by the burst query the detail queries are fired once each.
Say we have 100 sales regions. The master query is fired once and the 100 records are retrieved. Then for each Sales region the 2 detail queries are fired. So you would see a total of 2 * 100 queries fired against the DB in sequence.
It is in the above scenario that you would see the entire burst process taking time to complete. Assume each report output is generated in 1 minute. The entire burst process in the above example is completed in 100 minutes and that is like more than an hour.
Below is bursting explained
Bursting is made up of 3 components
The Burst Query or Report Query:
The report query that needs to be burst. The report could be a single query report or multi-query report. In case of a multi-query report, each data container in the report needs to have a master-detail relationship set up with the burst group query.
The Burst Group Query:
The query that decides the burst group. For each record in the burst group query the report is sliced.
Example:: A report needs to be burst for each Sales Regions. In this case the burst group would be the Sales Region.
The report is sliced for each Sales Region record generated by the burst group query.
The Burst Recipient Query: The query that provides the recipient information.
Scenario 1: A single Burst Query, Burst Group Query, Burst Recipient Query.
In this case the list in the report, the burst group and the burst recipient information is fed by a single query.
Example: Burst a Sales report based on Sales Regions to be made available to users through Cognos Connection
Directory.
Query 1 Data Items: Year, Sales Region, Sales, Recipient.
Recipient - CAMID('Everyone')
In the above Example, since burst group, burst recipient and list report are sourced from a single query, Cognos
runs this query once, retrieves the entire data set and then slices the report output for the various sales regions.
Hence only 1 query is fired by Cognos in this case.
Scenario 2: A single Burst Group and Burst Recipient Query but multiple report queries.
In this case the report has multiple queries. The burst group and burst recipient information is fed by a single
query.
Example: Burst a Sales report that has 2 lists based on Sales Regions and make the report available to users through
Cognos Connection Directories.
RecipientQuery (Master Query) - Sales Region, Recipient
ListQuery1 (List Query 1) - Year, Sales Region, Revenue
ListQuery2 (List Query 2) - Year, Sales Region, Sales Target
You would need to create master-detail relationships between the Master Query and the 2 List queries. The Burst
Group and Recipient query would be the master query
the above example, since the burst group and burst recipient is sourced from a single query, this query is run once before the start of bursting process. Then for each record retrieved by the burst query the detail queries are fired once each.
Say we have 100 sales regions. The master query is fired once and the 100 records are retrieved. Then for each Sales region the 2 detail queries are fired. So you would see a total of 2 * 100 queries fired against the DB in sequence.
It is in the above scenario that you would see the entire burst process taking time to complete. Assume each report output is generated in 1 minute. The entire burst process in the above example is completed in 100 minutes and that is like more than an hour.
Wednesday, 26 October 2011
RSV-VAL-0016 The burst query Summary cannot be a nested query
Hi Guys
Below is the extract from IBM about the error.
Problem(Abstract)An error message is returned when validating a burst report.
Symptom
RSV-VAL-0016 The burst query cannot be a nested query.
Cause
A Report Object related to the burst query is nested inside another object which is related to another query. (For example, a list nested inside another list). The burst query cannot be nested inside another query.
Resolving the problemReview the report specification, and ensure that if any nesting exists, the burst query is reflected on the outer-most level of nesting.
Steps:
It may be helpful to review the structure of the report.
From Report Studio:
1. Click View-->Page Structure
2. Expand the document structure, and review the query properties for each container (list, crosstab, etc..)
Ensure the outer-most object is associated with the query used for the bursting options.
So this is what i did to resolve it
I was using a shorcut query (A query reference) called summary and and data item from this i was using to create burst group query and burst receipeint query . I changed both burst recepeint and burst group to point to souce of this query reference and this solved the issue .I was able to burst the report .
Point to remember
Burst query should be outer most query in the nesting .So if you have a query associated with page then that is the outermost query .So the query used for bursting and query used for page should be same otherwise you will get the following error - RSV-VAL-0016 The burst query Summary cannot be a nested query
To know more about bursting .. burst qroup queries and burst receipient queries check below link of my blog
Below is the extract from IBM about the error.
Problem(Abstract)An error message is returned when validating a burst report.
Symptom
RSV-VAL-0016 The burst query
Cause
A Report Object related to the burst query is nested inside another object which is related to another query. (For example, a list nested inside another list). The burst query cannot be nested inside another query.
Resolving the problemReview the report specification, and ensure that if any nesting exists, the burst query is reflected on the outer-most level of nesting.
Steps:
It may be helpful to review the structure of the report.
From Report Studio:
1. Click View-->Page Structure
2. Expand the document structure, and review the query properties for each container (list, crosstab, etc..)
Ensure the outer-most object is associated with the query used for the bursting options.
So this is what i did to resolve it
I was using a shorcut query (A query reference) called summary and and data item from this i was using to create burst group query and burst receipeint query . I changed both burst recepeint and burst group to point to souce of this query reference and this solved the issue .I was able to burst the report .
Point to remember
Burst query should be outer most query in the nesting .So if you have a query associated with page then that is the outermost query .So the query used for bursting and query used for page should be same otherwise you will get the following error - RSV-VAL-0016 The burst query Summary cannot be a nested query
To know more about bursting .. burst qroup queries and burst receipient queries check below link of my blog
CFG-ERR-0106 Cognos Configuration received no response from the Cognos 8 service in the allotted time.
Hi Guys
I faced this issue recently.I have installed cognos 10 on my system .suddently today morning when i tried to start cognos service on my system .The cognos connection page was not appearing it was getting stuck and page was showing still loading . Though the cognos configuration shows started succesfully .
The first place to check in such case if cogserver.log file in configuration folder .It showed me the CFG ERR 0106 error .so below is how to procedd in case you get this error .
Steps
1) Check if your Java folder has been recently updated that is in program files earlier you were using JRE 1.4 and now its 1.6 .C:\Program Files\Java\jre6 (Here folder name jre 6 says i am using java 1.6) .
Now in normal case when you have not defined variable JAVA_HOME for your pc.This path is included in your system variable . as path variable
Right Click on my computer >Advanced system settings >environment variable >system variable and under sytem variable path (path in lower letters is the default .. in case some on has changed anything by mistake) .Here you will have path set to lot of path and one of them will be C:\Program Files\Java\jre6
OR
It can be your cognos installation JRE path C:\Datawarehousing_cognos_10\bin\jre( Datawarehousing_cognos_10 is my cognos installation folder , your will be different)
now if its any of the above its fine .There are lot of sites saying stuff to change dont bother to do so .
2) NOW THE CAUSE OF ISSUE - IF YOUR COGNOS WAS RUNNING FINE AND YOU SUDDENTLY CAME UP WITH THIS ISSUE
If your system has shut down suddenly in case of power failure .Where in the process did not get time to close cognos properly then the tomcat-users.xml might have incorrect entries resulting in this behavior
I opened the Catalina log file in the Tomcat folder and found the following error:
2010-12-16 18:44:34 UserDatabaseRealm[Standalone]: Exception looking up UserDatabase under key UserDatabase
javax.naming.NamingException: Content is not allowed in prolog.
The error suggests something about userdatabase.
Next i opened the tomcat-users.xml file in the Tomcat folder and found out that it had close to 300 NUL entries. Bingo..that was the problem..
I copied and pasted the contents of another tomcat-users.xml file into this one and ram IBM Cognos configuration again...yippeee...it works now...finally...ISSUE SOLVED...
Old Content of the xml file:
?NULNULNULNULNULNULNULNULNULNULNULNUL...
OR
your xml file can be totally blank which is also wrong .
Solution -Just take backup of your tomcat-user.xml file and copy paste the below .
(replace first line with for below ..
-----------------------------------------------------------------------
put starting brackets < for all of the above i have removed them due to a posting issue with this blog
I faced this issue recently.I have installed cognos 10 on my system .suddently today morning when i tried to start cognos service on my system .The cognos connection page was not appearing it was getting stuck and page was showing still loading . Though the cognos configuration shows started succesfully .
The first place to check in such case if cogserver.log file in configuration folder .It showed me the CFG ERR 0106 error .so below is how to procedd in case you get this error .
Steps
1) Check if your Java folder has been recently updated that is in program files earlier you were using JRE 1.4 and now its 1.6 .C:\Program Files\Java\jre6 (Here folder name jre 6 says i am using java 1.6) .
Now in normal case when you have not defined variable JAVA_HOME for your pc.This path is included in your system variable . as path variable
Right Click on my computer >Advanced system settings >environment variable >system variable and under sytem variable path (path in lower letters is the default .. in case some on has changed anything by mistake) .Here you will have path set to lot of path and one of them will be C:\Program Files\Java\jre6
OR
It can be your cognos installation JRE path C:\Datawarehousing_cognos_10\bin\jre( Datawarehousing_cognos_10 is my cognos installation folder , your will be different)
now if its any of the above its fine .There are lot of sites saying stuff to change dont bother to do so .
2) NOW THE CAUSE OF ISSUE - IF YOUR COGNOS WAS RUNNING FINE AND YOU SUDDENTLY CAME UP WITH THIS ISSUE
If your system has shut down suddenly in case of power failure .Where in the process did not get time to close cognos properly then the tomcat-users.xml might have incorrect entries resulting in this behavior
I opened the Catalina log file in the Tomcat folder and found the following error:
2010-12-16 18:44:34 UserDatabaseRealm[Standalone]: Exception looking up UserDatabase under key UserDatabase
javax.naming.NamingException: Content is not allowed in prolog.
The error suggests something about userdatabase.
Next i opened the tomcat-users.xml file in the Tomcat folder and found out that it had close to 300 NUL entries. Bingo..that was the problem..
I copied and pasted the contents of another tomcat-users.xml file into this one and ram IBM Cognos configuration again...yippeee...it works now...finally...ISSUE SOLVED...
Old Content of the xml file:
?NULNULNULNULNULNULNULNULNULNULNULNUL...
OR
your xml file can be totally blank which is also wrong .
Solution -Just take backup of your tomcat-user.xml file and copy paste the below .
(replace first line with for below ..
--------------------------------------------------------------------
?xml version='1.0' encoding='utf-8'?>
tomcat-users>
role rolename="role1"/>
role rolename="tomcat"/>
user username="role1" password="tomcat" roles="role1"/>
user username="both" password="tomcat" roles="tomcat,role1"/>
user username="tomcat" password="tomcat" roles="tomcat"/>
/tomcat-users>
-----------------------------------------------------------------------
put starting brackets < for all of the above i have removed them due to a posting issue with this blog
Monday, 24 October 2011
Using card decks in cognos10
Sunday, 23 October 2011
How to make active reports in Cognos 10
Hi Guys
Active reports save the file as MHTML. or mht. Its got lot of good features to try on .Second its preety fast as you dont have connect to database everytime .Its great for dashboards where you just mail it to user and user can be stunned by the how it gets the overall picture within a minute and the speed with which he can navigate .
I found this video preety interesting .This guy has added a lot of new features in cognos 10 to it .
Check out on youtube .I will be updating a few tricks how to make active reports in couple of days.
http://www.youtube.com/watch?v=K3iFtR4mHzw
Below are few question that i found interesting
1.Can you open active reports from cognos connection OR do you need to save it everytime on your local machine to open it
Any good link to check about active report
http://www.bspsoftware.com/Support/PodcastChannel/tabid/228/Default.aspx
Any Good link with sample of Active report
Cognoise has a good thread on this check out below link
http://www.cognoise.com/community/index.php?topic=17598.0
Link with Free IBM Cognos report samples XML and data
You need to use your companies IBM login to get this.Cant be your personal login.
https://www-304.ibm.com/partnerworld/wps/servlet/ContentHandler/pw_com_sfw_ba_cognos_demo
Active reports save the file as MHTML. or mht. Its got lot of good features to try on .Second its preety fast as you dont have connect to database everytime .Its great for dashboards where you just mail it to user and user can be stunned by the how it gets the overall picture within a minute and the speed with which he can navigate .
I found this video preety interesting .This guy has added a lot of new features in cognos 10 to it .
Check out on youtube .I will be updating a few tricks how to make active reports in couple of days.
http://www.youtube.com/watch?v=K3iFtR4mHzw
Below are few question that i found interesting
1.Can you open active reports from cognos connection OR do you need to save it everytime on your local machine to open it
Any good link to check about active report
http://www.bspsoftware.com/Support/PodcastChannel/tabid/228/Default.aspx
Any Good link with sample of Active report
Cognoise has a good thread on this check out below link
http://www.cognoise.com/community/index.php?topic=17598.0
Link with Free IBM Cognos report samples XML and data
You need to use your companies IBM login to get this.Cant be your personal login.
https://www-304.ibm.com/partnerworld/wps/servlet/ContentHandler/pw_com_sfw_ba_cognos_demo
Dynamic column sort in Cognos10
Hi Guys
This is a new feature in cognos10 .Where is allows you to sort by clicking on column heading.Earlier we used to do this by using drill through and up/down images .
Will write in details about this later.
Check out the below link.I have not tried it.But will try when i get time
http://www.ibm.com/developerworks/data/library/cognos/reporting/scripting_techniques/page515.html
This is a new feature in cognos10 .Where is allows you to sort by clicking on column heading.Earlier we used to do this by using drill through and up/down images .
Will write in details about this later.
Check out the below link.I have not tried it.But will try when i get time
http://www.ibm.com/developerworks/data/library/cognos/reporting/scripting_techniques/page515.html
How to Freeze column headers in excel using Cognos 10
Hi Guys
This is one new feature i liked lot .Earlier we used to do it by using java scripts.
This is one new feature i liked lot .Earlier we used to do it by using java scripts.
Interactive reports in Cognos 10 .
Hi Guys
I have been trying to figure out how to make interactive report sample available with cognos 10 work.Currently i am able to open reports .However they seem like normal reports in report studio.Though the folder name says interactive .I guess they should show tooltips atleast .
Have to enable scripts for it .The scripts are avaible in cognos 10 samples but i cant figure out how to enable them or instal them with cognos .
Using oracle 11g as db
I have been trying to figure out how to make interactive report sample available with cognos 10 work.Currently i am able to open reports .However they seem like normal reports in report studio.Though the folder name says interactive .I guess they should show tooltips atleast .
Have to enable scripts for it .The scripts are avaible in cognos 10 samples but i cant figure out how to enable them or instal them with cognos .
Using oracle 11g as db
Saturday, 22 October 2011
IBM Cognos and JavaScript – Part I
Hi Guys
Nice article on Using Java scripts in Cognos 10
Ironside group , Java scripts
1) Get all the available tables on the page
a =document.getelementbytagname('Table')
2)Once you have all the tables try to get your table
b =a.items(1) -------- considering yours is the first table
3) once you get your table you can play with its properties like
b.classname
b.rows(0).cells(0)
b.title
Below is a sample code
<script language="javascript" type="text/javascript">
document.write("Hello World!");
var tbls = document.getElementsByTagName("TABLE");
var tblCnt = tbls.length;
for(var t=0; t<tblCnt; t++)
{
var tbl = tbls.item(t);
if (tbl.className == "ls")
{
var cell= tbl.rows(0).cells(0); // reach the first cell of the first row of the list table
alert( cell.firstChild.innerHTML); //display the first cell content/text
}
}
</script>
Below is the script to add new option into a Prompt
var myselect=document.getElementById("sample")
myselect.options[0]=new Option("New 1st option", "who") //replace 1st option with a new one
myselect.options[myselect.length]=new Option("Brand new option", "what") //add a new option to the end of
How to Debug ERRORS
basic idea to debug it write your output from each step that way you can debug ;
<script language="javascript" type="text/javascript">
var txt="Hello World!";
var a =txt.length;
document.write(txt.length);
</script>
What are Objects
There are objects in java script like txt , date etc and there are methods to these objects like to uppercase to lowercase etc
Below are the methods available with string object
txt.big()
txt.small
txt.bold()
txt.fontcolor(green)
txt.fontsize(6)
txt.link("www.google.com")
txt.blink()
txt.touppercase()
txt.tolowercase()
write(str.search(/w3schools/i));--- performs case insensitive search
var str="Hello world!";
document.write(str.match(/WORLD/ i);
How to create Drop down list in Cognos
<script language="javascript" type="text/javascript">
function alertselected(selectobj)
{
alert(selectobj.selectedIndex)
}
</script>
<form id="someform">
<select id="sample" onChange="alertselected(this)">
<option>Option 1</option>
<option>Option 2</option>
<option>Option 3</option>
</select>
</form>
Below is script to remove the parameter name
<script language ="Javascript" Type ="Text/Javascript">
var fw = getFormWarpRequest();
var dropdown=fw._oLstChoicesyearprompt;
dropdown.remove(0);
dropdown.remove(0);
</script>
------------
Nice article on Using Java scripts in Cognos 10
Ironside group , Java scripts
1) Get all the available tables on the page
a =document.getelementbytagname('Table')
2)Once you have all the tables try to get your table
b =a.items(1) -------- considering yours is the first table
3) once you get your table you can play with its properties like
b.classname
b.rows(0).cells(0)
b.title
Below is a sample code
<script language="javascript" type="text/javascript">
document.write("Hello World!");
var tbls = document.getElementsByTagName("TABLE");
var tblCnt = tbls.length;
for(var t=0; t<tblCnt; t++)
{
var tbl = tbls.item(t);
if (tbl.className == "ls")
{
var cell= tbl.rows(0).cells(0); // reach the first cell of the first row of the list table
alert( cell.firstChild.innerHTML); //display the first cell content/text
}
}
</script>
Below is the script to add new option into a Prompt
var myselect=document.getElementById("sample")
myselect.options[0]=new Option("New 1st option", "who") //replace 1st option with a new one
myselect.options[myselect.length]=new Option("Brand new option", "what") //add a new option to the end of
How to Debug ERRORS
basic idea to debug it write your output from each step that way you can debug ;
<script language="javascript" type="text/javascript">
var txt="Hello World!";
var a =txt.length;
document.write(txt.length);
</script>
What are Objects
There are objects in java script like txt , date etc and there are methods to these objects like to uppercase to lowercase etc
Below are the methods available with string object
txt.big()
txt.small
txt.bold()
txt.fontcolor(green)
txt.fontsize(6)
txt.link("www.google.com")
txt.blink()
txt.touppercase()
txt.tolowercase()
write(str.search(/w3schools/i));--- performs case insensitive search
var str="Hello world!";
document.write(str.match(/WORLD/ i);
How to create Drop down list in Cognos
<script language="javascript" type="text/javascript">
function alertselected(selectobj)
{
alert(selectobj.selectedIndex)
}
</script>
<form id="someform">
<select id="sample" onChange="alertselected(this)">
<option>Option 1</option>
<option>Option 2</option>
<option>Option 3</option>
</select>
</form>
Below is script to remove the parameter name
<script language ="Javascript" Type ="Text/Javascript">
var fw = getFormWarpRequest();
var dropdown=fw._oLstChoicesyearprompt;
dropdown.remove(0);
dropdown.remove(0);
</script>
------------
How to add tool tip to cognos10 report
Hi Guys
You can show a tool tip each time your cursor passes over certain .List or crosstab header in cognos . Basically Cognos is just a HTML page.
You can show a tool tip each time your cursor passes over certain .List or crosstab header in cognos . Basically Cognos is just a HTML page.
Whats new in Cognos 10
Hi Guys ,
I have been using cognos 8.4 for about 3 years now .We are planning to move to cognos 10 starting next year.Demo environment has already been prepared and we are checking whats new and whats good in Cognos 10 so i will keep on updating things as i discover .
To start with
Report studio
1) It has automatic sorting of column values .You dont need to write that java script any more or play around with drill through
2) If some of you guys have faced it .The columns heading could not be freezed directly from cognos to excel .You had to save the report to excel and then freeze the column headers or write a java script for it .This can be done automatic now .
3) I was not aware of this , you can actually drill up /drill down in excel .Its called analysis for excel. It requires additional licencing though . But could be good if your users mostly use excel.
4) Cognos 10 gives you active reports which are lot more fun to use .Flashy i would say .
5) Cognos 10 allows you to add data from external sources with ease .Like you have a excel in which you have some data which you want to compare with your existing report .You can directly pick the excel from your desktop as datasource in report studio .No need to go to framework publish package any of those .Directly you can pick from desktop.
I have been using cognos 8.4 for about 3 years now .We are planning to move to cognos 10 starting next year.Demo environment has already been prepared and we are checking whats new and whats good in Cognos 10 so i will keep on updating things as i discover .
To start with
Report studio
1) It has automatic sorting of column values .You dont need to write that java script any more or play around with drill through
2) If some of you guys have faced it .The columns heading could not be freezed directly from cognos to excel .You had to save the report to excel and then freeze the column headers or write a java script for it .This can be done automatic now .
3) I was not aware of this , you can actually drill up /drill down in excel .Its called analysis for excel. It requires additional licencing though . But could be good if your users mostly use excel.
4) Cognos 10 gives you active reports which are lot more fun to use .Flashy i would say .
5) Cognos 10 allows you to add data from external sources with ease .Like you have a excel in which you have some data which you want to compare with your existing report .You can directly pick the excel from your desktop as datasource in report studio .No need to go to framework publish package any of those .Directly you can pick from desktop.
Cognos Drill down does not work in MS excel
Hi
If you notice lot of charts introduced by cognos are not supported by excel and most of business users use excel for day to day activities .So before you decide to use a chart ,please try to see how it functions in excel .I will list down details of various charts , how to make them and how they look in excel .
If you notice lot of charts introduced by cognos are not supported by excel and most of business users use excel for day to day activities .So before you decide to use a chart ,please try to see how it functions in excel .I will list down details of various charts , how to make them and how they look in excel .
After Cognos 10 Install not able to publish model using framework manager
Hi Guys
I had installed Cognos10 on my laptop recently.Had imported cognos10 samples to oracle database .I was able to create reports using gosales and gosalesdw package properly .However when i tried to open any .cpf file (Model) it was showing as verifying security and nothing was happening .It was giving a blank screen .
So i found out reason for it .
When you install Cognos10 make sure that you install Cognos10 BI reporting and Cognos10 Framework manager in a separate folder and allow full access to all authenticated users as well as user-PC to access the folder .
For this .. Right click on folder in which you have installed Cognos10 BI reporting , go to security tab and click on advanced .Give ful permission to every user if its you home laptop .This should solve your issue .
Remember the first line in cognos installation .The user should have admin rights on system .It means that the user should have full permission on every folder that you use for cognos10 installation.
If still you are not able to connect then .. How to debug the issue .
Copy your gateway URI from framework manager configuration to your internet explorer and see if the cognos10 public folders opens or not.In normal case it should open fine ,but if its not opening then thats the issue your URI has a problem .
Similar case with your gateway URI .when pasted in internet explorer it will open public folder page but the page will be broken .You will wont be able to see the public folder or my folder clearly only names no images .But that is all right .It means your dispatcher URI is correct.
Below is my Gateway URI for cognos10
http://localhost:80/ibmcognos/cgi-bin/cognos.cgi
It has a issue .. after localhost:80/cognos10 should come . where cognos10 is a alias that i have created in IIS or apache web server .
http://localhost:8080/cognos10/cgi-bin/cognos.cgi --correct URI
Change it and Framework manager connects properly .
I had installed Cognos10 on my laptop recently.Had imported cognos10 samples to oracle database .I was able to create reports using gosales and gosalesdw package properly .However when i tried to open any .cpf file (Model) it was showing as verifying security and nothing was happening .It was giving a blank screen .
So i found out reason for it .
When you install Cognos10 make sure that you install Cognos10 BI reporting and Cognos10 Framework manager in a separate folder and allow full access to all authenticated users as well as user-PC to access the folder .
For this .. Right click on folder in which you have installed Cognos10 BI reporting , go to security tab and click on advanced .Give ful permission to every user if its you home laptop .This should solve your issue .
Remember the first line in cognos installation .The user should have admin rights on system .It means that the user should have full permission on every folder that you use for cognos10 installation.
If still you are not able to connect then .. How to debug the issue .
Copy your gateway URI from framework manager configuration to your internet explorer and see if the cognos10 public folders opens or not.In normal case it should open fine ,but if its not opening then thats the issue your URI has a problem .
Similar case with your gateway URI .when pasted in internet explorer it will open public folder page but the page will be broken .You will wont be able to see the public folder or my folder clearly only names no images .But that is all right .It means your dispatcher URI is correct.
Below is my Gateway URI for cognos10
http://localhost:80/ibmcognos/cgi-bin/cognos.cgi
It has a issue .. after localhost:80/cognos10 should come . where cognos10 is a alias that i have created in IIS or apache web server .
http://localhost:8080/cognos10/cgi-bin/cognos.cgi --correct URI
Change it and Framework manager connects properly .
Saturday, 15 October 2011
Cognos 10 Installation on Windows
Steps
Make sure that the user who is installin cognos has admin right on system .This will ensure that framework manager,LDAP are able to communicate with cognos BI reporting properly . If you are installing on your laptop make sure that the user-PC and authenticated users has full permission to folders where you are installing cognos .To give full access right click on folder and go to security tab and click on advanced and check full access option there.
Step 1
Install Cognos components. This will take a lot and I recommend to restart the computer between every three components or so, in order to clear the cache, or whatever it is that it makes it run slower.
Step 2
Download OracleXEUniv.exe from Oraclesite and install it. Create a new user “cognos” with any password (I chose "cognos" as well) and grant all privileges to it. (NOTE - Character Set of the Database should be UNICODE)
Step 3
Locate ojdbc14.jar in oraclexe\app\oracle\product\10.2.0\server\jdbc\lib and copy it to cognos\c8\webapps\p2pd\WEB-INF\lib
If classes12.jar exists in this folder, delete it or rename it.
Step 4
Download Apache 2.2 webserver free from Apache Webserver Projectpage and install it.
Locate the file 'httpd.conf' in the\Conf and add the following text at the bottom:
# cognos
Include conf/extra/cognos8.conf
Create the file conf/extras/cognos8.conf with the following contents:
## Cognos 8
#ScriptAlias /cognos8/cgi-bin "C:/Program Files/Cognos/c8/cgi-bin"
AllowOverride None
Options None
Order Allow,Deny
Allow from All
Options None
AllowOverride None
Order Allow,Deny
Allow from All
Options None
AllowOverride None
Order Allow,Deny
Allow from All
Replace c: with d: or whatever drive letter you installed the Cognos software to.
Restart the Apache service.
Step 5
Start Cognos Configuration.
Delete whatever it is under Content Manager and create a new item called “Content Store”, of type Oracle.
Edit the user and password by clicking the pen that appears when selecting the field. User “cognos”, password “cognos”.
Service name is “XE”.
Right click on Content Store and Test.
If all’s right click the green play button to start the service.
You can close Cognos Configuration now, as the service will continue to run in the background.
Step 6
Test that Cognos Connection is working by calling the link http://127.0.0.1/cognos8 or http://localhost/cognos8.
I strongly advise to right click on the Apache icon in the tray bar and select “Open Services”. From this window, set all the Cognos, Oracle and Apache services to start manually instead of automatically. Otherwise all these services will attempt to start automatically on Windows startup and this takes a lot of time.
To start the services manually you have to (in this order):
Click “Start Database” from Oracle start menu
Start Cognos Configuration and click the play button
Start the Apache service from the tray icon
If you want to start the services manually rather than allowing then to start automatically at system restart then create a Windows batch command file to start Cognos as follows:
start_cognos.bat
net start "Oracle"net start "Cognos 8"
net start "Apache2"
If you don't want to keep all these services running when you have finished your work then create a Windows batch command file to stop the services when you have finished:
stop_cognos.bat
net stop "Apach2"net stop "Cognos 8"
net stop "Oracle"
You may want to clear up some of the Cognos server logs as part of your startup/shutdown processing, just add the line to your startup or shutdown scripts.
erase /f /q "C:\Program Files\Cognos\c8\logs\*.*" Don't forget that Apache also has its own log files that can grow quite large and you may want to clear these out quite frequently.
NB - if you are using Cgonso 8.4 then you should change the name to "IBM Cognos 8"
Step 7
You should now import the samples.
Create five users in OracleXE called gosales, gosalesdw, gosaleshr, gosalesmr and gosalesrt. The password should be the same as the user id. Make sure to grant them all the privileges.
Go to cognos\c8\webcontent\samples\datasources\oracle and extract the .gz files.
Under this folder run the following commands:
(Atcommand prompt not at sqlplus command window)
imp gosales/gosales file = GOSALES.dmp full=y log=log.txt
imp gosaleshr/gosaleshr file = GOSALESHR.dmp full=y log=log.txt
imp gosalesdw/gosalesdw file = GOSALESDW.dmp full=y log=log.txt
imp gosalesmr/gosalesmr file = GOSALESMR.dmp full=y log=log.txt
imp gosalesrt/gosalesrt file = GOSALESRT.dmp full=y log=log.txt
imp CSTATD/CSTATD file =CSTATD.dmp full=y log=log.txt -- this is important for statistics reporting examples
If you are getting ora-1031 .Not enough privileges for Alter.You can put ignore=y after log statemt this will import data but constraint wont be created that is ok as sample will work.
In cognos 10 we do not have separate models for gosaleshr,gosalesmr,gosalesrt .All of them come under gosales . you need to give read permission to gosales users in this 3 schema .
If you check the model you will see there are 3 datasources there ,gosales, gosales1,gosales2 all of them are pointing to different schema but using same datasource .
grant all privileges to gosales;
Step 8
In Cognos Connection select Cognos Administration and then Configuration.
Click the “New Data Source” button.
Type “gosales” for name and click Next.
Select “Oracle” for type and click Next.
Type “xe” for connection string (small caps needed). Select User ID and Password checkboxes. Enter “gosales” for user ID and the same for password.
Test the connection. In case of failure restart the Oracle database.
If all goes well click Finish.
Repeat the steps for gosalesdw, and the rest.
Step 9
Open Framework Manager.
Open project C:\Program Files\cognos\c8\webcontent\samples\Models\ great_outdoors_sales\ great_outdoors_sales.cpf
If you get an error during opening try replacing localhost:80 with 127.0.0.1:80in Cognos Configuration gateway URI.
Expand Data Sources and for each data source check that the “Content Manager Datasource” and “Schema” have the same value (gosales, gosalesdw,…).
Also modify the Interface (under Type) to “OR” instead of “OL”.
Test each Data Source. In case of failure restart the Oracle database. Save your changes to the project file.
Expand Packages and publish each package (right click -> publish packages..).
Ignore the errors.
Save and exit.
Do the same for project C:\Program Files\cognos\c8\webcontent\samples\Models\ great_outdoors_warehouse\great_outdoors_warehouse.cpf
Step 10
Copy Cognos_Samples.zip from c8\webcontent\samples\content to c8\deployment.
Open Cognos Connection and select Cognos Administration -> Configuration -> Content Administration.
Click New Import icon.
Cognos_Samples should appear in the list. Select Next, then Next again.
On the ‘Select the Public Folders Content’ page, select the checkbox to the left of the Cognos_Samples package.
Select Next, Next again, then Import Now.
Step 11
You should be able to see the sample database folders under local folders in Cognos Connection.
Reply Forward
Make sure that the user who is installin cognos has admin right on system .This will ensure that framework manager,LDAP are able to communicate with cognos BI reporting properly . If you are installing on your laptop make sure that the user-PC and authenticated users has full permission to folders where you are installing cognos .To give full access right click on folder and go to security tab and click on advanced and check full access option there.
Step 1
Install Cognos components. This will take a lot and I recommend to restart the computer between every three components or so, in order to clear the cache, or whatever it is that it makes it run slower.
Step 2
Download OracleXEUniv.exe from Oraclesite and install it. Create a new user “cognos” with any password (I chose "cognos" as well) and grant all privileges to it. (NOTE - Character Set of the Database should be UNICODE)
Step 3
Locate ojdbc14.jar in oraclexe\app\oracle\product\10.2.0\server\jdbc\lib and copy it to cognos\c8\webapps\p2pd\WEB-INF\lib
If classes12.jar exists in this folder, delete it or rename it.
Step 4
Download Apache 2.2 webserver free from Apache Webserver Projectpage and install it.
Locate the file 'httpd.conf' in the
# cognos
Include conf/extra/cognos8.conf
Create the file conf/extras/cognos8.conf with the following contents:
## Cognos 8
#ScriptAlias /cognos8/cgi-bin "C:/Program Files/Cognos/c8/cgi-bin"
AllowOverride None
Options None
Order Allow,Deny
Allow from All
Options None
AllowOverride None
Order Allow,Deny
Allow from All
Options None
AllowOverride None
Order Allow,Deny
Allow from All
Replace c: with d: or whatever drive letter you installed the Cognos software to.
Restart the Apache service.
Step 5
Start Cognos Configuration.
Delete whatever it is under Content Manager and create a new item called “Content Store”, of type Oracle.
Edit the user and password by clicking the pen that appears when selecting the field. User “cognos”, password “cognos”.
Service name is “XE”.
Right click on Content Store and Test.
If all’s right click the green play button to start the service.
You can close Cognos Configuration now, as the service will continue to run in the background.
Step 6
Test that Cognos Connection is working by calling the link http://127.0.0.1/cognos8 or http://localhost/cognos8.
I strongly advise to right click on the Apache icon in the tray bar and select “Open Services”. From this window, set all the Cognos, Oracle and Apache services to start manually instead of automatically. Otherwise all these services will attempt to start automatically on Windows startup and this takes a lot of time.
To start the services manually you have to (in this order):
Click “Start Database” from Oracle start menu
Start Cognos Configuration and click the play button
Start the Apache service from the tray icon
If you want to start the services manually rather than allowing then to start automatically at system restart then create a Windows batch command file to start Cognos as follows:
start_cognos.bat
net start "Oracle"net start "Cognos 8"
net start "Apache2"
If you don't want to keep all these services running when you have finished your work then create a Windows batch command file to stop the services when you have finished:
stop_cognos.bat
net stop "Apach2"net stop "Cognos 8"
net stop "Oracle"
You may want to clear up some of the Cognos server logs as part of your startup/shutdown processing, just add the line to your startup or shutdown scripts.
erase /f /q "C:\Program Files\Cognos\c8\logs\*.*" Don't forget that Apache also has its own log files that can grow quite large and you may want to clear these out quite frequently.
NB - if you are using Cgonso 8.4 then you should change the name to "IBM Cognos 8"
Step 7
You should now import the samples.
Create five users in OracleXE called gosales, gosalesdw, gosaleshr, gosalesmr and gosalesrt. The password should be the same as the user id. Make sure to grant them all the privileges.
Go to cognos\c8\webcontent\samples\datasources\oracle and extract the .gz files.
Under this folder run the following commands:
(Atcommand prompt not at sqlplus command window)
imp gosales/gosales file = GOSALES.dmp full=y log=log.txt
imp gosaleshr/gosaleshr file = GOSALESHR.dmp full=y log=log.txt
imp gosalesdw/gosalesdw file = GOSALESDW.dmp full=y log=log.txt
imp gosalesmr/gosalesmr file = GOSALESMR.dmp full=y log=log.txt
imp gosalesrt/gosalesrt file = GOSALESRT.dmp full=y log=log.txt
imp CSTATD/CSTATD file =CSTATD.dmp full=y log=log.txt -- this is important for statistics reporting examples
If you are getting ora-1031 .Not enough privileges for Alter.You can put ignore=y after log statemt this will import data but constraint wont be created that is ok as sample will work.
In cognos 10 we do not have separate models for gosaleshr,gosalesmr,gosalesrt .All of them come under gosales . you need to give read permission to gosales users in this 3 schema .
If you check the model you will see there are 3 datasources there ,gosales, gosales1,gosales2 all of them are pointing to different schema but using same datasource .
Step 8
In Cognos Connection select Cognos Administration and then Configuration.
Click the “New Data Source” button.
Type “gosales” for name and click Next.
Select “Oracle” for type and click Next.
Type “xe” for connection string (small caps needed). Select User ID and Password checkboxes. Enter “gosales” for user ID and the same for password.
Test the connection. In case of failure restart the Oracle database.
If all goes well click Finish.
Repeat the steps for gosalesdw, and the rest.
Step 9
Open Framework Manager.
Open project C:\Program Files\cognos\c8\webcontent\samples\Models\ great_outdoors_sales\ great_outdoors_sales.cpf
If you get an error during opening try replacing localhost:80 with 127.0.0.1:80in Cognos Configuration gateway URI.
Expand Data Sources and for each data source check that the “Content Manager Datasource” and “Schema” have the same value (gosales, gosalesdw,…).
Also modify the Interface (under Type) to “OR” instead of “OL”.
Test each Data Source. In case of failure restart the Oracle database. Save your changes to the project file.
Expand Packages and publish each package (right click -> publish packages..).
Ignore the errors.
Save and exit.
Do the same for project C:\Program Files\cognos\c8\webcontent\samples\Models\ great_outdoors_warehouse\great_outdoors_warehouse.cpf
Step 10
Copy Cognos_Samples.zip from c8\webcontent\samples\content to c8\deployment.
Open Cognos Connection and select Cognos Administration -> Configuration -> Content Administration.
Click New Import icon.
Cognos_Samples should appear in the list. Select Next, then Next again.
On the ‘Select the Public Folders Content’ page, select the checkbox to the left of the Cognos_Samples package.
Select Next, Next again, then Import Now.
Step 11
You should be able to see the sample database folders under local folders in Cognos Connection.
Reply Forward
Please use below link in case you face issue .I have listed all my issue with their solution
Issue faced by Me and their solutions
Wednesday, 12 October 2011
IBM Cognos Business Intelligence V10.1 Free Dowload
Hi Guys
IBM offers free 30 day trial version of cognos 10 .Check out the below link .
IBM also offers a demo environment where you can use cognos 10 environment for free without even having to install on your own machine ,It allows you to use all the gosales,godatawarehouse samples for free.
http://www-01.ibm.com/software/analytics/cognos/business-intelligence/trials-demos.html
IBM offers free 30 day trial version of cognos 10 .Check out the below link .
IBM also offers a demo environment where you can use cognos 10 environment for free without even having to install on your own machine ,It allows you to use all the gosales,godatawarehouse samples for free.
http://www-01.ibm.com/software/analytics/cognos/business-intelligence/trials-demos.html
Subscribe to:
Posts (Atom)