prudhvi.g

 Profile Answers by prudhvi.g Questions by prudhvi.g

• Sep 3rd, 2007

      --->  Select Impromptu Admin.      --->  Catalog     ---->  Folders     ---...

rkiranbedi

• Apr 13th, 2007

Hi,
Open Impromptu Administrator -> Catalog -> Folders option Select the
column you want to
Click the Edit button, From Left Pane Select Particular Column which
you wants to Rename Drag that into Right Pane then
Select that Column and Click on Rename Button then Change the
name.

Answer Question  Select Best Answer

Amedhyaz

 Profile Answers by Amedhyaz Questions by Amedhyaz

• Aug 12th, 2008

Impromptu Query Definition - Database metadata - Select the query subject items in FM that we want to export in the form of an IQD and select the right option from the contextual menu.

jyothsna

• May 12th, 2006

An .iqd file is typically created by Impromptu and contains the definition for a database query.PowerPlay Transformer can access relational data sources via Impromptu Query Definition files.If Impromp...

Answer Question  Select Best Answer

chinnuchaitu

 Profile Answers by chinnuchaitu Questions by chinnuchaitu

• Feb 14th, 2007

cognos 7.X1.multilingual reports not possible.2.not possible to send reports through mails.3.analysis , maps, different types of charts are not available.4.here catalogs are generated.5.modeling is di...

ranga

• Jan 4th, 2007

hai,cognos 7.xhere multilingual reports r not posible.cognos 8here multilingual reports r posible.in this having metric studio,analysis studio.

Answer Question  Select Best Answer

chaitanya

• Jul 17th, 2007

Cognos uses KERBORES security model. It was the model which was found in 1980.

ranga

• Jan 3rd, 2007

By using third party authentication.

Answer Question  Select Best Answer

How to change database option in cognos10 content store as it has already fixed by DB2.I need to change to MSSQL Server.

Subba Reddy

• Sep 17th, 2012

I created value prompt, when I select Few values in prompt these values showing in report header between (,)s.
I need (-) in between two values.
Could you please suggest me.

moluguri

 Profile Answers by moluguri Questions by moluguri

• Aug 30th, 2012

1. Open the IBM Cognos Configuration
2. Go to Database Access,
Select ContentStore then right click on it then Delete
after that
Select ContentManaget then right click on it then Select New Source->Database->Name:xxxxx -> Type MSSQL Server-> Click OK and give the User Name and Password.

Answer Question  Select Best Answer

ASHOK1324

 Profile Answers by ASHOK1324 Questions by ASHOK1324

• Apr 23rd, 2009

Hierarchy defines the order of query items for report to report interactions [RRI]. Hierarchies are defined in query subject to support drill-down and drill-up functionalities.

Rpe

• Mar 26th, 2007

Ok, let's start with the definitions...hierarchyA description of the order of levels in a dimension. In Framework Manager, you define hierarchies in the query subject. levelA group of query items ...

Answer Question  Select Best Answer

thakklapelly anil

• Aug 30th, 2007

Hi Anand1)? Comparing with Reportnet, Cognos 8 have Analysis Studio, Metric Studio, Event Studio.2) The cube which is created in Cognos Powerplay Transformer can be published in Cognos 8 where as we ...

sranand123

 Profile Answers by sranand123 Questions by sranand123

• Mar 31st, 2007

HI Anand,Main difference between Cognos8 and CRN 1.1 are analsys studio , metric studio are added.

Answer Question  Select Best Answer

Internally what will happen in cognos if we run a report in report studio

Jay

• May 10th, 2014

Once the user runs the report, 1.The request is passed to the Web Server and gateways (CGI, ISAPI). The Cognos Gateway applies encryption to the information received, adds necessary environment vari...

Raghavendra

• Mar 13th, 2014

It will goto content store database to get metadata of required columns and data from specific database.

Answer Question  Select Best Answer

na__dim

 Profile Answers by na__dim Questions by na__dim

• Sep 25th, 2007

You will normally use scripting in Cognos when using Power Promts.

guru

• Jul 23rd, 2007

We can add JavaScript with the help of HTML item.

Answer Question  Select Best Answer

thakkalapellyanil

• Aug 30th, 2007

SCD means it explains?exactly how the changed data has been loaded into the target database.There are three types of SCDSCD1SCD2SCD3SCD1: It holds only current data.SCD2: It holds the current+histori...

rkiranbedi

• Mar 27th, 2007

Slowly changing dimension means these dimensions will change according to time,Ex: In Bank- a/c number, A/c name , address is there then if v change address then address will be a slowly changing dimension for that,It is of 3 typesType-IType-IIType-III.

Answer Question  Select Best Answer

adi

• Jun 17th, 2006

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.Cog...

jyothsna

• May 15th, 2006

Cognos Visualizer:Cognos Visualizer provides powerful visual analysis to communicate complex business dataquickly and intuitively. By going beyond simple pie or bar graphs, you can view and combinedat...

Answer Question  Select Best Answer

simmidear

 Profile Answers by simmidear Questions by simmidear

• Nov 12th, 2008

migrate all at a time from ReportNet to Cognos8(Frame work Manager, Reports, Cube)------------------------------------------------------------------------------------------In ReportnetOpen content sto...

zecar

 Profile Answers by zecar Questions by zecar

• Sep 19th, 2007

Are you talking abt cognos series 7 or only cognos reportnet?

Answer Question  Select Best Answer

zecar

 Profile Answers by zecar Questions by zecar

• Sep 19th, 2007

The syntax is as follows: LOOKUP (name) in (value1 --> value2) default (name)Name: the name of your columnvalue1: value you would like to be replacedvalue2: value you would like to replace it withd...

narender

• Jul 23rd, 2007

By using parameter map

Answer Question  Select Best Answer

visitor

• Sep 3rd, 2007

You have missed one more important point.For incrimental update cube additionally we need to create hot files and frequently update the cube and over write the old hot files with latest hotfiles and then update the cube.Thanks,

Rupali

• Mar 16th, 2007

By using incremental refreshing for the cube, you don't need to recreate the cube for updates it will only update the cube by latest information. This will increase the performance in Transformer.For ...

Answer Question  Select Best Answer

ravimantur

 Profile Answers by ravimantur Questions by ravimantur

• Jun 12th, 2009

Refreshing the cube fetches the latest data to the cube. Which can be used to extract the latest reports out of it. Inorder to refresh the cube right click on the cube in powerplay transformer you will get an option refresh cube click on it and its done.

chinnuchaitu

 Profile Answers by chinnuchaitu Questions by chinnuchaitu

• Feb 13th, 2007

Refreshing the cube means it just gets the latest data and there is a option Refresh to do so.

Answer Question  Select Best Answer

ASHOK1324

 Profile Answers by ASHOK1324 Questions by ASHOK1324

• Apr 23rd, 2009

We can access "Query Studio" to create and view simple reports via cognos connection after selecting the package that got imported from cognos content store. We can now select Required Query Items from different Query Subjects to generate ad-hoc reports. 

Rajitha

• Dec 14th, 2006

Through Cognos Connection we can access the Query Studio After that we can select our Package(Which one u  imported DataBase). We Can select Required Query Items generate the reports. Its Generate Adhoc Reports.

Answer Question  Select Best Answer

ave

• Nov 29th, 2006

Report Studio, Query Studio, Analysis Studio, Metric Studio,........

Amit

• Nov 29th, 2006

Query Studio -- Ad Hoc ReportsReport Studio -- Complex Reports (All the Development of the report does usually go here)Analysis Studio -- Anlaysis Reports Metric Studio -- Dashboard Reports...Event studio --

Answer Question  Select Best Answer

simik

 Profile Answers by simik Questions by simik

• Feb 24th, 2009

Dashboards are reports created using graphs and charts as a mechanism of presenting information.Dashboards communicates complex information quickly. They translate information from your various corpor...

rkiranbedi

• Mar 5th, 2007

Dash Board reports are used to create many reports in one report like Gauge chart, Progress chart, Combination Chart and so on. It combines Multiple Queries into a same chart are multiple charts.

Answer Question  Select Best Answer

ranga

• Jan 4th, 2007

hai,at package level we can provide security, by selecting and unselecting the query subjects(tables).we can also hide the tables.at report level save ur report in personal folder.By using ACESS MANAGER we can set security to users.rangaranganadhn@yahoo.com

rajesh

• Dec 23rd, 2006

hi..There will be option "governer". In this governer we can provide security.Rajesh

Answer Question  Select Best Answer

thakkalapelly anil

• Aug 30th, 2007

Actually there is no limitations for fact and dimensions tables. That depends upon the data and the project. Normally we have 60 dimensions and 17 fact tables.

ranga

• Jan 3rd, 2007

Actually there is no limitations for no.of dim&fat tabels for project. approximately 40+ dim tables, 5+ fact tables.rangaranganadhn@yahoo.com

Answer Question  Select Best Answer