none
Report Calendar Parameters to Dimension

    Question

  • Hello to all... I have a problem, I would like to create a report with parameterssuch asthecalendar, the reportconnects to acubewith the dimensiondate(YYYY-MM-DD), how can Ido?

    thanks

    Ciao a tutti... ho un problema, vorrei creare un report con il calendario come parametri, il report si connette ad un cubo con la dimensione data (YYYY-MM-DD), come posso fare?

    Grazie

    Sunday, December 29, 2013 9:51 PM

All replies

  • Hi Grazie,

    In SQL Server Reporting Services (SSRS), if we want to add a calendar parameter in the report, we can add a date type parameter with no Available Values.

    Please refer to the following steps:
    1. Right click Parameter icon in the left pane, select “Add Parameter”.
    2. Select “Date/Time” option below “Data type” in the Report Parameter Properties dialog box.
    3. Click OK.

    There is an article about Adding Parameters to Filter Reports by Date, you can refer to it.

    If you have any questions, please feel free to let me know.

    Regards,
    Alisa Tang


    Alisa Tang
    TechNet Community Support

    Monday, December 30, 2013 12:33 PM
  • Thanks for the reply,butt he database is a analisys services cube,and the articlestartsfromasqldatabase.only thesamesteps?

    thanks

    Grazie della risposta, pero il database è un analisys services cube,e l'articolo parta di un sql database. i passi solo i stessi?

    Grazie

    Monday, December 30, 2013 4:38 PM
  • I followed these steps.

    in query designe, I put the DATA field as a filter and parametric, after which I changed the parameter is generated automatically as date / time and put no value in(available values​​anddefault values),I created a newparameter calledStartDataandvalues​​predificinitiI putthisistrizione

    =CDate(format(Parameters!PASTIDATA.Value,"yyyy-MM-dd"))

    thenthe parameters of thereportoI changed thevaluein @@pastidataStartData.

    Runthe reportand outthis error

    "ssrstherestrictionsImposedby theconstrainedflag in theStrToSetfunctionwereViolated"

    Help

    Ho seguito questi passi.

    in query designe, ho messo campo DATA come filtro e parametrico, dopo di che ho cambiato il parametro che mi viene generato in automatico come data/ora e messo nessun valore in (valori disponibili e valori predefiniti), ho creato un nuovo parametro chiamato startdata e in valori predificiniti ho messo questa istrizione

    =CDate(format(Parameters!PASTIDATA.Value,"yyyy-MM-dd"))

    poi nei parametri del reporto ho cambiato il valore @pastidata in @startdata.

    esegui il report ed esce questo errore

    "ssrs the restrictions imposed by the constrained flag in the strtoset function were violated"

    Help

    Monday, December 30, 2013 5:08 PM
  • MDX

     SELECT NON EMPTY { [Measures].[QUANTITA] } ON COLUMNS, NON EMPTY { ([PASTI].[REPARTO].[REPARTO].ALLMEMBERS * [PASTI].[SERVIZIO].[SERVIZIO].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOMEMBER(@FromPASTIDATA, CONSTRAINED) : STRTOMEMBER(@ToPASTIDATA, CONSTRAINED) ) ON COLUMNS FROM [Pasti]) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

     PARAMETERS startdata "[PASTI].[DATA].&[" + Format(CDate(Parameters!FromPASTIDATA.Value),"yyyy-MM-ddT00:00:00.000") +"]"

    enddata "[PASTI].[DATA].&[" + Format(CDate(Parameters!ToPASTIDATA.Value),"yyyy-MM-ddT00:00:00.000") +"]"

    error Query (1,236) the restrictions imposed by the constrained flag in the strtomember function were violated.

    Tuesday, December 31, 2013 8:24 AM