Skip to Content
0
Former Member
Apr 21, 2010 at 02:55 PM

Date Prompt through not resolved in webi on OLAP Universe

50 Views

Hi,

I am using BO XI 3.1 with latest fix pack.

I have created a OLAP universe based on SSAS 2005 Multicube for reporting using WebI

I have Date field in my SSAS cube and i created a universe based on that cube , but my Date field changed to Character in the Universe Layer.

My requirement is that i need to create a a prompt over that field in the webi report using a CALENDAR to enter the value instead of entering the value manually.

I changed the type of field for the date field from CHARACTER to DATE in the OLAP Universe level and exported it in order to see the calendar prompt ( as the calendar component is visible for the data type of DATE) .

This conversion don't seems to work for me due to the conversion from Char to Date even if i have the data for particular date i cannot see the records but if manually type the value for that same date without converting the Date format to type Date.

I also tried the MDX stuff and created :

<OPTIONAL><FILTER KEY="[PERIOD SD].[DB Full Date].[DB Full Date]"><CONDITION OPERATORCONDITION="Equal"><CONSTANT TECH_NAME="format"@Prompt('Enter Date ','A',,,{1/1/2009})"></CONSTANT></CONDITION></FILTER></OPTIONAL>

but problem is still the same .

So can you suggest about unusual behavior of the Universe Layer.

Kindly suggest .

Regards,

Vibhav