-
How to create report without package?
Is it possible to create report with out package?
Jaycognos
- Apr 8th, 2008
In cognos , framework manager is mandatory which means without package it is not possible to create a report.It may be possible in other BI tools like hyperion.
-
How will you increase the performance when one report is running more then 1800 sec?
Jaycognos
- Apr 8th, 2008
Check the governor settings , see how many joins are presentcheck the filters and remove any unwanted filters or outdated information, Move all the complex calculations and filter conditions from report level to the FM level.
-
When we are running the report the date prompt always showing the sysdate.can we change this to the required date(ex before 1 week)?
Jaycognos
- Apr 17th, 2008
Hi dhana Can you please provide the java script statement for it or any related example.Thanks
Dhanasekaran
- May 2nd, 2007
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.ThanksDhana.
-
How change in usage property (attribute,identifier,fact) of query item in FM effects reports in report studio?for eg. EmployeeCode is identifier what happens when it declared as fact?
Jaycognos
- Apr 17th, 2008
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...
Rajitha
- Dec 15th, 2006
In reportnet Attribute Call as A QueryitemIn reportnet identifier Call as A ConditionIn reportnet Fact Call as A Measure or NumericValue.
-
What is the Difference between PowerPlay transformer and power play reports?
jenibala
- May 13th, 2008
PowerPlay Transformer is used to build the Power cubes from Cognos PowerPlay. But PowerPlay Reports are used to create web reports...
sarpudeen.m
- Jul 31st, 2006
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.??
-
What is the difference between DW and BI?
eshwar
- Oct 24th, 2006
Hi joy,Thanks abt Ans
-
What is the difference between Cognos ReportNet 1.1MR1 & Cognos ReportNet 1.1 MR2
zecar
- Sep 18th, 2007
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
-
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?
sandeep8000861
- Jun 18th, 2008
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...
-
Explain complex reports with examples?
4myfuture
- Sep 8th, 2008
A complex report is a report that contains many Joins, Relationships, Formatting, Filters, pagination, prompting, page association and many other Conditions.
-
-
What function should you use to display the value entered or selected by a user in response to a prompt?
Ajju B
- Sep 12th, 2008
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
viswanath.s
- Apr 5th, 2006
We have a function called param Display Value. By using this function we can display the parameter value selected in prompt.
-
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.
anitha tanniru
- Sep 26th, 2008
To avoid this problem , The following steps you need to be followed1. Delete the jce1_2_1.jar file2. Download jce1_2_2.jar file from http://java.sun.com/products/jce/index-122.html3. Replace jce1_2_2.jar fileCheers,Anitha
visitor
- Sep 2nd, 2007
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.
-
What is the difference between Native SQL and Cognos SQL?
swift_s
- Jun 1st, 2009
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.
Pavan Reddy
- Oct 19th, 2006
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.
-
Reportnet Render Variables
What are render variables?
roopacrn
- Jun 2nd, 2009
Render Variable Specifies a variable based on which the object can be conditionally rendered. Ex:In the prompt page we have text box and value prompts .First we create value prompt with values text bo...
-
Reportnet Query and Layout Calculation
What is Query Calculation?What is Layout Calculation?
hanuma.s
- Jul 14th, 2009
Difference between query Calculation and Layout CalculationLayout Calculation:It creates a calculation that contains run-time information, such as current date, current time, and user name. It provide...
nanigadu
- Jun 10th, 2008
Query calculation Means: Adds a calculated columnLayout calculation Means:Adds a calculation in the layout that contains run-time information, such as current date, current time, and user name.
-
How to convert report from Query Studio to Report Studio
hanuma.s
- Jul 14th, 2009
Connect the report studio and open the file menu click on new template.In that just select the existed report copy, there you can find the list of the reports and there from you can select what ever report you want to convert from query to report studio and then save the report in report studio.
basecog
- Oct 24th, 2007
Hi Friend it is simple, save your Query studio report in your local system, and open that report in Report studio and save where you want. Thanks, Basecog
-
How to hide/unhide the prompts which are not used by unauthorized users?
shailendra32
- Aug 21st, 2012
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.
vidiyala337
- Sep 14th, 2008
Select the Prompt that you want to hide and the from the properties pane click OK box type, Select Hide.
-
Repeater Table
What is Repeater Table ?? How its More Useful Over List Table ??
shailendra32
- Aug 21st, 2012
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...
praveenj6
- Feb 16th, 2008
Repeater table is used to create mailing lables only.it contains addressof the companies
-
ReportNet Security level filters
What are the different security level filters possible in ReportNet?
shailendra32
- Aug 21st, 2012
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. -
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 mechanism in Cognos where-in we can improve it?
shailendra32
- Aug 21st, 2012
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 ...
praveenj6
- Feb 4th, 2008
To increase the performance of a report while running - set the governers-joins shuld be less-Aggregate table should be there while using group functionsthere will be a dead lock while running a report against the OLTP database.so better not to do this
Reportnet Interview Questions
Ans