MicroStrategy - In Microstrategy, what are Logical Views used for?

GeekInterview.com > Interview Questions > Data Warehousing > MicroStrategy

Next Question

MicroStrategy | Question 1 of 12

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

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

1 0

Overall Rating: +1

October 26, 2006 02:02:45

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

Solves complex data modeling challenges.

Is this answer useful? Yes | No

October 06, 2007 11:36:51

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

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 | No

1 0

Overall Rating: +1

October 29, 2008 02:36:33

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

User Name		Remember Me?
Password

Question Bank