-
How can create users and permissions in cognos
vpulender
- Nov 27th, 2009
In Cognos Connections we can only able to create Groups,roles and contacts.But if we want to create new users we have to log on Cognos Access Manager there we can create users andWe can grant the permission based on their requets like for specific Folder or reports..
swift_s
- Jun 11th, 2009
Users and Permissions can be given in Access manager - Administration. Individual users can be created using their names or their Ids (if any) in Access manager and then be given permissions. This tool is loaded when you install Cognos 7.x in your machine.
-
How to join multiple db in catalog
rkiranbedi
- Apr 13th, 2007
Hi Using Hot Files u can join Hot Files in Catalog
Hamid
- Feb 15th, 2007
Basically catalog deals with single data base, we cannot use multiple data base and that is the disadvantage of catalog, but we can use Hot files to bring another data base source. one more thing by ...
-
What is the difference between list and crosstab?
bhaskar jha
- Nov 8th, 2014
List report show the data in row and column(detail information of report).
crosstab report show the data in grids, dimensions in row and column and measures in cells or in intersection point.jjrkl_sandeep
- Oct 22nd, 2013
List can be converted to Cross tab but Cross tab cant be converted to list...There is no direct option available in Report Studio to convert the cross tab to list....
-
How to show the data reported horizontally:(For example:)employee skill1 a1 b1 c2 d2 e2 fReport result:1 abc2 def
Assuming 3 records per grouped item:1. Group on employee2. Create a running count based on the skill field.3. Create 3 calculated columns based on the count field.Call them skill1, skill2, skill3:if (count = 1) then (skill) else nullif (count = 2) then (skill) else nullif (count = 3) then (skill) else null4. Create 3 more calculated columns using the maximum function. Call them maxskill1, maxskill2,...
cognos10consultant
- Feb 25th, 2012
To achieve this you have to create list first ...from the source tab add employee..after that click on toolbox tab add repeater as 2nd column...from the source tab add skill to the repeater...then we ...
prabakar.bi
- Mar 31st, 2009
I feel we can use the tool functionality to achieve this as follows.1. Create a list report having employee column2. Create a cross tab - contains emp in row and skill in column3. Provide Master Detai...
-
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.
-
What is the difference between group and associate?
sreenu007
- Jun 5th, 2010
GROUP is used to suppress the duplicate values having one to many relations.Associate is used to suppress the values having one to one relations.
rkiranbedi
- Mar 27th, 2007
group is used to eliniminate Duplicates,Where as Association is used to make one to one relation ship between to columns.ProctLine ProductName &nbs...
-
1.diff between drill down and drill through?2. what is meant by roll-up?3.what is meant by external roll-up?how to create external rollup with example?4.what is meant by clean house command?5.what is meant by scope?what are types?explain them6.what is meant by cube groups?how to create cube groups?there is any simplest way to create cube groups?7.what is meant by alternate drill down with ex?8.how many cubes you are created till now?9.what is the size of the present cube?10.why you choose Ex-files and flatfiles instead of iqd?11.what is meant by partition?How To create?12.how to create time state Partition13.model contain ____________? cube contai___________?14.what is distinct measure?
Shwethadeepu
- Apr 13th, 2010
Answer to Qn. 4. Cleanhouse command removes all the categories generated during the cube build.
ravimantur
- Jun 5th, 2009
Drill down is like in time dimension from year to qtr to month to week etc., In drill through you cannot only drill down in a single dimension but you can go to the next dimension as well.EG take 3 di...
-
1.How will u implement drill-thru from powerplay to impromptu?2.How will u highlighting the data other than conditional formatting?3.What is 4-4-5 weeks in powerplay?Why r u using this?4.Why r u using multiple data source?and why cant u use single data source?5.How will u improve the performance of the cube?6.How will u relate the sources in transformer?7.Have u faced any errors while generating the models?8.What is uniqueness error?9.What is the use of Unique property?10.Why there is a property called move?what is its use?11.If u right-click one level u can see the properties?In that one drill thru property is there in source tab?What is the use of this?12.What is use of before rollup and after rollup?
ripirr
- Oct 10th, 2008
Try to limit the data in the iqds to the bare minimum, i.e., only fetch the data that is essentially required in your report via the iqds and check the 'auto-partition and passes' on the cubes...
ripirr
- Oct 10th, 2008
Why do we use multiple data sources?Ans - It is a good practise to separate the FACT and Dimension IQDs, the dimension iqds execute quickly while the FACT iqd takes longer time to generate data/popula...
-
How to configure content store in Cognos?
my OS is windows XP Prof , back-end oracle 9i , i tried to install cognos repertnet8.2 , but couldn't able to start the service..content store is not configured correctly. what are the steps to configure it and how to create a new database for content store?thanks
phamminhtruong
- Jan 14th, 2009
Hi sreedil,??? I am also newbie of Cognos. Your problem is caused of Oracle JDBC driver loading. So you copy classes12.jar (>= 10g) or classess12.zip (
sreedil
- Nov 12th, 2008
Go to Cognos Configurationlook for Content ManagerDelete the default COntent Store For SQL ServerRight Click Content manager and create a new content storeGive data base name as OracleGive the user id...
-
What are complex reports?
Hello,what are complex reports and normally what issues do we face while creating complex reports in report studio?Please help me soon on this question.
arunkiranrega
- Aug 11th, 2008
Another report was likeIt had 5 to 6 joinsIn impromptu we have hotfiles and picklistsWhereas in c8 we dont have hotfiles so we need to create a separate query for the items coming from the hotfiles an...
arunkiranrega
- Aug 11th, 2008
My project migrates reports from impromptu to c8One of the complex reports has 128? items, 28 queries and it has?very lengthy calculated data items. Conditional formatting was appliedLayout is not a...
-
Framework Manager
What is usage property? Where do we set usage property? What is usage property for fact and dimension tables. What are the properties of usage property?
sreenu007
- Oct 18th, 2010
Usage property means it identifies the intended use? for each reprasentation of the query items. Its different types are Identifier, Facts, Attributes and unkown. These are available under properties of query items.
ASHOK1324
- Apr 23rd, 2009
Frame Work Manager allows the users to model metadata and publish the packages.
-
Performance in executing reports.
What are the steps to be taken care to increase the executing of Reports?
-
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.
-
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!
-
Mind Twisting Questions for Report Studio: Try it
There is a prompt page having the options for ascending and descending, based on the prompt value selected , the report page generates the list column value sorted in either ascending or descending:
-
Alias and Reference Shorcuts in Cognos
We know that Alias never effects if the parent updates where as Reference will. My question is if suppose I took an Alias shortcut for a Query Subject and linking that with parent and if I took a Reference from that query subject what will be the difference for those in performance.
-
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 pass multiple values from picklist prompt to sub report filter
The sub-report only includes the first value."When the sub-report query runs, it checks for the first row in the Customer Name column and shows only information for that customer. If you want a sub-report to show information for another row in the column, place the main report in a form frame that shows only one row at a time. When you insert the sub-report into the form frame as well, it changes as...
cognos.kishore
- Feb 5th, 2010
Create 2 reports in do this actions in 2nd report(detailed Report)Create 1 prompt here 'Ex value prompt on Customer name 'Create one filter on date field 'like IS_CURRENT=?P_IS_CURRENT...
-
What is loop in frameworkmanager ?
ASHOK1324
- Apr 23rd, 2009
Loop: Loop is a closed path (relation) that exists among 3 (or) more tables. Loop gets created when "N" tables have "N" joins.For example if we have '3' tables T1 T2 T3 the...
rkiranbedi
- Mar 2nd, 2007
Loop is a closed Path. it can be exist b/w fact &dimensions, to resolve these we have to use shortcuts
Cognos Interview Questions
Ans