Creating measures as non-hbi .
Hi, I have a need to have a measure on the alternate hierarchy and not on the main spine of the hierarchy in each local domain. However need to save this at local domain.
Reason: For RDF we need to calculate a lift by department supplier. The partition dimension is by department. However a department can have multiple suppliers. The items within a department are from multiple suppliers. Hence the measure is an HBI. In my batch I need to aggregate lift for the dept/supplier lift based on sku store week promotional sales.
RPAS configuration tool doesn't let me define a measure with HBI intersection to be saved as non-hbi.