5.what is slowly changing dimension ?
Answers were Sorted based on User's Feedback
Answer / naga bhushanam.banglore
Slowly changing dimensions(SCD) is the type of dimensions
which changes with respect to time or peeriod.
Fo s ex: there is an table which has objects like
Country City Employeeid ddress .
Here for example the say the employee of employee id say
e23321 is presently in Hyderabad after a month he is re-
located in Banglore than we can say the address dimension
is SCD w.r.t. time
We have 3 types of SCDs:
SCD-1
SCD-2
SCD-3
SCD-1:where no historical data is not maintained only
present data is maintained
SCD-2:Where complete historic + presentl data is maintained
SCD-3:Where one time historic(say previous) data+ current
data is maintained
| Is This Answer Correct ? | 26 Yes | 0 No |
Answer / mrs.narmatha
Slowly changing dimension applies to some cases where
attribute for a record varies over time.
For example a person called narmatha lived in one place
(india). So the original entry in the customer lookup table
like : customer id :100 name: narmatha country:India
At a later the person moved to UK
How should XYZ Inc. now modify its customer table to
reflect this change? This is the "Slowly Changing
Dimension" problem.
| Is This Answer Correct ? | 6 Yes | 0 No |
what is the difference between Ranking and sort-out in bo?
What are the join problems comes appart from loop,chasm & fan Traps
what is xcelsius architecture?
what is profile and packages in BOXI??
how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?
(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.
Can Bo generates the Report from the cubical data Explain?
I have 4 tables having many to many relationships between the tables? How i can get correct results in the report?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
how can i add two different reports in the same document?
What is BOMain.Key?
in BO module, you forgot all password even all user in business object, designer, supervisor, gen.supervisor everythicg, how to you recover your datas?