Dynamic Measure?

Hi,
I am newbie in Analysis services. My problem is that I have to show a yearly report for credit expiry. In my fact table the measure is credit rate.
I have attributes of start_day_key and end_day_key. Now when I go through analysis services it does not let me create a measure so that I can count end_day_key for a year (end_day_key is linked to day table with daykey. It has date) and show. The thing is the measure I want is not stored (i.e: the count of end days for a year ). How do I go about it?

Should I create a calculated cell? (I tried that, but mdx does not work)
I used : Count({[Measures].[End Key]})< 366
Now this is not wha I want, I want the end_key count by matching date in day dimension for the current year? Any help is greatly appreciated.

Mdxyou can create a count measure. I found out by myself

Dynamic Dimension Buckets

Hi,

I have a measure [count of bookings] and dimensions for [trucking company], [calendar], [booking type]. I need to create a dimension for buckets based on the count of bookings.

The buckets I need to create are ([> 500],[201 - 500],[101 - 200],[51 - 100],[21 - 50],[11 - 20],[1 - 10]) based on the count of bookings. From this dimension I am hoping to create a measure that will show the count of trucking companies in each group (using the calendar dimension), and I am hoping to use the existing count of bookings measure to see how many bookings fall into each category by trucking company.

Eg. For the [> 500] member there may be 1 trucking company, with 857 bookings, 666 bookings that are of a specific booking type in the a specific month. I also will be creating % of measures for these.

I've been able to create a member but I can't get it to show anything but #value. I've used this expression:

filter([trucking company],[count of bookings] > 500)

Any help is really appreciated.

Take a look a creating new attribute in your bookings dimension and then use combination of DiscretizationMetod and DiscretizationBucketCount property to tell server to create groups of members.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

What do I create the attribute from? Because I need the grouping based on the count of bookings (which is the count of rows in my fact table) I can't just create buckets based on a number (like age in the examples I've seen). And I can't see anywhere within the dimension attribute properties that I can specifiy that I want to use the count of a particular column.

And because I want it to return different results for the count of trucking companies etc when sliced by this new attribute and the time dimension I can't create a view to base the attribute on (at least I don't see how I would do that).