I am using two subject areas one is Receiving - Purchase Receipts Real Time and other is Procurement - Purchasing Real Time. Both subject areas have Order dimension. When I use this dimension from both subject areas in my criteria along with other dimensions and measures the result is not as expected. Receiving - Purchase Receipts Real Time subject area does not have Purchase Order Amount whereas this dimension is available in Procurement - Purchasing Real Time subject area. In my analysis I want to display the Order and its corresponding Purchase Order Amount. Please make a video about this.
I am using two subject areas one is Receiving - Purchase Receipts Real Time and other is Procurement - Purchasing Real Time. Both subject areas have Order dimension. When I use this dimension from both subject areas in my criteria along with other dimensions and measures the result is not as expected. Receiving - Purchase Receipts Real Time subject area does not have Purchase Order Amount whereas this dimension is available in Procurement - Purchasing Real Time subject area. In my analysis I want to display the Order and its corresponding Purchase Order Amount. Please make a video about this.
Thanks for watching! and Thank you for your comment. we'll f/w your query to our technical team
where we can perform cross join, at the time of collecting data/columns from multiple subject areas?