In Microstrategy, how can you direct the sql generated to
use a specifc table?

Answer Posted / ashok

In Metrics Editor Goto->Dimensionality->add attribute as Target and keep Grouping and Filtering as NONE.

This is the way to point a metric to use particula table.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain fact table?

820


Is it possible to use microstrategy object manager while other users are making changes in microstrategy agent?

727


Can I access intelligent cubes without olap services?

756


What is the conflict resolution window?

783


What is dynamic aggregation in microstrategy?

738


What are consolidations?

688


What are the tracing options available in microstrategy object manager?

740


What do you mean by inmon?

831


Explain security filter?

772


Can reports be executed in off-peak periods?

757


What are configuration objects?

800


what is the difference between microstrategy and cognos?

719


Compare microstrategy and tableau.

729


Explain transformations?

755


How are microstrategy reports performance tuned?

723