-
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...
-
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 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.
-
Repeater Object
What is the usage and procedure to create a repeater object?
freaky_priscilla
- Jul 21st, 2009
Repeater Object is used to repeat data in a particular order. Its mainly used for mailing lists. for example, say you want the Name, Address and telephone, one below the other in a 3X3 table. You...
-
Drill through
By using one Drill through can we explore the four reports at a time ?
bvsr007
- Jul 17th, 2009
1) Create Drill through report to link two reports contain related information 2) You can access related and more detailed information in one report by using to select a value in another report. ...
angel987
- Sep 2nd, 2008
Its possible for eg: you click on any list column body and click on drill through.Over there you can add multiple new drill throughs and each drill through can open a new report. So when you run ...
-
Conditional Formatting
What is Conditional Formatting? What you used finally in the Condtional formatting?
bvsr007
- Jul 17th, 2009
You can define the condition to control, what the user see when they run the report.By three ways we are doing the conditional formatting1) Boolean variable2) String Variable3) Report Language Variabl...
bkamila
- Oct 24th, 2008
Enhance a report by adding conditional formatting. For example, use conditional formatting to identify exceptional data in a report.
With conditional formatting, you can
hide and show objects
highlight data
add multiple layouts
create a multilingual report -
Convert Crystal Reports into ReportNet or Cognos 8
How to convert Crystal Reports into Cognos Reports?
IBMCognosPartner
- Jun 22nd, 2009
If you are looking for a simple answer, there aren't any!? The two products are dramatically different with few common features and functionalities. Ive completed several of these conversions and ...
-
Scheduling
By using Date Prompt . can we schedule the report ?
ps77322
- Jun 16th, 2009
Yes we can schedule a report to run on specified date and time. We can even get the output as in email.
-
What is refreshing of a cube and how can we do it
ravimantur
- Jun 12th, 2009
Refreshing the cube fetches the latest data to the cube. Which can be used to extract the latest reports out of it. Inorder to refresh the cube right click on the cube in powerplay transformer you will get an option refresh cube click on it and its done.
chinnuchaitu
- Feb 13th, 2007
Refreshing the cube means it just gets the latest data and there is a option Refresh to do so.
-
What is meant by Junk Dimension?
swift_s
- Jun 11th, 2009
A "junk" dimension is a collection of random transactional codes, flags and/or text attributes that are unrelated to any particular dimension. The junk dimension is simply a structure that p...
-
Cognos Filters
List out the types of Filters in Cognos 8 and give the usage?
roopacrn
- Jun 2nd, 2009
In Report Studio, we have Detail filters and Summary filters.In Framework Manager, we have Embedded filters and Stand alone filters.
blm.swapna
- Mar 16th, 2009
Cognos filters are 2 types.1. Summary filter: Aggregated summation on total column2. Detail filter: Aggregated measureable item in row wise.
-
Restricting the values for a prompt
How can you restrict the number of values available for a prompt?
-
How to create Cube from Power play transformer by using SQL Server Database(with out creating IQD file using Cognos Impromptu from SQL Server)
nilesh_tiwari
- May 28th, 2009
From the 8.3 version of Cognos you can use even a more wider variety of datasources than you could use previuoslyYou can just publish a package from Framework manager and use it as a source for creating cubes, no need of creating an IQDYou can also use any Cognos 8 Report as a source.
the_xxx
- Oct 16th, 2007
Power Play transformer supports wide range of Local Data Sources, you cannot connect to SQL Server Directly without creating IQD's. Below is he list of data sources which you can use as Data...
Cognos Interview Questions
Ans