4 Replies Latest reply: Mar 5, 2013 2:05 AM by user2486753 RSS

    Use of bind variable in repository

    user2486753
      All,

      Our customer has a requirement that they need This year sales Vs Last year Sales by passing the year as a prompt.
      I can not use BI built in function to get Last year start or this year start date as our calendar dates are not standard. So i have to query date dim table to see for ex. for 2010 whats is the start date and so on...

      For this I have created a repository variables to hold these values using a SQL. What I would like to know is can I use a bind variable to this SQL so that when user passes year i can feed that year to this SQL and it will provide me correct start and end date for this year and last year.

      Many thanks in advance