No statements in dimensions tree but can be seen in overview of Azure SQL PI 6.3 (4374511)

There are no statements shown in Azure PI dimension tree but the statements can be seen in the top SQL overview of the 6.3 Azure SQL cartridge.

WORKAROUND

replace the script “addChildren“ content located

1. Navigate to Configuration | Definitions
2. In the Definitions panel, choose Databases | Azure
3. Choose Functions in the bottom panel
4. Search for addChildren
5. Click the AddChildren script that is found
6. Edit the function in the left panel by clicking the Edit button (the Foglight user requires the Cartridge Developer role to edit the function)
7. Remove and backup the original function code
8. Paste in the code below
9. Click the Save button
    

/**
 * This software is confidential. Quest Software Inc., or one of its subsidiaries, has supplied this software to you
 * under terms of a license agreement, nondisclosure agreement or both.
 *
 * You may not copy, disclose, or use this software except in accordance with those terms.
 *
 * Copyright 2023 Quest Software Inc. ALL RIGHTS RESERVED.
 *
 * QUEST SOFTWARE INC. MAKES NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY OF THE SOFTWARE, EITHER EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE,
 * OR NON-INFRINGEMENT. QUEST SOFTWARE SHALL NOT BE LIABLE FOR ANY DAMAGES SUFFERED BY LICENSEE AS A RESULT OF USING,
 * MODIFYING OR DISTRIBUTING THIS SOFTWARE OR ITS DERIVATIVES.
 */

package system._dbwc_azure_azure20pi.scripts;

import com.quest.fdb.spi.presentation.adapter.foglight.FoglightPerformanceAdapter;
import com.quest.fdb.spi.presentation.adapter.foglight.model.NodeType;
import com.quest.fdb.spi.presentation.context.ui.UIContext;
import com.quest.fdb.spi.presentation.constants.StringConstants;

/** Add children tree node to parent
  @param azurePIContext - the ui type
  @param parentNode - the parent tree item
  @return list of children node
**/

LOGGER = com.quest.qsi.fason.framework.fmslogger.LogFactory.getLogForWCF(functionHelper.getFunctionId());

LOGGER.debug("Azure API test - enter add children ");

def children = [];
FoglightPerformanceAdapter foglightAdapter = new FoglightPerformanceAdapter();
def uiContext = new UIContext();
functionHelper.invokeFunction('system:dbwc_azure_azure20pi.createUIContext', azurePIContext, parentNode, uiContext);
uiContext.setTop(azurePIContext?.top);
def nodes = foglightAdapter.getChildren(uiContext);

if (nodes?.size() > 0) {
	def nameAndChilMap = buildExistingChildrenMap(parentNode);
	LOGGER.debug( "beign to print node ===================");
	nodes?.each {node -> 
		def existingChild = nameAndChilMap.get(node.getName());
		LOGGER.debug("uniqueId => ${node.getUniqueId()} \n displayName => ${node.getDisplayName()}\n nodeType => ${node.getNodeType()}\n");
		children.add(createOrUpdateTreeItem(parentNode, node, existingChild));
	}
	LOGGER.debug("Stop to print node ===================");
	parentNode.set("children", children);
} else {
	parentNode.set("children", []);
}

return children;


def createOrUpdateTreeItem(parentNode, node, existingChild) {

	def childrenNode = existingChild;
	if (childrenNode == null ) {
		childrenNode = functionHelper.createDataObject("dbwc_azure_azure20pi:AzurePITreeItem", 'none', null);
	}
	childrenNode.set('parent', parentNode);
	childrenNode.set('displayName', node.getDisplayName());
	childrenNode.set('itemValue', node.getName());
	childrenNode.set('itemType', node?.getNodeType()?.toString());
	childrenNode.set('baselineDisplayed', (parentNode.get("parent") == null));
	childrenNode.set('itemUniqueId', node.getUniqueId());
	childrenNode.set('iconLabel', getIconLabel(node, childrenNode));
	childrenNode.set("fullText", node?.getProperty(StringConstants.FULL_TEXT));
	childrenNode.set("batchName", node?.getProperty(StringConstants.BATCH_NAME));
	return childrenNode;
}

def getIconLabel(node, treeItem) {
	def iconLabel = null;
	if (node?.getNodeType() == NodeType.DIMENSION_NODE) {
		iconLabel = treeItem?.displayName;
	} else if(node?.getNodeType() == NodeType.VALUE_NODE) {
		iconLabel = treeItem?.parent?.displayName;
	}
	return iconLabel;
}

def buildExistingChildrenMap(parentNode) {
	def nameAndChilMap = [:];
	parentNode?.children?.each { child -> 
		nameAndChilMap.put(child?.itemValue, child);
	}
	return nameAndChilMap;
}

STATUS

This issue has been logged as defect FOG-7853 and has been fixed in the 7.2 release of the Azure SQL cartridge.