DMR View - Retrieve date column without Time dimension

[benji41]

Hello everyone,

I don't have Time Dimension on my FM schema

How can I retrieve a date column from my fact table into my DMR view ?

I would like to use this column in Transformer as a Data Source in order to create a new Time dimension

Thanks a lot !

[cognostechie]

You have to have objects in your Physical/Database View first and then only you can add them to your DMR View. If the query
subject for your Time dimension which points to the Time dimension table in the DB has been deleted, you can create that Query subject again and then use the column from that in the DMR. You will have to be careful here because it should have the same name and proper joins with other query subjects.

[benji41]

Ok thanks a lot