Viewing Hierarchy by Plan Type - "Filter by Plan Type"

When having more than one plan type, whenever I wanted to see the hierarchies separately by Plan Type wise, I always used to go to EAS console to check the hierarchies. I never knew that there is an option right in front of me in workspace (11.1.2.2) which could make life easier for me and not to login to EAS console just to view the hierarchies.

When you click the filter icon “Filter by Plan Type”, system provides necessary options and selecting it one can view hierarchy based on Plan type.

MDX Query - Count Level Zero Members

In one of our implementation I wanted to know the number of level zero members in a dimension and after some research finally ended up having following MDX query:

WITH

Member [Product].[ProCount] AS 'Count([Product].Levels(0).members)'

SELECT {[Year]} on AXIS(0),

{[Product].[ProCount]} on Axis(1)

FROM [Sample.Basic];

Syntax for MaintenanceMode Utility

You may be aware that MaintenanceMode utility can be used to temporarily withdraw access to applications during maintenance. As part of metadata refresh process, I used this utility to make sure no users are logged in the application, however I was not able to execute it successfully using the syntax provided in documentation.

Syntax provided is as follows:

MaintenanceMode [-f:passwordFile], /A=app, /U=user, /P=password,  /LL=loginLevel [ALL_USERS|ADMINISTRATORS|OWNER], [/DEBUG=[true|false]], [/HELP=Y]

Note the comma after "[-f:passwordFile]"; this is not required.

Following command works without any errors (in windows):

CALL %BinPath%\MaintenanceMode -f:%PasswordFile% /A=%HypApp%, /U=%UserName%, /LL=ADMINISTRATORS