How to Create a OCE (Open Catalog Extension) in Hyperion?

Shanmuagapriya K

• Feb 3rd, 2013

Launch IR Studio--Tools---Connection--Create.

Answer Question  Select Best Answer

How does the usage of Dataset improve the performance during lookups?

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Aug 17th, 2009

Correct me if i misunderstood your question. I think you want to know whether the usage data will improve the graph performance. I think definitely the usage of data will definitely improve the graph ...

Answer Question  Select Best Answer

What are the various OLAP & MOLAP operations?

mohan

• Mar 20th, 2013

Olap means online analytical processing its mainly used for ssas and then molap means multidimensional online analytical processing its different to olap

Answer Question  Select Best Answer

How to partition a cube in analysis services?

Rambabu Kola

• Sep 7th, 2011

-->create cube using ssas and deploy it.
-->connect sql server management studio
-->then connect sql server analysing services
-->right click on cube and click partition
----------------------------------------------------------------
like this we can partition the cube..

Answer Question  Select Best Answer

What is the Reconcialation Process?

v_madhu29

 Profile Answers by v_madhu29 Questions by v_madhu29

• Aug 11th, 2009

Reconcilation process is a systematic comparision between the data in Dataware house and data in source system.The comparision may be a set a predefined summary values or detailed data periodically.

Answer Question  Select Best Answer

What is Load Frequency and Load Window in ETL?

zann1

 Profile Answers by zann1 Questions by zann1

• Sep 7th, 2009

ETL Load frequency is how often the ETL processes (that load data into the data warehouse) are run.Load Window is the time allocated for ETL load to execute.e.g. If the load is run daily, and the time allowed for execution is 8 hours then:ETL load frequency = dailyLoad window = 8 hours

Answer Question  Select Best Answer

What are the SCD types and what are its Usage?

pradeep16

 Profile Answers by pradeep16 Questions by pradeep16

• Oct 21st, 2009

SCD - Slowly Changing Dimensions. SCD usages in data warehouse are to store the history of transactions on dimensions. There are three types SCDs: Type1 - Just rewrite the record if there is a change...

Answer Question  Select Best Answer

Is data, transient or periodic in data mart? Explain

ashishsinha.dummy

 Profile Answers by ashishsinha.dummy Questions by ashishsinha.dummy

• Nov 10th, 2009

Data marts are part of OLAP system. Data in datamarts cannot be trasient. Data will be updated in datamarts on a periodic or daily basis depending on the design of the data warehouse.-Ashish

Answer Question  Select Best Answer

What is the merge dimension?

Nicolas

 Profile Answers by Nicolas Questions by Nicolas

• Apr 17th, 2010

Merge dimension is the action in Web Intelligence XI that allows to synchronize two or more data providers through common dimension. Once created, the merged dimension can be used as an object for rep...

Answer Question  Select Best Answer

What are the advantages of Data Mining over traditional approaches>

Emanisreddy

 Profile Answers by Emanisreddy Questions by Emanisreddy

• Apr 17th, 2012

Data mining is nothing about analyzing the results with different prospects.

Answer Question  Select Best Answer

What is the use of Degenerated dimension? Where it is used?

gargupendar

 Profile Answers by gargupendar Questions by gargupendar

• Mar 24th, 2011

A degenerate dimension is a dimension which is derived from the fact table and doesn't have its own dimension table.Example : Receipt number is the perfect example for degenerate dimension.

Answer Question  Select Best Answer

What is Dynamic Insert?

mkm187

 Profile Answers by mkm187 Questions by mkm187

• Oct 5th, 2010

INSERT FIRSTWHEN SAL > 25000 THENINTO special_sal VALUES(DEPTID, SAL)WHEN HIREDATE like ('%00%') THENINTO hiredate_history_00 VALUES(DEPTID,HIREDATE)WHEN HIREDATE like ('%99%') THEN...

Answer Question  Select Best Answer

How to pass first, Middle and last record in flat file to flat file?

KVR Prasad

• Dec 1st, 2011

By using sequence generator, Expression transformation and router T/R it will be possible.

Answer Question  Select Best Answer

Rajesh Swarnkar

• Feb 28th, 2012

Data Marts are considered as smaller logical subset of Data warehouse. DW is enterprise-wide while DMs are for Department Level. So DMs can be identified on the basis of what departments are there in Insurance company.
E.g. Sales Department.

Answer Question  Select Best Answer

What is the use of the unused port in the join component? We have reject port. Difference between the reject port & unused port?

anshuman trivedi

• Mar 3rd, 2013

Hi, Answer of question is as following. 1)Reject Port:it will contain all the rejected record,here rejection does not means those records which does not follow the join condition,here comes those reco...

Answer Question  Select Best Answer

my Source is like:

Sno Name
1 XXXX
2 YYYY

I want the Target like:

Sno Name Frequency
1 XXXX 1
2 YYYY 2
2 YYYY 2

How can I replicate the "2 YYYY".
I am supposed to make it dynamic for all possible frequencies.

Visal

• Aug 14th, 2016

From what I understood from the scenario given above, you want to duplicate some particular type of record. use Router and write the same condition (say column1=2) for both output group. Remember defa...

Answer Question  Select Best Answer

Sandip More

• Mar 3rd, 2013

You can interact with another co-operating system with setting below parameters in .abinitiorc of existing coperating system : AB_NODE : Node at which this another co-operating system resides AB_HOME...

Answer Question  Select Best Answer

What is external table in oracle?How oracle read flat file?

sheraz baig

• Nov 20th, 2013

External Tables let you query data in a flat file. In 9i, only read operations were permitted; in 10g, you can also write out data to an external table. While external tables can be queried, theyre no...

Answer Question  Select Best Answer

How union transformation is active?

jignesh

• Jan 2nd, 2015

No doubt union transformation will give you the result as a passive transformation with same number of records,But row number of the records will get changed in output result set.....eg we have table ...

Answer Question  Select Best Answer

Harsh

• Dec 2nd, 2014

Alter index rebuild;

Answer Question  Select Best Answer