I have Fields TranId,StoreID,negStoreID in my model. The first two are members of the same table and thus connected, whereas negStoreID has no connection (I created it as a data island). If I want to only show TranIds that have a StoreID belonging in the current selections of negStoreID, I have to create a calculated dimension as follows:
aggr(only({<StoreID=P({$<StoreID=negStoreID>} StoreID)>}TranId),TranId)
Let me put the aggr and only out , since my question regards set analysis itself and not the trick on how to use it in the conditional dimension:
{<StoreID=P({$<StoreID=negStoreID>} StoreID)>} TranId
Why does the following not work in its place:
{<StoreID=negStoreID>} StoreID)>} TranId
Everywhere I've searched these forums I've seen the P solution proposed, and since it works, OPs are happy to end it there. But the syntax needed is much more complicated.
If there is an answer to this, please also include the following the exclude version::
{<StoreID-=negStoreID>} StoreID)>} TranId
instead of
aggr(only({<StoreID=E({$<StoreID=negStoreID>} StoreID)>}TranId),TranId)
