Question : What is meant by Junk Dimension? How do you perform while running the report? Where will you see the time of running report? Size of the cube? What are the types of prompts in ReportNet? What is macro and how it... Read More

Drill across means when you are moving from one report to another report like country in one report and States in another Report whereas if the report is using same report from moving from country to state. In other when you are moving details level... Read More

Question : 1.what is difference between PAGE BREAK and Section Report? 2.what is Main Advantage Datawarehousing over Oracle? Answers: Section-section is eliminate the duplicate recod.but report looking separate bluck. ... Read More

Power Play Transformer contain dimension,measure,model and cube. we can generate cube different way. 1. Just right click on cube name and build 2. we can write script in unix. using that we can generate cube. Other way also is there. Read More

I dont know the starting release but can be version 5, latest version is 8.3 then reportNet 1.1. EP7 series is the oldest cognos series, cognos report net is the next series, cognos 8.1, cognos 8.3 is the latest version,... Read More

Cascading report works based on the condition but drill thru work based on the data item what we select as a drill thru options Read More

Ans of Quest. 7 - Alternate drill down path means there will be two path to opt.For example- We will have time dimension now the client requirement is they want two type of year -one is claender year(Jan-Dec) and another is fiscal year(Apr-Mar). Read More

A catalog is a file containing the information (Database tables) that Impromptu users need to create reports. ? personal ? distributed ? shared ? secured shared catalog is better Read More

The most common problems are - 1.No Data Appears in the Report (to remove this check data source or package) 2.Unexpected or incorrect values appears in reports , may be report is running with limited data 3.The report filter does not work, values... Read More

You can create measure once you import all the data into the data source.You can create measures and dimensions by draging the required source from datasource into dimension map and measure tab.(need to find scope of measures for all the dimensions) Read More

Group: used to eliminate duplicate values in the report. Association: used with grouped item that displays data only when the values are changed. ProctLine ProductName Quantity Revenue ------------------------------------... Read More

Work with Source Data Transformer supports a wide range of local data sources, including ? Impromptu query definition files (.iqd), which can query local or server-based databases ? delimited ASCII files (.asc) and comma-separated variable files... Read More

In cognos report net by the validate report option a report can be tested. If there will be any error, it will specify the the error, unless it will give message -’report specification is valid’. Read More

Macro-A macro is a set of instructions that can run applications.Example : A macro can open your catalog,select a report(say for instance) convert that to another format and export it to any specified location,provided the code (Program)is such... Read More

The Cognos Portfolio is ideal for presenting and packaging Impromptu reports, and for combining them with information from documents produced by other products.As an application developer, you can create briefing books that contain links to... Read More

Add a list footer and a text messsage inside "No Data". create a booloean conditional variable "Test" with code "rownum()>0". Select the complete list footer and set Style Variable, if Yes, Box Type of the List footer should be set to "none". This... Read More

"The junk dimension is simply a structure that provides a convenient place to store the junk attributes" Read More

Question : I have one query?. How to create cascade prompt in cognos impromptu. If u know please send : step by step information. I referred cognos impromptu material i m not understand. Answers: No answer available... Read More

Question : How u can connect different database in reportnet? wht is the extension file to save a template? give example for drillthrough and masterdetail reports in CRM domain? Answers: Template?extension is .imt Read More

Semi-Additive: Semi-additive facts are facts that can be summed up for some of the dimensions in the fact table, but not the others. Non-Additive: Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact... Read More

Question : In my report contain Product name, Amount, Country, Sales person. I want to create one prompt: Sales Territory.( Ex: asia, US, UK, AUS), but territory column is not there in my model and source. if u select the Asia in prompt page... Read More

Transformer is used for building the Cubes (Multidimensional Structure used for OLAP processing). Read More

Model Definition Model in PowerPlay Transformer is combiantion of five windows- Dimension Map,Data Source, Measures,Power cube,Sign On. Models specify the data sources and then defining the dimensions, levels,and measures.They may also contain... Read More

Question : use this query i am retriving all years OCt data from 01-10-2004 to 30-10-2007 i need to restrect this query to current date and current year [gosales_goretailers].[Orders].[Order month]between 01 and to_number(to_char... Read More

goto tranformer, build the cube right click on the cube and open properties go to drill through tab and select your report from that browse option Read More

Big Organizations have a lot of diversified sources of data.There might be a dataware house exclusively for transport and others for data related to the project the company runs.In such case the complete enterprise’s(company’s) date ware... Read More

As you said .Select Properties, and then click the Headers/Footers tab. I didnt find the option Headers/Footers tab. Which version you are talking about ?? Read More

cubes are created using transformer.cubes can be viewed using powerplay.cubes has impromptu query definition (IQD) files as their sources.IQD files are generated from cognos impromptu.IQD files contain ,how the data has to be retrieved through ... Read More

Loop: loop is a closed path (relation) that exists among 3 (or) more tables. For example, if we have ’3’ tables T1, T2, T3 then, a loop exists among these tables only when we create joins in the following fashion: Loop: ... Read More

1. Create a new namespace.<give it a name, say, IQDReportNet> 2. Create a new query subject inside IQDReportNet. 3.In the query subject definition window, pull in all the data you need. 4. after creating, click on the new query subject,... Read More

No answer available currently. Be the first one to reply to this question by submitting your answer from the form below. Read More

Visualizer is a representation of data cubes in a dashboard format. We can drill through to the ground level of a hierarchy as like in power play report but cannot add or remove fields dynamically. Cognos script editor : We can write cognos macros... Read More

To create a powerplay report 1)You have to create a IQD file from impromptu by saving IMR report as IQD 2)Use Frame Work manager model and externalise the query subject you want to use in powerplay transformer and powerplay When you have the IQD... Read More

Cognos offers Portal Services that allow organizations to easily manage and display Cognos business intelligence, planning, and scorecarding in your existing enterprise information portals. Including Cognos reports, analysis, dashboards, scorecards,... Read More

A Snapshot is the copy of data, when we create a snapshot it copies the exact data that’s related to the at perticular report, we use snapshot when ever we want to compare reports(ex we want to compare this months report with previous months) Read More

Drilling lets you quickly move from one level of detail to another to explore different aspects of your business. Drilling down moves you down in the hierarchy; drilling up moves you up in the hierarchy. Slicing and Dicing While you can drill to... Read More

ADVANTAGES: 1)PURELY WEB BASED REPORTING TOOL 2)WE CAN CREATE MULTILINGUAL REPORTS 3)IT CAN SUPPORT ANY TYPE OF OPERATING SYSTEM & DATA BASE 4)WE CAN CREATE SINGLE MODEL IN FRAMEWORK MANAGER COMING FROM MULTIPLE DATA SOURCES ... Read More

In impromptu menu go to Catlog->User profiles -> userclass tab -> click on Creator ->u can give there folder access,table access,filters,Governor etc Read More

By using Cognos Schedular, one can schedule the running reports in Impromptu to execute and save it in desired format. By using Cognos MACRO script language the reports can be executed and distributed to recipients by using mail applications. ... Read More

An Explorer report is used to explore the contents of the cube.,The multidimensional structure.A Reporter report is used to add/ modify the contents of the cube. Read More

Steps1. Right-click in the Data Sources list of your model and select Insert Data Source.2. In the New Data Source wizard, enter the name of the data source in the Data Source Name box.3. In the Source Type box, select the type of data source that... Read More

PowerplayFrom format menu-->title, header & footer-->title-->insert report filename Read More

Macro-A macro is a set of instructions that can run applications.Example : A macro can open your catalog,select a report(say for instance) convert that to another format and export it to any specified location,provided the code (Program)is such... Read More

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 Web-based, client/server, or traditional terminal... Read More

Before creating any report in report net make sure you are have the planning information you need. Creating a report involves following steps: Specifying a package Choose a package through cognos connection>report studio>Select a module from... Read More

1 Start Cognos Impromptu Administrator. 2.From the File menu select Catalog -> New. 3. In the File name text box, type the desired name of the catalog. In the Description text box you can add a description but this is not mandatory. 4. In the ... Read More

Open Impromtu AdmiSelect Catalog->Folders optionSelect the column u want to chance and Click the Edit button Read More

one through Database optionother one though hotfile option Read More

Cognos 6.6 7.0,7.3(PowerPlay, Impromptu)--ReportNet1.0,1.1mr1, 1.1mr22---ReportNet 8.0(latest)IWR is use by Impromptu to publish reports, PPES is used by PP, Cognos Connection is used by repornet. there are many other tools but these are the main. Read More