Improve report running performance
How would you be able to improve the performance in running a report? I) basically in order to tune the report what are theproperties you can set? Ii) some of the reports are running in dev (cognos environment) against the prodution database(oltp) wherethe performance is taking a hit. Is there any...
Reportnet security level filters
What are the different security level filters possible in reportnet?
There is no security as such at reoprt level.you define it at the frame work level.
it would be package level, object level , row level in framework manager.
What is repeater table ?? How its more useful over list table ??
Use repeaters to repeat items when you run the report. For example, you can use repeaters to create mailing labels, including customer names and addresses. To build a repeater, drag the Repeater or R...
Repeater table is used to create mailing lables only.it contains addressof the companies
How to hide/unhide the prompts which are not used by unauthorized users?
This is only half true when you hide any object.but here it should hide depending on user so it should add object level security in frame work.
Select the Prompt that you want to hide and the from the properties pane click OK box type, Select Hide.
What is the difference between native SQL and cognos SQL?
The Native SQL is what is being passed to the database. Where the Cognos SQL is the entire SQL used to perform the SQL. In certain scenarios, the native SQL will be a subset of the Cognos SQL which may indicate that the application will do some local processing.
Cognos SQL:By default Cognos FWM uses Cognos SQL to create and edit Query Subjects. Contain metadata from multiple Data sources.
Native SQL :But we cannot use Native SQL in a Query subject that references more than one Data source in the Project. Contain metadata from single Data Source.
Cryptographic information error in reportnet
I am unable to save cryptographic information and unable to run reportnet in web browser. So please help me.Dpr-err-2058 the dispatcher cannot service the request at this time. The dispatcher is still initializing. Iam encountering with this problem.
To avoid this problem , The following steps you need to be followed
1. Delete the jce1_2_1.jar file
2. Download jce1_2_2.jar file from http://java.sun.com/products/jce/index-122.html
3. Replace jce1_2_2.jar file
Cheers,
Anitha
I Think you are using ReportNet 1.1 MR.
Cryptography Jar files supports in Microsoft Flatforms upto May 2004.
You need to download new jar files from Cognos. Otherwise simply change the system date between Apr 15th 2004 to May 30th 2004. This works perfect.
Here we can use display value entered that means text prompt, when the user know about which data prompt has. For ex. The states of Ind.
Another way is selected by a user by using Select & Search prompt or Value Prompt
We have a function called param Display Value. By using this function we can display the parameter value selected in prompt.
What is the maximum limit(no.) of values you can display in a value prompt?
Maximum 5000 values displayed
Structure your framework manager
How would you structure your framework manager model? Would you structure into different layers?If you would structure what would be the layers like and what each of them would signify?
A model is normally structured into two layers/views. Database/ Physical view and Business/ Presentation view. These can be implemented using Namespaces.You import the metadata into Physical layer fro...
What is the difference between cognos reportnet 1.1mr1 & cognos reportnet 1.1 mr2
1. In CRN1.1MR1 you cannot add filters from toolbar button whereas CRN1.1MR2 can.
2. In CRN1.1MR1 you get incorrect date format when report is executed in Excel format whereas in CRN1.1MR2 you get the correct date format.
3. In CRN1.1MR1 you cannot export Model from FM whereas in CRN1.1MR2 you can
What is the difference between dw and bi?
Excellent joy! I bet you can be a good teacher..continue your contributions
Hi joy,
Thanks abt Ans
What is the difference between powerplay transformer and power play reports?
PowerPlay Transformer is used to build the Power cubes from Cognos PowerPlay. But PowerPlay Reports are used to create web reports...
powerplay transformer: is a powerplay modelling tool,which is used to create powerplay cube or multidimentional cube.
powerplay report: after create the cube,that cube is viewed in powerplay, so that report is powerplay report.
Whenever any changes are done in FM level , re-publish the package , so that when using the report in the report studio , it will always takes only the latest version of the package and run...
In reportnet Attribute Call as A Queryitem
In reportnet identifier Call as A Condition
In reportnet Fact Call as A Measure or NumericValue.
hi dhana
Can you please provide the java script statement for it or any related example.
Thanks
You can solve this issue by placing the HTML item which contains JavaScript, change the name of the dataprompt into JavaScript name, then you can specify the month start date.
Let me know if you have any queries.
Thanks
Dhana.
How do you use sum function in reportnet?
i think there is sum function in report net we use total function from functions tab ,here sum means summation thats it ,
regards
shnkar
What are the steps of testing and how to test reports in reportnet?
Generally we do the testing in three ways we find static errors ,dynamic errors,and data base errors.we can compre the report out put and data base out put here we no need to check every record with r...
testing of a report
as per the mark-ups we will test the report
mark-up means ,it is a sample layout.
they will give how many prompts should be used,filters,conditions
then we will insert all these in a report.this is called as unit testing
for system testing ask testing people
What is the main advantage of impromptu over cognos reportnet?
Drabacks of Impromptu:
1) Impromptu is windows based application
2) It Does not support multiple data sources ( Cube)
3) No Multilingual Support.
In both we can post the reports to web but can't do modifications in Impromptu .Correct me if m wrong
How do you remove spaces from middle of the name in reportnet
In reportnet, I am trying to remove a space from the name field. What I want is to end up with the following but it doesn't like my syntax: substring([ces archive: transactions].[expense report workflow trail].[employee assigned to step],1,6)||substring([ces archive: transactions].[expense report workflow...
I dont think so., Ltrim and Rtrim is used to remove spaces on left hand side and r.h.s
but in the middle there functions cannot remove the spaces
use ltrim,rtrim functions for removing space in middle of the name
60 table model in framework manager
Given a scenario in which there are about 60 tables in Oracle and there needs to be created a model in framework manager. What are the different pre-requisties that needs to be addressed in order to come to a conclusion regarding estimating the time to build the model?
there should be fact tables and dimension tables,join both by primary keys,resolve the loops,verify the model,create the packages and publish them
it takes more than 1 month if the data is available
What is prompt?Types of prompts?Use of prompts?Syntax of prompt?
Prompts act as questions that help users to customize the information in a report to suit their own needs. There are 8 Prompts in ReportNet.
A prompt is can be called as a Dynamic filter. Prompt is an end user object which allows the user in selecting the values to restrict the data returned from the DataBase. A prompt can be develop...
1. Check that your query processing property is set to Database Only and not Limited Local. 2. There are Cognos functions and database functions (DB2 for example). Using one versus the other may make ...
To increase the performance of a report while running
- set the governers
-joins shuld be less
-Aggregate table should be there while using group functions
there will be a dead lock while running a report against the OLTP database.so better not to do this