Skip to Content
1
Jun 09, 2022 at 12:30 PM

​Story built on linked models fails to display fields

87 Views

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.