Greetings!
The Application has the dimensions - Accounts, Years, Period, Scenario, Department, ProductLine, Organization, Curr, Facts.
The company management wants to do the alternate analysis by checking the Sales of the Products which are categorized as Product & Services.
The Product Dimension Level 0 members are tagged as UDA of Product & Services. It is instructed to create two members - External Sales (Product) and External Sales (Services) in the FACTS Dimension. When queried for External Sales (Product), it should return all the sales value of the Products of type Product. Similarly, when queried for External Sales (Services), it should return all the sales value of the products tagged of type "Services".
The following member formula is associated with the External Sales (Product):
@SUM(@UDA(ProdLine, "Product")->"External Sales");
The above formula returns a value but its incorrect.
Any assistance in resolving the issue would be of great help.