Dimension Attribute/Join question

Hi, I'm having a problem and I wonder if I could get some ideas from
the crowd. I'm working with a database table that looks something like
this:

Event_Id - Event_SubId - Type - String - Value
1 - 1 - SalesMan - Bob - NULL
1 - 2 - Sales - NULL - 12
1 - 3 - Refunds - NULL - 6
2 - 1 - Salesman - Jim - NULL
2 - 2 - Sales - NULL - 16
2 - 3 - Refunds - NULL - 8
3 - 1 - Salesman - Fred - NULL
3 - 2 - Sales - NULL - 11
3 - 3 - Refunds - NULL - 5

Now designing the cube so sales & refunds are aggregated is no
problem, but assigning the correct salesman is tricky. My current
approach has been to create a parallel dimension using a pseudo-key
of the Event_Id and Event_SubId joined, then use that to put the
salesman against his sales & refunds. This works, but the problem with
this approach is it's very slow to process.

The other problem is that the 'Salesman' type object is not guaranteed
to be the first item listed, there are items that could apppear above
it. However, in each instance of Event_Id & Event_SubId it will only
appear once.

I'd be grateful for any suggestions or pointers.

Many thanks - Meff.

.

Relevant Pages

  • Database and java.sql.SQLException Questions
    ... recently wrote to work with this database that have to do with Salesmen. ... Salesman, Sales, Product). ... static String salesmanname; ...
    (comp.lang.java.databases)
  • Re: SQL Server - Access synchronization
    ... salesman is pretty apt. ... database, or they can create a new Access database but that ... Users can add/edit via the web interface, ... > Apply all updates>= last connection, ...
    (comp.databases.ms-sqlserver)
  • Re: And Now - The Rest of the Story
    ... technical but they are professional salesman. ... The one guy didn't know too much about machines, ... Told the customers whatever they wanted to hear. ... On potential sales where he did ...
    (alt.machines.cnc)
  • Writing to a file and a TextArea
    ... They would then hit the Salesman Entry Done ... hit Grand Total and the grand total of those sales will display in the text ... public static void main (String args) ...
    (comp.lang.java.gui)
  • Re: And Now - The Rest of the Story
    ... The two best machine tool salesman I know aren't very ... The one guy didn't know too much about machines, ... Told the customers whatever they wanted to hear. ... On potential sales where he did ...
    (alt.machines.cnc)