6.what is conformed dimension? R u used?
Answers were Sorted based on User's Feedback
Answer / velmanisundaresan
Confirmed Dimention is a dimention table which is connected
to the multiple fact tables
| Is This Answer Correct ? | 27 Yes | 2 No |
Answer / handy
A Confirmed Dimension (CD) is a dimension which is shared by
different fact tables.
| Is This Answer Correct ? | 15 Yes | 1 No |
Answer / balaji
Conformed dimendion is a dimension that has a single meaning
or content throught datawarehouse.we can use it accross the
fact tables
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / chaitanya
A dimension that is used in more than one cube.
The use of conformed dimensions and shared measures is the
primary way a set of data marts can be united into one
consolidated data warehouse.
| Is This Answer Correct ? | 9 Yes | 4 No |
Answer / vams_gk
it is a dimention accept ble join relation between two facts
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / chandrashekar
The dimensions which are common to the cubes.Example Cube1
Use D1,D4,D5,F1 and Cube2 Use D1,D4,D7 than D1,D4 known as
confirmed Dimensions.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / siva
A conformed dimension is a set of data attributes that have
been physically implemented in multiple database tables
using the same structure, attributes, domain values,
definitions and concepts in each implementation
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / rajender
conformed dimension table is once created that is not
changed occutionally
| Is This Answer Correct ? | 3 Yes | 10 No |
what is meant by report busting
main purpose of aggregate awareness(not include make possible of use of aggregate tables)
I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)
Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.
How many tables can an universe contain is their any limit to insert tables in the universe?
what are the all possible reasons of getting partial result on a webi report?
How to get red line in the graph at some point (value)? Example : In graph at 200000 value
Can anybody tell me the difference b/w canned and adhoc reporting?.
Tell me about linked universe ?
What is meant by data federator and what is the use of it?
why less number of records in loop? why more number of records in traps?
is it possible to export the webi reports to crystal reports?with out using businessview?