ramesh4u

 Profile Answers by ramesh4u Questions by ramesh4u

• Feb 4th, 2008

By using Framework Manager we can create IQD files ,By using IQD files we can creat cubes in powerplay

Answer Question  Select Best Answer

ranganadh

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

Answer Question  Select Best Answer

How to upgrade the model means How to add new Query items in the existed model ?

basecog

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

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

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

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

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

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

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

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

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

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

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

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

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

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