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
Is it possible for different nodes of a microstrategy intelligence server cluster to run against different metadata repositories?
suppose the network connection between a webserver and clustered i-server gets lost. What will happen? Will the report still run?
How would you get two images on microstrategy login page?
How does microstrategy object manager integrate with the microstrategy product suite security model?
What do you mean by static prompt report?
How do you ensure simultaneous releases across multiple operating systems?
What are the different types of mstr objects?
what do you mean by security filter?
what are the different authentication modes available in microstrategy?
What are logical views used for in microstrategy?
what are the different types of fact structures?
How does microstrategy object manager determine if two projects are related?
What do you mean by consolidations?
How would you configure wh authentication?
Is it possible to limit the number of reports run by a users at a time? How? What will happen if this limit is exceeded?