Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    3

    Unanswered: 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.

    Mdx

  2. #2
    Join Date
    May 2004
    Posts
    3
    you can create a count measure. I found out by myself

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •