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

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

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

prudhvi.g

 Profile Answers by prudhvi.g Questions by prudhvi.g

• Sep 3rd, 2007

We've 2 ways to import data into a catalog.They are 1. Database which contains all the data               2. Hot file which is meant as local database. this also contains Meta data.

Jyothsna

• May 15th, 2006

One through Database optionother one though hotfile option

Answer Question  Select Best Answer

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

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

phanii

• Sep 15th, 2007

Snapshot is the permanent local copy of the data in your report.

shekar

• Nov 29th, 2006

snapshot is a static datasource, it is a picture of of report,once u created a snapshot report u can't add a data item(coloum).we can perform some operations like run,view,grouping..

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

zecar  

 Profile Answers by zecar Questions by zecar

• Member Since Sep-2006 | Sep 17th, 2007

---

1. In Cognos Connection, Go to Public Folders or My Folders, click the schedule button for the report you want to schedule.
2. Under frequency, select how often you want the schedule to run.
3. Under Start, select the date and time you want the schedule to start.
4. Under End, select the date and time you want to end the schedule.
5. Under Formats, click the format you want to run the output.
6. Under Languages, select the languages to select different languages.
7. Under Delivery, choose any one delivery method.
8. If you want to be prompted, under Prompt values,select the Prompt for Values checkbox.
9. Click Ok.

zecar

 Profile Answers by zecar Questions by zecar

• Sep 17th, 2007

1. In Cognos Connection, Go to Public Folders or My Folders, click the schedule button for the report you want to schedule.2. Under frequency, select how often you want the schedule to run.3. Under St...

P Ramesh

• Sep 13th, 2006

There are three types of Schedules in CognosRun with Option ? Single time SchedulingRecurring Scheduling ? U can specify u r date and time hereJob or Batch Scheduling ? A Job is a group of reports whi...

Improve 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

zecar

 Profile Answers by zecar Questions by zecar

• Sep 19th, 2007

In the case of No Spanning Tree, a join is missing between groups of joined tables.

Answer Question  Select Best Answer

na__dim

 Profile Answers by na__dim Questions by 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.

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

silu.davidson

 Profile Answers by silu.davidson Questions by 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...

Answer Question  Select Best Answer

vipvats

 Profile Answers by vipvats Questions by 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...

Answer Question  Select Best Answer

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

 Profile Answers by the_xxx Questions by 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...

Answer Question  Select Best Answer

revitala

 Profile Answers by revitala Questions by 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...

Answer Question  Select Best Answer

naveen

• Nov 20th, 2007

Usage property identifies the intended use for the data represented by each query item and it determines the aggregation rules of query items and calculations.The different usage property settings are Identifier,Fact,Attribute, and Unknown.

Answer Question  Select Best Answer