Micro Strategy

For performance tuning there some areas where you need to look and work accordingly.

like

1) is there sufficient space so that MSTR can create temporary tables.

2)proper filtering condition.

3)proper joining between required tables.

4) VLDB property

5)optimization (manual, logical and global)

its better if go go in the same order....

This can be acheived by decreasing the logical size of the

desire table in a such a way that it should be less than

other tables. AS Microstrategy will look the tale having

the least logical size and will make a join with that table.

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.