In Microstrategy, how can you direct the sql generated to
use a specifc table?
Answers were Sorted based on User's Feedback
Answer / preeja
if it is required for metric to calculate from a particular
table in report, you can try changing the "level" in the
merics.
or by using relationship filter also can direct to a
particular table ,based on the requirement.
modifying the logical table size is a good idea, but it can
affect all reports which depends on the attributes defined
on the same table.
Is This Answer Correct ? | 13 Yes | 0 No |
Answer / vanitha
create dummy attribute on the specific table and use that
dummy attribute as a report object then the SQL hit the
Specific table
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / kwwl
By changing the Logical Size of the "specific" table. After
changing table size, you need to update schema.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / kanchan
In addition to above answers, you can force a fact to take
data from the required table only
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pritika
we can use alias name of that table and change the logical
size of that alias table dnt modifies main table and use the
alias table..
Is This Answer Correct ? | 1 Yes | 0 No |
Totally agree Preeja's answer...but when you have more then
one fact table and they all are hitting some other attribute
you will have take VLDB prop under consideration.
changing the logical size never recommended unless you full knowledge of architect and expertise.
It will create some problem in other reports.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sreenivasa rao
Using force fact only can hit a particulat table
Is This Answer Correct ? | 0 Yes | 0 No |
Imagine this, you are required to reset the password for all users at a time. How would you do that?
what is the difference between documents and dashboards in mstr?
Explain true primary keys?
What is purpose of having conditionality in metrics in microstrategy?
What is non-aggregate metric?
Your application mode has crashed. A.) How would you run your i-server? B.) How would you get the instance back?
What do you mean by derived metrics?
Explain snowflake schema?
You have got the requirement from a client. Explain the technical approach you will take now.
what is the difference between the report filter and report limit?
what are the different types of fact structures?
1.Have u logical models in project? If s which logical model used? 2.how do u connect to production server? 3. how do u test the data in report is same as in DWH? 4. u created one report but there is no data in the attribute. But how can u extract the data from ware house? 5. u have two tables having different ids how do u merge those table in MSTR? 6. have u faced challenging situation in u r project? Give me one example?