-
-
What are the disadvantages of cognos8
Vijay Patel
- Oct 20th, 2007
Whatever BO and other BI tools offer, Cognos 8 can't offer you.-You will need to learn Cognos 8 to use it if you are coming from BO and other BI tool.
zecar
- Sep 18th, 2007
Limitations:1. To access a report in Excel format on a remote server, you must change the hostname portion of the gateway URI from localhost to either the IP address of the computer or the computer na...
-
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.
-
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.
-
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.??
-
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.
-
-
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.
-
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 Trail].[Employee Assigned to Step],8,(length([CES Archive: Transactions].[Expense Report Workflow...
praveenj6
- Feb 16th, 2008
I dont think so., Ltrim and Rtrim is used to remove spaces on left hand side and r.h.sbut in the middle there functions cannot remove the spaces
-
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
-
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 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.
-
1.Explain the steps involved in the creation of model in frameworkmanager?2.What are the constraints for using tabular sets?3.How will u restrict the no of records in a single page?4.What is bursting?whats the use?5.In tabular sets,there will be two tabular models?Can I use a tabular reference instead of tabular model in one side?
Visitor
- Sep 2nd, 2007
For Burst Report:1. We need to import additionall Burst table i.e burst key, receipent name, email id. into FM.2.?Publish to Reportnet Server3. Create a report in RS.? then in File menu set the burst options (see DOCS).
prabhu2006
- Nov 2nd, 2006
The number of records on a page can be restricted using the query explorer option in that specify the max no of rows to be retrieved
-
-
What are the basic differences between cognos 7.3 and 8v (specially in ReportNet)
pat.mclean
- Feb 12th, 2007
Just 1 addition guys !in ReportNet 1.1( Cognos7) you will have 2 create a union query by going to Query Explorer & then populate your data container based upon newly union-ed query.in Cognos8, using C...
jagannathan
- Nov 13th, 2006
Difference Between Cognos 7 series and Cognos Reportnet & Cognos 8:Cognos 7 series : 1. It is client- server architecture..2 . It contains some tools which used to build cube and Repor...
-
What is the difference between DW and BI?
eshwar
- Oct 24th, 2006
Hi joy,Thanks abt Ans
-
What are the steps of testing and how to test reports in Reportnet?
crn.shankar
- Mar 17th, 2008
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...
praveenj6
- Feb 4th, 2008
Testing of a reportas per the mark-ups we will test the reportmark-up means ,it is a sample layout.they will give how many prompts should be used,filters,conditionsthen we will insert all these in a report.this is called as unit testingfor system testing ask testing people
-
Can anybody tell me about star schema grouping
Mrutyunjay
- Oct 24th, 2007
Star Schema Groping Is a process of creating shortcut for you selected query subject,dimession masure? and relationship ?for easelly understanding between relation between your regural dimession and...
zecar
- Sep 18th, 2007
The biggest advantage of star schema groupings is that they make it easier for report authors to build valid reports by avoiding double-counting and misleading associations between dimension data occu...
-
Explain the reasons for this error " unable to find the database'goretailers'in the content store
zecar
- Apr 5th, 2007
Yeah thnx.. the datasource goretailers was missing.. i added the datasource in cognos
Hamid
- Feb 17th, 2007
because your data base is not restored and also goretailer package is not there in deployment folder. Or you have done deployment of your goretailer package properly into the cognos connection under administration folder. i think it will work. if not let me know. Hamid
Reportnet Interview Questions
Ans