what is view filter

Answer Posted / guest

view filter is nothing but simple filtering condition but used only when,
a report is executed and some data is being returned. In other words you are just applying filter over the view of data. This is one of the very useful olap property.

EX:
you are developing a report with country and sales

data are some what...

india 1000m
US 10000m
china 8000m

now you just want to view only one country and sale of it.
so, just apply a filter over that executed report.

then it just return like
India 1000m

keep in mind that it will have no effect over the executed SQL in earlier report.
IT will also increase the process and Interaction with client will good.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Your i-sever crashed. What will you do?

649


While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?

526


What is an i-server? What are the different modes to run it?

539


how do you create schema objects in 2 tier connection?

552


Can you create an event based schedule in microstrategy? How?

600






What is metadata in microstrategy?

619


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

522


What is an object prompt?

593


What is smart metric?

547


What are public objects?

641


How is security handled?

585


What is rank metrics in microstrategy?

583


Compare dataset and fileset?

574


What are the different types of metrics available in microstrategy?

547


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

519