I have created a dashboard on a universe where i have 15 suppliers. For those 15 suppliers who are existing for whole year i calculate the baseline by 12 since they are present for the whole year which is working fine.
If i have a new supplier coming in the month of june baseline should be for this supplier value divided by 12 multiplied by 6.
I have created a view in the database which gets these values into the universe through a table.
New supplier will be dynamic a supplier might join in June and another might join in April it should be automatically taken in the dashboard.
Have anyone implemented such a concept, any ideas on how to implement this in dashboards.
If your suppliers are records in a supplier dimension in a data warehouse then you could use the insert date on the record to determine when the record was added and apply it to a rule that determines how many months to use as a multiplier. The same principle works if you have a supplier start date or a first inserted date from the source application.
if start date is less than start of current year then 12 else
months(start date - start of current year)
So a supplier with an insert date of 31/01/2012 would default to 12 and a supplier with an insert date of 30/06/2013 would default to 6.
This is what i was looking for but this needs to be implemented in universe right? right now i have a derived table in universe which have all details.
I have to create a variable which determines the period from when the supplier is existing correct me if i was wrong
(BOB member since 2006-05-11)
(BOB member since 2013-03-20)