-
Report Page Breaks
How page breaks work in the report?
sreenu007
- Jun 3rd, 2010
In Cognos8 version we have one option directly.see for eg if you break on country page breaks, first select that column and select structure tab, in that we have one option call 'page break'. select t...
-
1.diff between drill down and drill through?2. what is meant by roll-up?3.what is meant by external roll-up?how to create external rollup with example?4.what is meant by clean house command?5.what is meant by scope?what are types?explain them6.what is meant by cube groups?how to create cube groups?there is any simplest way to create cube groups?7.what is meant by alternate drill down with ex?8.how many cubes you are created till now?9.what is the size of the present cube?10.why you choose Ex-files and flatfiles instead of iqd?11.what is meant by partition?How To create?12.how to create time state Partition13.model contain ____________? cube contai___________?14.what is distinct measure?
Shwethadeepu
- Apr 13th, 2010
Answer to Qn. 4. Cleanhouse command removes all the categories generated during the cube build.
ravimantur
- Jun 5th, 2009
Drill down is like in time dimension from year to qtr to month to week etc., In drill through you cannot only drill down in a single dimension but you can go to the next dimension as well.EG take 3 di...
-
Master Details Advantage
What is advantange and disadvantage of Master Detail report?
-
How to pass multiple values from picklist prompt to sub report filter
The sub-report only includes the first value."When the sub-report query runs, it checks for the first row in the Customer Name column and shows only information for that customer. If you want a sub-report to show information for another row in the column, place the main report in a form frame that shows only one row at a time. When you insert the sub-report into the form frame as well, it changes as...
cognos.kishore
- Feb 5th, 2010
Create 2 reports in do this actions in 2nd report(detailed Report)Create 1 prompt here 'Ex value prompt on Customer name 'Create one filter on date field 'like IS_CURRENT=?P_IS_CURRENT...
-
Cognos List report
How many rows can you add above a selected row in a list report
friswana
- Jan 6th, 2010
Answer is infinite.. But its better to restrict the number of rows based on the requirement to avoid performance issues..
sivabisani
- Nov 13th, 2008
I tried with this query we set rows upto 10000 and?infinet also.(it is casuing perfomance issue more than? 1000).Thankssiva
-
Run the Report
How can we run the Report without using "Run Report" option in Cognos
-
How can create users and permissions in cognos
vpulender
- Nov 27th, 2009
In Cognos Connections we can only able to create Groups,roles and contacts.But if we want to create new users we have to log on Cognos Access Manager there we can create users andWe can grant the permission based on their requets like for specific Folder or reports..
swift_s
- Jun 11th, 2009
Users and Permissions can be given in Access manager - Administration. Individual users can be created using their names or their Ids (if any) in Access manager and then be given permissions. This tool is loaded when you install Cognos 7.x in your machine.
-
Row Level Security
How will you provide security?How will you provide row level security?
liladd
- Oct 5th, 2009
You can use session parameters to map a data item to one of the ldap user values.depending on what you authentication source is and if the necessary values are there. EX: Your ldap has employee #, you...
-
Automated Report Fetch
A List report which has Company name as report item along with many other report items. When the above list report is run-The report output also pulls another report called "company details" automatically.Report developed has no idea about the "Company Details" report until he sees the report output.When ever we run any report that has company name as a report item, "company details" report should...
port.poo
- Sep 25th, 2009
Create an HTML Item in Main Report. When first report get exceuted then HTML Script should call another report which will conatin Company Details.Hope it helps!!Cheers,Julie
arjun vuppala
- Aug 28th, 2009
A List report which has Company name as report item along with many other report items.?When the above list report is run-The report output also pulls another report called "company details" automati...
-
Reportnet report studio & cognos8 report studio
What are the differences between cognos reportnet 1.1 report studio and cognos 8 report studio?
kadarla
- Aug 17th, 2009
These are the differences between Cognos Reportnet report studio and Cognos 8 report studio: 1. In Cognos 8 we can use dimensional data for reporting.2. We can drill through from chart also in Cog...
elizabethzen
- Apr 20th, 2009
Cognos 8 Report Studio is the reporting tool for ReportNet, the Web-based reporting solution.
-
What is the difference between model and a package in framework manager?
arun.menon
- Aug 11th, 2009
A model is an set of metadata objects organized for report authors according to the business models and rules. It is an business presentation of the structure of data from one or more data sources.A package is an subset of query subjects and other metadata objects defined in the project.
ASHOK1324
- Apr 23rd, 2009
A project is a set of files that define metadata in one or more models.A model irepresents data source info an contains the info for business requirements and performance enhancements.Frame Work Manag...
-
What is Cognos Powerhouse and what is it used for?
swift_s
- Aug 5th, 2009
Cognos PowerHouse (4GL, Web, Axiant) is an Application Development tool. It was Cognos' main bread&butter product prior to BI tools becoming so popular. It's hayday was in the 1990's as it was...
Andrei Mitiaev
- May 26th, 2006
Cognos Powerhouse is High-Productivity Application Development Solutions equips you with high-productivity development environments for creating your data-driven business solutions faster,whether for ...
-
How you drill from powerPLay to Impromptu?Explain all Steps.
swift_s
- Aug 5th, 2009
The following document will walk through all steps needed in setting up drill through from PPES to IWR.Create 3 Folders in Windows Explorer1. On C: create a folder called C:DT2. In C:DT create another...
panini
- Apr 16th, 2006
goto tranformer,build the cuberight click on the cube and open propertiesgo to drill through tab and select your report from that browse option
-
What is drill down and slicing and dicing whats the difference between them.
sarvan_sarvan2007
- Jul 29th, 2009
Slicing is a process in which you do an equality selection of data from one or more dimension(perspective of facts how it can be interpreted).In dicing, you obtain a dataset in a range of selection.
vipvats
- Oct 13th, 2007
Drilling down the data means to change the resolution of the dimesion we are looking for. Once the resolution or level of the dimesion drops down we have more information from a part of a dimension. f...
-
Cognos Framework Manager Model
How would you set up a Cognos Framework Manager model in from an SAP BEx query?
-
How to migrate from Impromptu Report and PowerPlay Cubes (Version 7.x) to Cognos 8?How to migrate from RN Report 1.0, 1.1 MR1/MR2 to Cognos 8?
How are the steps/procedures to do so? What tools in market can do that job?
jayasree.atmakuru
- Jul 23rd, 2009
Follow the steps below to publish and access Series 7 PowerPlay cubes.Create Data Source in Cognos Connection1. From Cognos Connection click Tools and then Directory.2. Select the Data Sources tab and...
-
Cognos Report Studio Chart
How to create Chart in Report Studio Cognos?
-
Cognos 8 Report Studio Bookmarks
What is the procedure to create bookmarks to a report in Cognos 8 Report Studio?
kiran_tsa
- Jul 22nd, 2009
Create a report with two lists. Insert a single Data Item (Product Name) in list one. Right click the Data Item (Product Name) in the list and go to Drill Through. Add a new Drill Through, and choo...
-
Level Span
What is difference between Level Span And Group Span
kiran_tsa
- Jul 22nd, 2009
Level span is there in Report Net 1.1 and Group span is there from in 8.x. Both will work same if you want to repeat a grouped item with respect to change the nested data item under it. But, rather th...
freaky_priscilla
- Jul 21st, 2009
As far as I know, level span was in Cognos 1.1 and Cognos 8 had Group Span. I thought they had the same functionality, and it was just renamed for whatever reason. ?Please correct me if i am wrong!
-
What is the usage of html object in tools box?
kiran_tsa
- Jul 22nd, 2009
By using HTML objects we can fulfill some requirement which is not possible directly by Cognos in built components. Example: If you want to know the report running time, Its not possible directly w...
ranganadh
- Mar 2nd, 2007
By using HTML object, We can insert multimedia file into report. At the run time we can see the file.Ranganadh,Bangalore.
Cognos Interview Questions
Ans