Date dimension from SSAS model not seen as a date in Pyramid
I'm connecting to an SSAS model with a date table. When I put the date column from this table into the filter, it gives me a regular drop down as if the column were a string. Even if I mark it as a date column using an overlay, it still gives me a drop down in the filter. There isn't an option for dates in the filter type.
Other client tools see this as a date. How do I get Pyramid to see it as a date? Thanks.
Here is the table in the SSAS model:
2 replies
-
Hi
It may be designated as a date in your underlying data schema, but as a dimension / hierarchy / attribute in the cube semantic model, there is no concept of a date/time datatype, the date member is a string, which is why in Pyramid it appears as a standard drop down in the filters. Pyramid interacts only with the MDX based SSAS semantic model, not directly with the underlying tables.
For the Calendar functionality in slicers, we rely on underlying SQL functions to derive all the date attributes, so it only works with SQL query based databases, not MDX based query databases like SSAS and SAP BW, as MDX has no concept of a Date type.
Hope that helps.
Ian