Use of MDX WITH keyword in Apliqo UX

Apliqo UX
1

Hi All,

Hoping to be able to use a query-scoped MDX member created by the WITH keyword in an Apliqo UX widget. My MDX code is as follows:

WITH
MEMBER [consultant].[Non GBR] AS [consultant].[Total Consultants] - [consultant].[GBR]
SELECT
NON EMPTY
{[VALUES].[Total Billable Hours],[VALUES].[Total Billable Dollars]}
ON COLUMNS ,
NON EMPTY
{
([consultant].[GBR], [Project].[All Projects]),
([consultant].[Non GBR], [Project].[GBR])
}
PROPERTIES [Project].[Project].[Description] ,[consultant].[consultant].[Full Name] ON ROWS
FROM [Timesheets]
WHERE
(
[VERSION].[VERSION].[Actual + Adjustments],
[Currency].[Currency].[Local],
[YEAR].[YEAR].[FY 22/23],
[DAYS].[DAYS].[Oct]
)

Any pointers about how I could include the WITH keyword in Apliqo UX?

Thanks

2

Yes this should be possible by specifying “Full MDX” = true in the cube settings.

image
image441×651 20.8 KB

Once this property is set to true a MDX query window will display and you can paste the query in.

image
image1731×476 35.7 KB

Note that if you want to display a caption or other attribute on the (non-calculated) row or column members rather than the principal name then you would still drag the relevant hierarchies to the correct position on rows/columns in the dialog. The list type would be ignored as the full MDX will be used, only the display attribute will be used.

3

Thanks @cw-ch-scott, that’s perfect.