Hello Community,
It's possible to query the transaction log like this:
.../v1/TransactionLogEntries?$orderby=TimeStamp asc&$filter=(TimeStamp ge 2022-01-01T00:00:00Z) and (Cube eq 'My Cube') and (Tuple/any(t: t eq 'My Cost Center'))&$top=10
This returns top 10 transaction log results, sorted in ascending order by TimeStamp, where TimeStamp is at/after Jan 1, 2022 0:00, from cube [My Cube], where one of the elements of the tuple (i.e. one of the cells that defines the result) is [My Cost Center].
100% clear to me, and works in nearly all use cases.
What happens if the members have identical names across dimensions?
May be the case if the dimensionality is to use Boolean indicators, i.e. true/false.
Therefore tuple can be something like
["true","true","true","false","false"]
If I filter on 'true', it'll match any record that has any 'true' element.
But what if I would like to only test the 3rd element in the above tuple?
How can I filter based on the name of the dimension, hierarchy?
Thank you!
CC to
@Hubert Heijkers
------------------------------
Adam
------------------------------
#PlanningAnalyticswithWatson