DMX Query

Hi,

I am having a DMX Query as follows.

SELECT [Englishproductname],( SELECT $TIME, [Profit], PredictVariance([Profit]) FROM PredictTimeSeries([Profit],5)) FROM [ProductSales_Forecast]

It displays as
English productname and the Expression as columns.
The expression consists of time, profit as nested one.

I need to have no nested queries.
I want englishproductname to repeat for all the columns inside the expressions.
I don't want to display as expressions.
Repeatation is not a problem for me.

Plz help in this regard.

Tx in advance

Have you tried :

SELECT FLATTENED [Englishproductname],( SELECT $TIME, [Profit], PredictVariance([Profit]) FROM PredictTimeSeries([Profit],5)) FROM [ProductSales_Forecast]

If I understand correctly your requirements, this should do it

thanks