I'm using Cube.

My DimDate tables Datekey is integer .

But client wants a calendar to set date as you see in picture .

Now I need assistance how can I change calendar  value  which will be input by user .

Now report shows error message, solution pls. ?

Hi Wasi,

you can still achieve what you want using the steps below. These assume existence of two parameters:

• Date (user input from SSRS date control)
• ConvertedDate (integer representing converted Date value)

Steps

1. Set the ConvertedDate Data Type to Integer and parameter visibility to Internal 

2. Set the ConvertedDate default value to Specify Values using expression:

   =CInt(Format(Parameters!Date.Value, "yyMMdd"))

   

3. ConvertedDate parameter value can now be passed to stored procedure. Sample report output with Date selection and ConvertedDate value: