Examples of mondrian.test.TestContext.upgradeQuery()

mondrian.test.TestContext.upgradeQuery()

Massages an MDX query to handle differences in unique names betweeen old and new behavior.

The main difference addressed is with level naming. The problem arises when dimension, hierarchy and level have the same name:

In old behavior, the [Gender].[Gender] represents the Gender level, and [Gender].[Gender].[Gender] is invalid.
In new behavior, [Gender].[Gender] represents the Gender hierarchy, and [Gender].[Gender].[Gender].members represents the Gender level.

So, {@code upgradeQuery("[Gender]")} returns"[Gender].[Gender]" for old behavior, "[Gender].[Gender].[Gender]" for new behavior.

@see mondrian.olap.MondrianProperties#SsasCompatibleNaming @param queryString Original query @return Massaged query for backwards compatibility

    {
        String requestType = "EXECUTE";
        Properties props = getDefaultRequestProperties(requestType);
        String requestText = fileToString("request");
        TestContext testContext = TestContext.instance();
        requestText = testContext.upgradeQuery(requestText);
        Document responseDoc = fileToDocument("response", props);


        String connectString = testContext.getConnectString();
        Map<String, String> catalogNameUrls = getCatalogNameUrls(testContext);

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.