In cognos reportnet Native SQL is used for the single datasource to import the meta data Cognos SQL used for multiple datasources to import the metadata Read More

In cognos reportnet Native SQL is used for the single datasource to import the meta data Cognos SQL used for multiple datasources to import the metadata Read More

The query studio is used to create adhoc reports, it is easy to understand the bussiness user.The report studio is mainly used to create proffessional and corporate reports, it is not like query studio it is having mainly 3 explorers those are page... Read More

procedure for providing security for query subject in frame work manager is: select querysubject -> in properties pane select ->security filters(click on edit)a specify data security wizard appears->click on add groups ->... Read More

Its a multidimensional view of dimension and measures. It is used to analyze the data in various aspects, which is called slicing and dicing Read More

Tabular model: It is the basic list query. It contain the data items, filters and child tabular objects. Tabular SQL: We can write and edit our own SQL Tabular ref: It is a shortcut to another tabular object somewhere in another query within... Read More

Prompts act as questions that help users to customize the information in a report to suit their own needs.The different types of Prompt are Value prompt Text Prompt Date prompt Time prompt Date and time prompt Using prompts is faster and... Read More

’Powerplay transformer’ is an ’MOLAP’ tool using which one can create multi dimensional structure called "CUBE". ’Powerplay for reports’ is used to generate report from the cube.Only one report can be generated... Read More

We can limit the maximum number of rows by setting the web page size option in the manage file tab in the report studio. Read More

Template extension is .imt Read More

We have a function called param Display Value. By using this function we can display the parameter value selected in prompt. Read More

The difference between Filter and Condition:Condition returns true or false Ex: if Country = ’India’ then ...Filter will return two types of results1.Detail information which is equal to where clause in SQL statement2.Summary information... Read More

You can follow this procedure ::: Lets assume revenue is the field in which we have to display null values as 0. First create a calculated item and Then write the expression of the cal item using If Then Else construct as If (Revenue is null)... Read More

Setting up drill-through access from PowerPlay Web to ReportNet involves 1. configuring Cognos Series 7 for drill-through access to ReportNet 2. preparing the Transformer model and cube 3. copying the search path of the folder that contains the... Read More

There is a lot of difference between Crystal reports an Cognos Report net. 1.Crystal report is a product of Business Objects where as Reportnet is of cognos. 2.Cryatal reports is for only low 2 midrange analysis and that to some even says tha... Read More

There may be a Feature film (movie) without a Trialer.But there will be no trialer without a movie.similarly Data warehousing is a concept related to extracting client’s business data and applying business processing features on that data... Read More

Query Studio: 1. Used to create Ad-hoc (or) simple reports. 2. It does not provide any pre-defined report templates. 3. It directly displays data (without running the report) when we insert attributes in the report. Report Studio: 1. Used to... Read More

Model is a representation of the metadata structures(imported from the soure datawarehouse).A model contains organized metadata objects(organizing depends on business needs).After the completion of a model(obviously in a framework manager environment... Read More

Actually the it is not possible to make reports without packages and packages can be build in FM. So no way one can skip FM and create reports.Adding to it,we need metadata (created in FM) to create relations among tables or views and also creating... Read More

Question : What are the advantages and disadvantages of reporting directly against the database? Do you always need to copy the data before reporting on it?(example, real-time & on-demand reporting is a requirement) Answers: ... Read More

If we wanna test the report in report net, first we can intially check by validating it in the report page. After that we can test the out put of the report Using a sql anlyser and sql query.so here we will be comparing the sql analyzer output... Read More

ReportNet has a three-tier architecture, namely, (1) Web server (2) Applications and (3) Data. The tiers are based on business function, and are typically separated by firewalls. ReportNet user interfaces sit above the tiers.ReportNet user... Read More

In ReprotNet have two vertions 1) ReportNet 1.0 2) ReportNet 1.1 MR1, MR2 Read More

’Powerplay transformer’ is an ’MOLAP’ tool using which one can create multi dimensional structure called "CUBE". ’Powerplay for reports’ is used to generate report from the cube.Only one report can be... Read More

Componenets of Report Studio: 1. Insertable Objects pane. 2. Properties pane. 3. Explorer bar - Conditional Explorer, Query Explorer, Page Explorer. 4. Report Viewer - Workarea, Report Layout Objects. Read More

U can in do it in this way. first creat a list report in which u have a calculated item in the starting. Then creat a prompt page with a value prompt.In value prompt creat static choice of which u want to be dynamically displayed. Let the parameter... Read More

One of the advantage’s of Reportnet, is 1. It is web-based reporting wherein, reports can be easily accessed from anywhere through a browser. Read More

Create 2 roles . One role can be given access to create reports in RS and the other role may be denied. Read More

Yes it can connect multiple datasources at a time when the frame work manager has the metta data regarding that datasources. Read More

You need to do the following for a standard installation process: (1) Verify your system requirements like RAM Minimum: 512 MB, a Web server installed and started (2) Review the ReportNet default settings like default ReportNet ports and URI settings... Read More

You can create the IQD file from framework manager. This IQD file will be used by Transformer to create the cube. Read More

It has six (6) formats in report net. They are HTML, PDF, Excel 2000, Excel 2002, CSV, and XML format. We can see the types of formats in the report viewer on the right side Read More

Prompts is mean by the end user can be filter the data. 1. u can open the explore bar and added the new prompts page, And enter the new name. 2. u go to tool menu and track prompts button 3. u select prompts and then ok Read More

Create a Query Subject, from the properties pane select externalise,there we have 4 options in that select IQD Read More