GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  MicroStrategy
Next Question 
 MicroStrategy  |  Question 1 of 12    Print  
In Microstrategy, what are Logical Views used for?

  
Total Answers and Comments: 5 Last Update: October 29, 2008     Asked by: KPIZME 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: madhuchandra
 
Logical Views or logical tables are used to model a Microstrategy schema that cannot be supported with just the database structures.

By using Logical views it is easier to manage SCD's , attribute form expresseions from multiple tables etc.

Result of logical views are not cached. - additional info

Thanks
Madhu
9945533288

Above answer was rated as good by the following members:
ashu_eureka
October 26, 2006 01:48:44   #1  
S        

RE: In Microstrategy, what are Logical Views used for?...

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.

Solves complex data modeling challenges.


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
October 26, 2006 02:02:45   #2  
S        

RE: In Microstrategy, what are Logical Views used for?...


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.

Solves complex data modeling challenges.


 
Is this answer useful? Yes | No
October 06, 2007 11:36:51   #3  
wasim        

RE: In Microstrategy, what are Logical Views used for?...
Logical views are views in Oracle database it contains one or more table columns from different tables without DBA involvement.
 
Is this answer useful? Yes | No
July 11, 2008 02:14:19   #4  
madhuchandra Member Since: September 2006   Contribution: 2    

RE: In Microstrategy, what are Logical Views used for?
Logical Views or logical tables are used to model a Microstrategy schema that cannot be supported with just the database structures.

By using Logical views it is easier to manage SCD's attribute form expresseions from multiple tables etc.

Result of logical views are not cached. - additional info

Thanks
Madhu
9945533288

 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
October 29, 2008 02:36:33   #5  
vijaya_friendly Member Since: October 2008   Contribution: 2    

RE: In Microstrategy, what are Logical Views used for?

Logical Views are mainly used for to resolve many-many relationships. many-many relationship causes Multiple counting or double counting. The results of logical views are not cached;


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape