I have a requirement where in i need to design a query , which would give the information like whether the employee was present or absent on a given day.
we have a data source ( made from FM ) which satisfies the requirement.
in this data source we have employee,date and availability as fields.
But how could i create a cube with out any key figure?the data source has all the three fields as characteristics! is there any work around for this?