Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
gmenoutis
Partner - Creator II
Partner - Creator II

Field=field set analysis does not work

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)

1 Solution

Accepted Solutions
gmenoutis
Partner - Creator II
Partner - Creator II
Author

alright, I was missing a { . Can a mod please delete this

View solution in original post

4 Replies
gmenoutis
Partner - Creator II
Partner - Creator II
Author

alright, I was missing a { . Can a mod please delete this

felipedl
Partner - Specialist III
Partner - Specialist III

Hi George,

You can delete the post on the right side, there's a "Delete" button under "Actions".

gmenoutis
Partner - Creator II
Partner - Creator II
Author

If I try, I get a white page saying Unauthorized in big letters and much technical jargon in small.

isingh30
Specialist
Specialist

Can you share you data or sample application?

Thanks