In the sales and marketing cube I would like a date field related to the quotations created, currently a date attribute exists for the quotation lines which is not what I need. Here you will need to update the View to add a date field and then expose this in the cube. Below are the settings and steps you need to take, it was not as straight forward as I first thought. I’m using the example on quotations but you can apply this to any cube.
The View is the SmmQuotationView here you need to add a new date to the field list, I have used the CreatedDateTime of the SalesQuotationTable, no steps for this just do it!
Once added you can configure the date attribute in the perspective
Step 1 IMPORTANT, you need to change the analysis type of the View to Transaction.
Step 2 configure the date to be an attribute as follows
Step 3 Update the cube structure using the SQL Server Analysis Services project wizard.
What you can expect to see is a separate date attribute for the Quotation created date that is linked to the date heirarchies