I read the following regarding adding a measure for counting the number of days:
The trick is to create new measure group, which will have only one dimension - Time, and a measure with Aggregation Type
'Count' bound to the Day attribute of Time dimension (or any other attribute if we need to count something different from days). The most important setting on this new measure group is to leave IgnoreUnrelatedDimensions=true - this will allow to use this measure
across any other dimension in the cube.
Howerver, this solution assumes that one has a time dimension based on a table in the datasource. I have a Time dimension that created was by the BIDS wizard that is not in my source database but appearantly invisibly hidden on the AS server without direct
access to it. (If I try to add a new measure group (as needed according to the post above) then I can only choose from tables that have nothing to do with time).
Can somebody explain how I can do this without a specific timetable in my datasource?
Do I need to add a timetable just for this purpose? Can it be stand-alone or do I need to add a relationship with all current tables that have date-columns in them?
(I am a finance manager that is building a sales cube based on Navision 3.6, which is already working quite nicely, but still very much a newby)
View Complete Post