Interested to Buy Any Domain ? << Click Here >> for more details...
In Microstrategy, what are Logical Views used for?
- 6 Answers
- 25087 Views
- InfoCepts, Marlabs, Tech Mahindra, I also Faced
- E-Mail Answers
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
Your colleague installed microstrategy on solaris or unix without root access. Will he be able to start/ restart this server?
Can reports be executed in off-peak periods?
What is a logical size of a table and what does it depend on?
How we can decided drilling options for an attribute?
you are required to disable webusers to use only one i-server. How would you do that?
What specific features and functionality do I get with olap services?
What are the different modes to run i-server?
What is an i-server?
What is rank metrics in microstrategy?
Your application mode has crashed. How would you run your i-server?
You have got the requirement from a client. Explain the technical approach you will take now.
If a microstrategy intelligence server node is removed from a cluster manually, will report caches be lost?
Explain fact table?
what are the different authentication modes available in microstrategy?
What is derived metric?
