Derived table?

[cielo]

Can we create a derived table in FM? I am aware we have option to create SQL in Report studio..would like to know do we have same option in FM?Thanks

[dougp]

You mean like this?  https://www.wiseowl.co.uk/blog/s360/sql-derived-tables.htm

Basically, everything is a derived table in FM.  What's the real question?

[cielo]

I mean View...rather than creating in DB can we create in FM? Thank you

[MFGF]

I mean View...rather than creating in DB can we create in FM? Thank you

This sounds to me like a model query subject in FM?

MF.

[dougp]

Sure that could be a model query subject (based on other query subjects in the model) or a data source query subject (just copy from another one and change the SQL to what you need).

But I'm still confused about the actual need.  SSRS is not a modeling tool -- it's a reporting tool.  It doesn't relate to FM.