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
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?
I mean View...rather than creating in DB can we create in FM? Thank you
Quote from: cielo on 04 Sep 2019 02:06:36 PM
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.
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.