Named query as a pivot

Hello,

Is it possible to create a named query in the DSV that is the result of a pivot (e.g. cross tab?). The number of columns as a result of the pivot are based the number of records in one of the driving tables - in other words, it is not fixed.

You got to go dynamic SQL and use some fancy report datasets and expressions to display or not the columns.

Then you would have to create a report were you define as many columns as possible and control the visibility of these columns based on some expression stored in the Column Visibity hidden property.

Lot of work. May be you would be better off sourcing your report out of a cube.

Philippe

Named query as a pivot

Hello,

Is it possible to create a named query in the DSV that is the result of a pivot (e.g. cross tab?). The number of columns as a result of the pivot are based the number of records in one of the driving tables - in other words, it is not fixed.

You got to go dynamic SQL and use some fancy report datasets and expressions to display or not the columns.

Then you would have to create a report were you define as many columns as possible and control the visibility of these columns based on some expression stored in the Column Visibity hidden property.

Lot of work. May be you would be better off sourcing your report out of a cube.

Philippe

My view is timing out

What could be the reason for my view to timeout? I thought it was because of the number or records, but i guessed wrong. The view is grabbing data from a UDF i have created.You still doing that?

See, now there's no reason to use the udf...