Cube Tips |
Top Previous Next |
Tip Number 1: Did you know that you can right mouse click on a column field in Analytics, and create a custom filter, without clicking on the dropdown to be selective for multiple options? In this scenario, you can choose dates between a certain period.
Tip Number 2: There is an exception to using Tip Number 1. If you write a custom cube for Analytics that uses a date/time stamp field that is automatically populated by the system, and you want to use this date as a filter in Analytics, you will need to add a Convert( fieldname,sql_date) command to the field so that it can be filtered..
Example: In the example above, COR documents are automatically populated with an Origination Date. This field is technically a date/time stamp field although you don't see the time stamp.
To get around this, use the following SQL logic:
Original field from list: vw_PROJMGMT_YourCompanyConnection_XX.OriginationDate
Use the following instead: Convert(vw_PROJMGMT_YourCompanyConnect_XX.OriginationDate, sql_date) As "'COR Date",
|