Overview of cubes containing specific dimension

peter-kriebernegg

Hi,

is there somewhere a chance to get an overview when selecting a specific dimension in which cubes this dimension is used?

Questions to be answered can be:

• Is the dimension "dVALTYPE" used in any cube?
• In which cubes is th dimension "dVALTYPE" used?
• In how many cubes is the dimension "dVALTYPE" used?

I know a solution based on the relational Designer database using SQL queries, but in version 12 still looking forward to get something.

Kr,
Peter

0909090854053232.pdf

Robert Thomas

#define EngineVersion 5.0
#define RuntimeVersion 5.0

bool CFO_CubesAndDimensionsToAttachment(string pDataConnectionName, string pCube, bool pGetElements, bool pBaseEleOnly, bool pDebug)
@Description: "Stub to get list of cubes and dimensions";
@Category: "CFO_Utilities";
@Parameter[pDataConnectionName]: "pDataConnectionName";
@Parameter[pCube]: "Cube name or * for all";
@Parameter[pGetElements]: "Get elements of each dimension (true/false)";
@Parameter[pBaseEleOnly]: "Get base elements only (if pGetElements = true) of each dimension (true/false)";
@Parameter[pDebug]: "Logging (true/false)";
@Returns: "StringListList of cubes and dimensions";
{
/* MAINTENANCE LOG
**********************************************************************************************************************************************************************
*
* Date Responsible Description of Change
* ----------- ----------------------------------- ------------------------------------------------------------------------------------------------------------------
* 01/22/2022 Bob Thomas, CFO Solutions Initial Release
* 02/18/2022 Bob Thomas, CFO Solutions Unused variable cleanup
* 03/31/2022 Bob Thomas, CFO Solutions Add cube type to export
**********************************************************************************************************************************************************************
Test parameters
DEPM
*
false
false
true
*/

// Variables
int intLoadNum = ToInt(GetDateTimeAsString(CreateDateTime(), "MMddyyHHmm"));
string strErrorMessage = "";
int intErrorCode = 0;

string sDataConnectionName = StringTrim(pDataConnectionName);

try
{
OLAPConnection ocOLAPConnect = OLAPCreateNamedConnection(sDataConnectionName);

StringArray saExportRows = CreateStringArray();
Append(saExportRows, "Cube,CubeType(A-CubeAcc; D-DimAcc; S-Sys; U-User),Dimension,Element");

foreach (OLAPCube cube in OLAPGetCubeList(ocOLAPConnect))
{
string strCubeName = OLAPGetCubeName(cube);
if (strCubeName == pCube or pCube == "*")
{
string strCubeType = OLAPGetCubeType(cube);

OLAPDimensionList dimensions = OLAPGetDimensionList(cube);
foreach (OLAPDimension dimension in dimensions)
{
if (pGetElements)
{
OLAPElementList olapEleList = OLAPGetElementList(ocOLAPConnect, dimension, pBaseEleOnly);
StringList slOLAPEle = ToStringList(olapEleList);
foreach (string olapEle in slOLAPEle)
{
string sExportExportRow = strCubeName + "," + strCubeType + "," + dimension + "," + olapEle;
Append(saExportRows, sExportExportRow);
}
}
else
{
string sExportExportRow = strCubeName + "," + strCubeType + "," + dimension;
Append(saExportRows, sExportExportRow);
}
}
}
}

RepositoryConnection rc = CreateRepositoryConnectionExisting();
string strAttachmentName = GetCurrentTenantName() + "_CubesDimsElements_" + intLoadNum + ".csv";
string strExportCSV = StringJoin(saExportRows, "
");
string strAttachmentId = RepositoryCreateFile(rc, strAttachmentName, strExportCSV);
RepositoryDisconnect(rc);

NotifyInformation("strAttachmentName: " + strAttachmentName + " created; attachmentId: " + strAttachmentId);

OLAPDisconnect(ocOLAPConnect);
}
catch(strErrorMessage,intErrorCode)
{
NotifyError("Error; the process returned the following message - " + strErrorMessage);
return false;
}

return true;
}

0811181026417683.xls