Hey Guys,
I am trying to create a report with child tabular model. But I am unable to view the child tabular data in the Insertable object pane of the query explorer.
Let's say I created Parent tabular model in the query with the following queruy items
CompanyId
Employee
these are comming from one Namespace in the model
I created child tabular model with the following query items comming from different name space in the same model .
Child tabular model query items
Company Id
State
I created filter in Main tabular model as follows
[Company ID]=[Tabular Model1].[Company ID]
When I am trying to pull query items in to the query I am unable to view the query items
Company Id
State
in the child tabular model.
I want query items from both the Tabular models
Tabularmodel1(parent)
CompanyId
Employee
Tabular model2(child)
Company Id
State
in the report .
Any one help to solve this issue
Thanks