what is view filter
- 9 Answers
- 10343 Views
- IBM, Marlabs, Ness Technologies, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
It restricts the data being displayed on the report with out
re executing against data base.This improves response time
and decreases database load.
| Is This Answer Correct ? | 12 Yes | 2 No |
Answer / guest
Apply specfic filter condition then after we can get the
report data set. it is olap.view filter main use viewing
purpose for custmoers.
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / praveen kumar sivvam
View filter dynamically restrict the data being displayed
in the report.
It doesn't effect to the SQL
EX: I have report with the year and revenue objects. I want
a revenue for the year 2008 only then it wl be useful.
| Is This Answer Correct ? | 2 Yes | 0 No |
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 |
Answer / sivaprasada rao
view filter is one of the filter in microstrategy we r used view filter after exicution of the report ...the purpose of this filter is to restrict the unwanted data from exicuted report the main advantage of this filter is it doesnot go to warehouse ...exiction time is loww but we cant see it in sql view..............
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / praveen
View filter is an olap services. When we apply this filter
for an executed resultant data of a report set.
it will restrict the amount of data and reexecute the report.
It will not execute against the dataware house.
so there is no change in the sql.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / balaji
we can apply filter condition on fly after running the
report dynamically called view filters. View filters are
local to the report. We can save view filters with report
defination. View filters are not reusable components.
| Is This Answer Correct ? | 0 Yes | 0 No |
view filter is a filter condition we apply on the objects present in report object section in a report .It is applied after the execution of report.
It does not impact sql as it is an OLAP service which gets calculated at analytical engine.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the types of facts in microstrategy?
Is it possible to use microstrategy object manager while other users are making changes in microstrategy agent?
What are prompted filters? Have you ever used them? Where?
What is the difference between absolute filtering and standard filtering in microstrategy?
Explain oject manager?
What is the difference between microstrategy and cognos reporting tool?
differentiate between two-tier, three-tier and four-tier connections.
what is the difference b/w the public object&schema object
Explain static reports?
What information is shared by the application across microstrategy web nodes?
what specific features and functionality do you get with olap services?
Explain about compound key?
Teradata 
