Frequently Asked Questions:
1) What are the different types of catalogs and best among all catalogs?
A catalog is a file containing the information (Database tables) of the reports that INPROMPTU users have to create .A metadata layer in COGNOS is called catalog. there are 4 catalogs:
2)What is a Junk Dimension?
A junk dimension is a dimension with a collection of different mixture of different attributes. In other words, It is a structure that provides a convenient place to store the junk attributes. Since it is a combination of all those attributes that doesn't belong to any other dimension, it does not affect the grain of level.
3)What is meant by ad hoc reporting ? Explain it and its usage?
Adhoc reports are the reports that can be run simultaneously while creating the report itself. Adhoc repots are also know as fly reports or Self service Report. These reports are very useful because of the basic flexibility of its nature. One can see the affect on the output immediately after the changes done to the report. These reports are created by using Query studio, a studio to create dynamic reports.
4)What is Scheduling of the reports and How to schedule reports in cognos?
By using Cognos Schedular, one can schedule the running reports in Impromptu to execute and save it in desired format. And also, you can distribute the reports by using the cognos macro script language. Compiled Cognos MACROs can be scheduled using Cognos Scheduler.
5)How to test reports in cagonos?
In cognos report net or cognos8 one can verify if any error by using the VALIDATE option available. If it is valid, the message "The report Specification is valid" will pop up. If nothing is shown up, that means the report is invalid.
6)How to create users and permissions in cognos?
In impromptu menu,
1. Click on Catalog->User profiles.
2.Now go to userclass tab and select Creator option .
Here you can access and assign folder access, table access etc. you can see folder access,table access,filters,Governor etc options.
7)What are the basic problems that are faced in during report runnig time?
The most common problems are
1. Report has No data. (Can be fixed by properly assigning the corresponding data source or package)
2. Report has incorrect data. It may be due to the limited data.
3. Filters in report are not shown which leads to unfiltered data.
4. Excel, CSV, XML formats of reports doesn't work.
8)What is a model and how to create and test a model?
Definition of Model:
Model in PowerPlay Transformer is combination of five windows-
1.Dimension Map
2.Data Source
3.Measures
4.Power cube
5.Sign On.
Models are the specifications of the data sources with definitions of correspoding dimensions, levels,and measures. They also have userclasses,dimension views, userclass views and other authentication-related information.
The model file contains the information related to model. It comes in 2 different formats .mdl or .pyi which means text,platform independent or binary, means platform depentent respectively.
Steps To Create A Model in Transformer:
1.Open the New Model by selecting the New Model option in the File menu.
2.Now, name the model by typing the name of your choice in the name box.
3.Check the option “Include security in this Model” for controlling the data access using user class authentication.
4. Now, go to Next and enter the name of you desired data source in the Data Scource Name field.
5.Select a desired source type. Depending on which, Transformer asks for the parameters that correspond to your data source. Enter them.
6.By selecting the Run AutoDesign option, Transofrmer create a preliminary structure.
Note: If you want to select own design you can leave this box unchecked.
7.Now click Finish to complete the process.
Now the New model that is created will be opened with the information about source data specified by you.To test model, go to tools menu and select the CHECK MODEL option.
What are meant by Cognos Visualizer and Cognos Script Editor?
In Cognos Visualizer, Data cubes are represented in a dashboard format. One can drill through all the depth of the hierarchy but cannot add or remove fields dynamically.
In Cognos Script Editor, one can create macros or programs or do some performance tuning. These process are known as Cognos Scripting.
What is the difference between group and association?
Grouping is used to uniquely display of values where as association is used along with group on a certain item, to display unique values in the same grouping on the query it is applied.
Consider the following example to display the difference between grouping and association.
ProctLine ProductType Quantity Revenue
------------ ------------------- ---------------- --------------
Drinks softDrinks 299 50000
399 22000
199 33000
Beverages 999 50000
Fruits Citrus Fruits 777 3333
555 1111
Other 567 1234
Here, Product Line is Grouping and Product type is Association.
How can you import data into catalog? what are the ways?
We can import data into catalog using 2 ways-
When You Import data into catalog You have complex columns names. How do you change the Name of those columns?
Go to Impromtu Admin.
Now click on Catalog-> Folders option.
Now click on the column you would like to alter and select edit.
How to create measures and Dimensions?
Measures or Dimensions are created by selecting the required once and dragging them into the repective places in the report. For example, you can drag and drop any quantifiable value as measure into the measure place of a crosstab report or chart reports that is clearly mentioned.
What are Drill-Down and Slicing and Dicing? What is the difference between two methods?.
Drill-Down, Drill-UP, Drill-through are the different terms used to drill through any report up or down. This type of drilling is just to explore the data and the data you look will be same as it is preset. Where as Slicing and Dicing is also a type of drilling down or up but in this case, you can keep cutting and removing and adding the part of the report you want to remove or add at any level.
what is the extension used to save a template?
To create a template one can use ".imt".
What are the differences between Reporter report and Explorer report?
In a Cube, you can either modify or explore. Reporter is used to modify where as explorer is used to explore the cube.
A catalog is a file containing the information (Database tables) of the reports that INPROMPTU users have to create .A metadata layer in COGNOS is called catalog. there are 4 catalogs:
- secured
- personal
- shared
- distributed
Out of the above 4 catalogs, Shared catalog and Distributed catalogs are the best catalogs. The reason behind distributed catalog is that it has all the functions in it.
2)What is a Junk Dimension?
A junk dimension is a dimension with a collection of different mixture of different attributes. In other words, It is a structure that provides a convenient place to store the junk attributes. Since it is a combination of all those attributes that doesn't belong to any other dimension, it does not affect the grain of level.
3)What is meant by ad hoc reporting ? Explain it and its usage?
Adhoc reports are the reports that can be run simultaneously while creating the report itself. Adhoc repots are also know as fly reports or Self service Report. These reports are very useful because of the basic flexibility of its nature. One can see the affect on the output immediately after the changes done to the report. These reports are created by using Query studio, a studio to create dynamic reports.
4)What is Scheduling of the reports and How to schedule reports in cognos?
By using Cognos Schedular, one can schedule the running reports in Impromptu to execute and save it in desired format. And also, you can distribute the reports by using the cognos macro script language. Compiled Cognos MACROs can be scheduled using Cognos Scheduler.
5)How to test reports in cagonos?
In cognos report net or cognos8 one can verify if any error by using the VALIDATE option available. If it is valid, the message "The report Specification is valid" will pop up. If nothing is shown up, that means the report is invalid.
6)How to create users and permissions in cognos?
In impromptu menu,
1. Click on Catalog->User profiles.
2.Now go to userclass tab and select Creator option .
Here you can access and assign folder access, table access etc. you can see folder access,table access,filters,Governor etc options.
7)What are the basic problems that are faced in during report runnig time?
The most common problems are
1. Report has No data. (Can be fixed by properly assigning the corresponding data source or package)
2. Report has incorrect data. It may be due to the limited data.
3. Filters in report are not shown which leads to unfiltered data.
4. Excel, CSV, XML formats of reports doesn't work.
8)What is a model and how to create and test a model?
Definition of Model:
Model in PowerPlay Transformer is combination of five windows-
1.Dimension Map
2.Data Source
3.Measures
4.Power cube
5.Sign On.
Models are the specifications of the data sources with definitions of correspoding dimensions, levels,and measures. They also have userclasses,dimension views, userclass views and other authentication-related information.
The model file contains the information related to model. It comes in 2 different formats .mdl or .pyi which means text,platform independent or binary, means platform depentent respectively.
Steps To Create A Model in Transformer:
1.Open the New Model by selecting the New Model option in the File menu.
2.Now, name the model by typing the name of your choice in the name box.
3.Check the option “Include security in this Model” for controlling the data access using user class authentication.
4. Now, go to Next and enter the name of you desired data source in the Data Scource Name field.
5.Select a desired source type. Depending on which, Transformer asks for the parameters that correspond to your data source. Enter them.
6.By selecting the Run AutoDesign option, Transofrmer create a preliminary structure.
Note: If you want to select own design you can leave this box unchecked.
7.Now click Finish to complete the process.
Now the New model that is created will be opened with the information about source data specified by you.To test model, go to tools menu and select the CHECK MODEL option.
What are meant by Cognos Visualizer and Cognos Script Editor?
In Cognos Visualizer, Data cubes are represented in a dashboard format. One can drill through all the depth of the hierarchy but cannot add or remove fields dynamically.
In Cognos Script Editor, one can create macros or programs or do some performance tuning. These process are known as Cognos Scripting.
What is the difference between group and association?
Grouping is used to uniquely display of values where as association is used along with group on a certain item, to display unique values in the same grouping on the query it is applied.
Consider the following example to display the difference between grouping and association.
ProctLine ProductType Quantity Revenue
------------ ------------------- ---------------- --------------
Drinks softDrinks 299 50000
399 22000
199 33000
Beverages 999 50000
Fruits Citrus Fruits 777 3333
555 1111
Other 567 1234
Here, Product Line is Grouping and Product type is Association.
How can you import data into catalog? what are the ways?
We can import data into catalog using 2 ways-
- Database option
- hotfile option
When You Import data into catalog You have complex columns names. How do you change the Name of those columns?
Go to Impromtu Admin.
Now click on Catalog-> Folders option.
Now click on the column you would like to alter and select edit.
How to create measures and Dimensions?
Measures or Dimensions are created by selecting the required once and dragging them into the repective places in the report. For example, you can drag and drop any quantifiable value as measure into the measure place of a crosstab report or chart reports that is clearly mentioned.
What are Drill-Down and Slicing and Dicing? What is the difference between two methods?.
what is the extension used to save a template?
What are the differences between Reporter report and Explorer report?
In a Cube, you can either modify or explore. Reporter is used to modify where as explorer is used to explore the cube.
Posts
0 comments:
Post a Comment