Skip to main content
M
MXS454
February 17, 2025

Extract of all artifacts-names only

  • February 17, 2025
  • 1 reply
  • 0 views

Hi,

I was wondering if anyone knew how to get an extracted list of all artifacts within an environment by artifact types such as business rules, transformation rules, cube view names.

I am only interested in getting the names/metadata of each artifact and not the actual data from the artifact.

I would like to put these in an excel workbook. 

Thanks!

Manuel

1 reply

V
victortei
February 17, 2025

Hey Manuel,

I don't think there's something out-of-the-box that does all of this. You'll have to play with the app tables.

Here's a sample I have you could leverage to create one that fits your needs:

SELECT 'Cube View' AS ObjectType, Name, Description FROM CubeViewItem UNION ALL
SELECT 'Business Rule' AS ObjectType, Name, '' AS Description  FROM BusinessRule UNION ALL
SELECT 'Confirm Rules' AS ObjectType, RuleName AS Name, '' AS Description FROM ConfirmRules UNION ALL
SELECT 'Dimension Member' AS ObjectType, Member.Name As Name, Dim.Name AS Description FROM Member JOIN Dim ON Member.dimId=Dim.dimId UNION ALL
SELECT 'Transformation Rules' AS ObjectType, StageRuleGroups.RuleGroupName As Name, '' As Description FROM StageRuleGroups

Thanks!

Terms & ConditionsAccessibility statement