User Answers

There is no direct equivalent in ObjectScript to the ternary operator. You can use $SELECT or $CASE

  • Those listings in italics are defined in Listing Groups. You can find them in SMP > DeepSee > Tools > Listing Group Manager > Open > Additional Listing for HoleFoods Sample
    They work in MDX:
    Do $SYSTEM.DeepSee.Shell()
    >>DRILLTHROUGH SELECT FROM [holefoods] %LISTING [Another Sample Listing by Date]

1) Filter controls have a target field that determine what widgets are affected. Please check the docs:

I do not think it is possible to print a whole dashboard. I suggest using the browser's printing interface. For best results I would suggest using URL parameters on your dashboard, for example using  &NOTITLE=1;&NOMODIFY=1  or even &EMBED=1.

One way to do this is by using a pivot variable. Create the same pivot variable "Region" in both pivots on which your widgets are based. These pivot variables should return the members, in your example Asia, Europe, N. America, S. America. You can define the manually or in a termlist, or use a kpi to retrieve them. 

%LAST evaluates a measure or numeric expression for the last non-empty member of a set, so I do not think that is what you want.

I am using %LASTCHILD, but you cannot append it to [DateOfSale].[Actual].[MonthSold].Members because %LASTCHILD only works on specific member. For the moment I found this solution:

WITH  MEMBER [DateOfSale].[LastDayOfMonth] AS '[DateOfSale].[Actual].[MonthSold].CurrentMember.LASTCHILD' 

SELECT [Measures].[Amount Sold] ON 0,

I do not think there is a way to ask the user to select a user before displaying the dashboard. 

Maybe you can try setting the filter as required in the dashboard settings and as default value using a run-time variable. The run-time variable should return the current username. To return the current user start from the COS $username special variable.