-
Repeater table
what is the repeater tableThanks,
srilug
- Apr 26th, 2008
Repeaters are tables in which you can insert items that are repeated when you run the report. For example, use repeaters to create mailing labels. To build a repeater, drop the items you want in the r...
-
Migrate reports to QA environment
How will you migrate your reports to QA environment?
Jaycognos
- Apr 8th, 2008
Through the content Administrator tool present in the cognos connection , we can deploy to QA environment.
-
Query Studio
What is the use of Query Studio?
How to use Query Studio? -
Fact less fact table
What is the fact less fact table? why we use this table?give me one example
chandrarekha
- Feb 13th, 2008
A fact table without measure is called a fact less fact table for negative analysis report we use this fact less fact table
praveenj6
- Feb 1st, 2008
If there are no facts(Measures) in a table then it is called as fact less fact table.
-
What are the different performance tuning techniques of a cognos cube?
Jaycognos
- Jan 30th, 2008
We can use 1.incremental updates,2.use multiple data sources or 3.partition your cube using auto-patition, the size of the cube but runtime performance will increase drastically.4.check power cube status and 5.perform test cube .Refer step by step transformer guide for more details.
-
What is the difference between a cascading report and drillthru report?why do we go for drill thru report?
Read Best Answer
Editorial / Best Answer
binay.bk- Member Since Jan-2008 | Jan 24th, 2008
Hi
Drill Through is used to link the master & detail reports.
After putting drill through if you click on a link (e.g. Order ID 1234) in the master report then the details will be displayed for that particular item (Order ID 1234).
Cascading prompt uses the value from the previous prompt to filter the value in the current prompt.
For Cascading no need of two reports.If a report having two related columns (e.g. Country & States),then we can cascade these two columns by adding two value prompts.
If you select a country (e.g INDIA),in the next prompt all the states will be displayed those which are under INDIA.
If you want to see the details for the state Tamilnadu,then select TN from the list which will display all the details for TN.binay.bk
- Jan 24th, 2008
HiDrill Through is used to link the master & detail reports.After putting drill through if you click on a link (e.g. Order ID 1234) in the master report then the details will be displayed for that...
subbu
- Nov 4th, 2007
Cascading report contains one report and it work based on the condition.drill through contains two reports parent report(summary),child report(detail report)child report contains a parameter that must accept the values passed from parent report.
-
Import two data sources to Framework Manager in Cognos
please explain me How to import two data sources into Framework Manager?Can anyone tell me what is role of reporter writer in Cognos?
binay.bk
- Jan 24th, 2008
We can import two data sources to Framework Manager in the Run Metadata Wizard.Go to Run Metadata Wizard-->Select another database ( e.g. suppose SQL Server is choosed in prior attempt, then u can choose Oracle as new datasource).Then import it.
cognos.reddy
- Jan 11th, 2008
yes you can import two datasources in frame work manager like thisfor example you are having databases like "oracle,sql server" ok1) first you can import any one of the database(Ex. first i ...
-
Performance tuning in model and report level
Hello,Can any body help me how to tune performance in cognos8 or reportnet to run report or create model.
cognos.reddy
- Jan 9th, 2008
In report level:1)you can reduce the calculation and condetions in the report 2) you can limit the cut copy phaste operations for user's3) you can limit access no of report's at peek time you ...
-
Static Choice
Could u explain briefly What is Static Choice?
ittoolboxcognos
- Jan 5th, 2008
Static Choice is set of choice you provide to user for selection. These choices are manually entered in the field. E.g for value prompt when you select Radio GUI then you give choices to your users by manually entering the choices by selecting Static Choice property and clicking add new.
-
What is level span? How it is used in Cognos? what is the main advantage of level span.
mail2alert
- Dec 13th, 2007
Level span is used to eliminate duplictes in data, in cognos it is used repeat grouped item.using levelspan we can see the grouped data group by group.For example, when country and city are both group...
venu
- Sep 16th, 2007
Level Span is used to eliminate duplicates in a report which contains columns with one-one relationships. Usually we use grouping to eliminate duplicates when there is one to many relation. But if there is one-one relationship and still there are duplicates, then we have to level span.
-
How to build a cube in Cognos 8 using Framework Manger?
ramesh4u
- Feb 4th, 2008
By using Framework Manager we can create IQD files ,By using IQD files we can creat cubes in powerplay
-
What different kinds of SQL you can write at the report level What is tabular SQL,Tabular Modal and Tabular Set
ranganadh
- Nov 23rd, 2007
1.Cognos SQLBy default, Framework Manager uses Cognos SQL to create and edit query subjects. Cognos SQL adheres to SQL99 rules and works with all relational and tabular data sources. Framework Manager...
Nageswara Rao Nandigam
- Nov 11th, 2007
There are two types of sql in Cognos Reportnet .They are Cognos Sql and Native SqlNative Sql used for single datasource to import the meta dataCognos Sql used for multiple data source to i...
-
Cognos Model
How to upgrade the model means How to add new Query items in the existed model ?
basecog
- Nov 22nd, 2007
Hi FriendCognos model is the metadata structure.For adding new query items we will fallow this steps1) select model you want add query item.2) Select the query subject you want add quer...
-
-
Can a cognos package be created at run time using C# and Cognos SDK?
revitala
- Oct 21st, 2007
Yes. I'm using the BmtScriptPlayer to do that; my program is creating the package script during runtime (I'm taking the information I need from XML files), open a process (using RunT...
-
How do you handle this DB Schema changes in our Framework manager to update automatically our meta data
I have created meta data model using Cognos FM and later source data base column were changed but DBA was not informed the changes. How to handle this DB Schema changes in our Framework manager to update automatically our meta data.
the_xxx
- Oct 16th, 2007
In Framework Manager (CRN), right click on the query subject and select Update Query Subject. In Framework Manager (Cognos 8), click on the query subject(s). Select Tools > Update Object. If you ha...
-
What is model and say about process how to create model and how to test model
vipvats
- Oct 13th, 2007
Model is a way to represent the architechtural structure of the Data warehouse. It consists of dimensions, Data sources, Measures. To create a model following steps should be followed 1. From the File...
Anindita Ghosh
- Apr 5th, 2006
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...
-
Define Dimensions, measures, Regular dimensions and Measure Dimensions
silu.davidson
- Oct 10th, 2007
Dimension: is a broad group of description, grouped together to describe a key area of a business. e.g., Product dim, Customer Dim which holds all details 'bout pdt n customer respectively ......M...
-
How do you utilize Java Script within Cognos?
guru
- Jul 23rd, 2007
We can add JavaScript with the help of HTML item.
-
How do you speed up the report execution even though it has lot of charts.
na__dim
- Sep 25th, 2007
One possibility would be to review the data available and use prompts if possible. This way, you could limit the amount of data being retrieved and thus allow for a faster response time.
Cognos Interview Questions
Read Best Answer
Ans