I am using SAP BO 4.1 SP7 with an OLAP connection created in IDT to a MS SSAS Model.
In the model there is a Date dimension that has a FullDate field which contains the full date. see attached picture of the IDT and the sample values contained in the FullDate field.
In SSAS the FullDate field is a date datatype, but IDT sets it as string (as per the attachment).
In Web Intelligence, if I set a prompt on the FullDate field it doesn’t show the “calendar selector” to choose the date but it handles it as a string field (see attachment).
How do I tell SAP BO that the FullDate field is a date field and to handle it consequently? With “calendar” prompts, correct date sorting, etc.?
Using Excel to analyze the SSAS model everything works fine as the FullDate field is handled as a date datatype.