Adding Transaction Keys in accoMASTERDATA
Transaction Keys allow you to capture the filter context of your Power BI dashboard during writeback, even when those filters are not explicitly shown in your accoMASTERDATA visualization.
Example
The dashboard below has 2 slicers, representing different dimensions:
- Account (Account dimension)
- Year-Month (Date dimension)
By creating a Transaction Key for each of these dimensions and incorporating them into the accoMASTERDATA visualization, the writeback entries will hold information about the filter state of the dimensions.
This ensures that the writeback data can be seamlessly integrated with the Account and Date dimensions of the data model.