what is confirm dimension ?

Answer Posted / handy

A confirmed Dimension (CD) is a dimension which is shared by
different fact tables.

For examples, there are different data marts are there say
Loans, Deposits, Withdrawals etc.....in this there is a
dimension called Date which is common to all. We can link to
different datamarts using a common dimension called Date in
this example.

Is This Answer Correct ?    5 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between absolute and relative div positioning?

571


Explain what is aggregate table and aggregate fact table ... Any examples of both?

601


Can more than 1 metric be applied on an analytic in business objects?

1646


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

986


What is the difference between datawarehousing and businessintelligence?

604






What are the data types present in bo? What happens if we implement view in the designer and report?

609


what is the difference b/w the refresh and buffered data?

1752


Explain when we use aggregate awareness function in designer?

576


Explain when to use local filter and when to use global filter?

592


can anybody tell me about complicated object you have created

2744


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3268


Can Bo generates the Report from the cubical data Explain?

1621


Explain in detail about type 1?

639


Explain what is the difference between business requirement document and use case document.

567


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2595