Filtering data from FDMEE with Essbase as source based upon UDA
Hi,
FDMEE version 11.1.2.4.210.
Essbase version 11.1.2.4.005
We are in using Essbase ASO application as source in FDMEE. We are able to extract required data as needed. We are also able to use substitution variable during extraction. However we are unable to extract data based upon UDA.
For example, we have a Product hierarchy with few members tagged as UDA "xyz". I want to extract all xyz UDA member. I am able to write a MDX query for extracting this as "{ UDA([Product], "xyz") }". But FDMEE does not let me provide any UDA in source filter option.
How do I filter data based upon UDA during extraction using FDMEE?