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
Explain 4gt switch. Does it have any drawback?
Can intelligence server integrate with my existing data structure?
Do you know how to prioritize the excecution of a report?
Explain fact?
Explain clustering?
Your i-sever crashed. What will you do?
What is microstrategy intelligence server?
Define different types of attributes in microstrategy desktop?
What olap capabilities do I have within a microstrategy report services document?
How are microstrategy reports performance tuned?
What do you mean by dimensional modeling and relational modeling?
Can I access intelligent cubes without olap services?
While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?
What are prompted filters?
What are the different modes to run i-server?