Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2002
    Location
    Minneapolis, MN
    Posts
    253

    Unanswered: Qualitative Measures in Analysis Services

    I have a question regarding text measures in AS.

    Here's the scoop:

    T he data I'm dealing with centers around real estate listings. There is one large table with 95,000 rows approximately. Each of the rows represents an individual real estate listing with certain attributes unique to that listing. There are also attributes that are shared by other listings. For example: region code, property type, property category, etc.

    I have created separate tables for each of the "dimensions". I've also created a fact table. Here's the issue: I've created cubes tons of ties and never had a problem when dealing strictly with numeric/empirical data. In this case, however, a lot of the "measures" are text data.

    In short, I want to drill down and display all the property listings given x number of dimensions and specific dimension values I choose. But when the cube is processed, the cube treats everything like it was numeric data.

    I hope I even made a little sense in what I'm asking for!!!!

    I know this can be accomplished just as well using a regular OLTP database, but I'm trying to put together a mini reporting app that will let the non-technical savvy users (a.k.a. management) generate reports and listings by using drill down/pivot tables.

    If anyone has any suggestions or can point me in the right direction, that would be awesome.

    Thanks in advance for any help!!

    Anthony Robinson
    Last edited by ansonee; 01-14-05 at 16:35.
    Anthony Robinson

    "If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."

Posting Permissions

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