September 24, 2009 at 10:48 am
Ok I have a cube.
Dimentions
Time (Year, Quarter, Month)
Customer (Customer Name)
I have a measure that's the number of licenses the customer holds of our software for a given month.
(Number of Licenses)
I have it defined as LastNOnEmpty for the aggregation of the actual measure.
I then clicked on Define business intelligence->Define Semi-additive behavior and clicked next
Under Define semiadditive behavior for individual measures I selected
LastNonEmpty
as the Aggregate function to use.
Except an agency that has 22 users license in January, February, and March shows 66 licenses for Quarter 1.
How do I get it to just use the last value on the roll-ups? I thought that's what LastNonEmpty did.
January 7, 2010 at 8:36 am
OK, I have this kind of problem:
I have DIM_time table in db. I created time dimension to my analysis services (2008) project from that DIM_time db table.
* I have two instances of this dimension in my cube, "Dim_time_registration_date" and "Dim_time_rep".
* To make this example easier, let's assume I have only two measures, payment_sum and open_sum.
Now I want to add following features:
- SUM payment_sum in both dimensions
- SUM open_sum in dim_time_registration_date dimension and in dim_time_rep take the LAST NON EMPTY VALUE.
- On top if this I want to show all months even if there is no data.
Any idea how to implement these? Sounds pretty standard cases for me but as a neebie I can't make this happen in Analysis Services.. :w00t:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply