I want to get sales data for the last (suppose 10) dates
dynamically
using value prompt how can i do it and drag it onto report
editor.

Answer Posted / vivek jain

You can do it without using value prompt with below steps.
Create a filter on day attribute qualified on ID operator >
and set value to resolve dynamically today – last 10 days.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between absolute filtering and standard filtering?

529


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.

595


You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?

529


What are consolidations?

521


Explain fact constellation schema?

579






How would you configure wh authentication? Explain.

536


Explain transformations?

589


What is pass through metrics in microstrategy?

556


What are pass-through functions and why they are so called? Give some examples.

580


what are the different types of tests done on a microstrategy report?

528


Difference between project merge and object manager in microstrategy?

602


Can I access intelligent cubes without olap services?

567


Explain heterogeneous mapping?

562


What is fact degradation?

577


How do you ensure simultaneous releases across multiple operating systems?

574