Interested to Buy Any Domain ? << Click Here >> for more details...
In Microstrategy, what are Logical Views used for?
- 6 Answers
- 25098 Views
- InfoCepts, Marlabs, Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / tiru
Logical view is just a table(logical table) but it is
create in deskop by writing our own SQL as per Our
requirement based on the physical tabes what we import from
our database.Once if it is create itacts as a physicaltable
as other phisical tables.
| Is This Answer Correct ? | 18 Yes | 3 No |
Answer / nadia sheikh
Logical Views allows application architects to create any
desired view using MicroStrategy, without DBA involvement.
Once these Logical views are created, they are available to
the report designer in a way similar to any other table.
This allows developers to model attributes and facts whose
expressions span multiple tables.
| Is This Answer Correct ? | 12 Yes | 1 No |
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 |
Answer / ashok
Logical View is nothing but SQL query and that query exectutes as inline query in SQL view.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / garima agrawal
Logics which are not possible to perform from database and Microstrategy part for writing that kind of logics requirement we use Logical Views into the Microstrategy tool.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / pencildot
a logical view is a view that u obtain by querying the db
thru sql. these result can be stored as a table then.
| Is This Answer Correct ? | 2 Yes | 5 No |
Hi can any one explain me what is Major Difference between Dashboard and Document Please assist me.
# how to increase logical sige of a table in microstrategy
What is dynamic aggregation in microstrategy?
I want to learn Microstrategy Tool...Can you help me to find best coaching center for Microstategy..please send details to maheswari.umaece@gmail.com Thanks and Regards, Uma
How do you optimize reports in microstartegy?
Can microstrategy desktop access operational data systems?
A report is taking few seconds to run.The same report is taking very long time on the next day without doing any kind of changes in the report. What could be the reason? how do you tune the report.
what are the roles & responsibilities of microstrategy developer?
What leads to a cross-join or how does a cross-join occur?
Explain two-tier connection?
Can the administrator easily maintain and manage microstrategy intelligence server?
Can reports be executed in off-peak periods?
Teradata 
