What are prompted filters? Have you ever used them? Where?
Can a record be inserted and updated in database using microstartegy?
Explain snowflake schema?
what do you mean by custom groups?
what do you mean by kimball?
Explain the difference between holap and molap?
Explain fact relation?
Explain security filter?
How do you optimize reports in microstartegy?
Explain transformations?
How would you configure wh authentication? Explain.
You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?
Now, imagine this, you come across a situation where an aggregate table at higher level has a higher lts than the one at lower level. A.) What problems can you anticipate? B.) How would you solve the problem.
Is there a difference between view filter and report filter?
Explain compound key?