| |
GeekInterview.com > Interview Questions > Data Warehousing > MicroStrategy
| Print | |
Question: In Microstrategy, how can you direct the sql generated to use a specifc table.
I know of using ApplySimple, but there are other ways too...
|
| September 09, 2006 11:02:36 |
#3 |
| jpg1dmg |
Member Since: September 2006 Total Comments: 2 |
RE: In Microstrategy, how can you direct the sql gener...
|
I would use level metrics to force the SQL generation. - Remove the Report Level from the metric(s)
- Add Leveling to the metric(s) for each of the Deminsions/Attributes in the Fact Table you are trying to force in the SQL
By doing this you will only affect the report that is using the metric. If you start altering the Logical Table Size, you will affect other reports. |
| |
Back To Question | |
