Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: benji41 on 27 Oct 2014 04:27:38 PM

Title: DMR View - Retrieve date column without Time dimension
Post by: benji41 on 27 Oct 2014 04:27:38 PM
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 !
Title: Re: DMR View - Retrieve date column without Time dimension
Post by: cognostechie on 28 Oct 2014 12:12:46 PM
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.
Title: Re: DMR View - Retrieve date column without Time dimension
Post by: benji41 on 01 Nov 2014 04:33:27 PM
Ok thanks a lot
Text only | Text with Images