Microstrategy filter on dataset in document

On Microstrategy Web, if your document/dashboard is based on a dataset that is returning you too much data and you want to apply a filter on your dashboard..right click on your grid, click "Edit View Filter", then you can select what attribute/metric you want to filter on and the conditions.

Datastage Date Manipulation

I always have a hard time trying to add or minus days  to a given date in Datastage. You can use icon, ocon too....but I like this method when I need to manipulate a date column in Transformer Stage.

To add one day to a given date (an incoming date column):

DateFromJulianDay(JulianDayFromDate(DSLink1.your_date_column) + 1)

So basically you convert a date to a julian day, then add 1, then convert the julian day back to a date.

Microstrategy Modifying Tooltips on graphs

By default, when you have a graph, the tooltip on the web will display:
Series: Electronics Sales Amt
Category: 2012-09-07
Value: $2,509.24

But what if you want your tooltip to say:

Electronics Sales Amt: $2,509.24
Date: 2012-09-07?

Under Graph, Preferences, Series, select one of your series, show tooltip, remove the default value of {&TOOLTIP}
and instead type this:
{&SERIESLABEL}:{&VALUE}&#13Date:{&GROUPLABEL}