Story built on linked models fails to display fields. Also can a DataAction be created on linked models?
I have two simple models as follows:
PriceModel
Version
Date
Product
Price
Revenue
QuantityModel
Version
Date
Product
Quantity
Both models are defined with a time granularity of year, which is limited to 2022.
I have successfully linked these two models based on matches of the following fields:
Version
Date
Product
Next I want to create a story with the following layout
Columns: Version
Price
Quantity
Revenue
Rows: Product
My story correctly displays correctly displays the following columns:
Product from PriceModel
Price from PriceModel
Quantity from QuantityModel
But my story absolutely refuses to display Revenue from PriceModel, even though Show unbooked data is on for all measures.
Is this a bug, or what is the workaround required to display measure Revenue?
Here are the detailed settings in Builder:
Columns>Accounts>Filter
PriceModel>Price, Revenue
QuantityModel>Quantity
Bonus points question: How can a data action be created for a linked model?
A DataAction requires that a default model be specified, and will not allow the use of a linked model.
So how can I create a DataAction for the following: Revenue = Price * Quantity for each product.