In Microstrategy, what are Logical Views used for?
Answer Posted / sunil
Well both answers are right( from tiru and nadia) same thing just differ in approach.
EX: if there is any table with such feilds
say
day_id, Qtr_id, Qtr_desc, Month_id, Month_desc.
2nd table sales
001 ...090 has same sales ..say 100
now if you are calculating sales over day
it will return you wrong data, by doing 90 days *100 sales values (this is termed as multiple counting problem)
so here we developer are facilitate by this logical table object. we create a new table with proper qtr_id and qtr_desc with sales to get the accurate data every time.
Which will thus be called as aggregated sales data.
This is not recommended until and unless you dont find any other way since performance is your high priority.
Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Can microstrategy desktop access operational data systems?
Is it possible to use microstrategy object manager while other users are making changes in microstrategy agent?
What do you mean by dimensional modeling and relational modeling?
what is a security filter?
Explain access control?
Name the various types of filters?
Explain the difference between rolap and molap?
What happens if the owner of an object does not exist in the destination project?
Explain fact?
Your application mode has crashed. How would you get the instance back?
What are objects?
What do you mean by staging area?
How do you achieve schema object version control?
What do you mean by mstr?
Can intelligence server integrate with my existing data structure?