Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
When we use aggregate awareness function in designer?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain which versions are used in the bo dashboard work?
What is difference between custom hierarchy and report based hierarchy?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What is a fantrap in business objects?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
is it possible to export the webi reports to crystal reports?with out using businessview?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
How to execute the plsql procedure from the report by clicking with mouse?
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:
Explain the data types present in bo and what happens if we implement view in the designer and report?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
