Dimension Member Source

Hi - from the design doc  though I bet OS support might be more helpful: Entity Dimension (onestreamcloud.com)

Dimension Properties Tab

These properties are standard across all Dimensions. 

Dimension Type

Identifies the Dimension it currently is such as Account…UD8.

Name

The current name of the Dimension

Description

The current description of the Dimension

Access Group

This security group has access to the Dimension

Maintenance Group

This security group has access and can make changes to the Dimension.

Source Type

Standard

Normal metadata Member must match a Cube.

Business Rule

Connects to a Business Rule so that a set of Members does not have to match a Cube.

XBRL

Connects to an XBRL taxonomy.

Source Path

Enter the Business Rule name or the full File System Path for the XBRL Taxonomy’s Link Definition File.
‘Internal/XBRL/Taxonomies/EntryPoints/….’

Name Value Pairs (e.g., Param1=Value1,…)

Enter a comma-separated list of name-value pairs if the Source Type is a Business Rule or XBRL. 

UP 🙂

Hi all,

trying to find info to get members from a Business Rules, no luck yet (and this post is not really clear)

Can someone details the options "Business Rule" and "XBRL" ? 

If I choose "Business Rule", when it's supposed to be fired ? Which kind of Br<ules should I implement ? May I put it into a Wprkspace's Assembly with the well known syntax (Workspace.<myWS>.WS) ?

Thanks in advance

FabioG

Hi all,

I want to dynamically generate an Entity dimension from existing ones. "Dimension Member Source" appears to be the correct setting, but unlike the UDs, we are limited to the "Business Rule" option. In the documentation, all I could find was:

Source Type: The approach used to specify members for this dimension. For example,

members and relationships for a Standard dimension are created manually using the

Dimension Library Editor or by using XML load. Members and relationships for a Dynamic

dimension can be sourced from external data using a custom implementation in a

WorkspaceAssembly

...

Business Rule: Connects to a businessrule so that a set of members does not have

to match a cube.

The documentation for the business rule types does not provide any notion of which it would be.

Business Rule Types

My best guess would be a Finance BR in the FinanceFunctionType.MemberList section. However, referencing a Finance rule from the source does not enter the Main method of that rule, so I appear to be on the wrong path.

Has anyone successfully implemented a business rule based dimension?