RE: MDX Get most recent with time dimension

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks - I thought of this solution and it will work, its just not ideal
because we don't know the last entry until some time after the last entry is
added to the fact table - tracking is continuous in our application. This
means we need to run a batch process every so often to mark the last entry
with 1 so it can be counted in the cube.

I was just hoping there would be a more dynamic solution without having to
schedule a TSQL batch.

Does anyone know if a TOPCOUNT of 1 will work? Or if I get the MAX(time_id)
from my fact table?

Have a super evening!

Rich



"Rea" wrote:

Hey Rich
The natural place for your task seems to be a calculated field
you would do, on your facts, prior to your olap cube.
I can't see a reasonable and efficient way MDX could handle this kind of
task (it will need to search online the whole cube for every customer..).

Instead, You would mark for each customer his last record
by writting 1 in some field.
Then in your cube do a simple measure that sums up these values.

Are there any reasons you are thinking of using MDX instead??

Hope this helps!

Rea



"Rich" wrote:

Good day all!

I have a simple tracking cube with one fact table and three dimensions:
Customer, Tracking, and Time (granular to the second).

I am trying to formulate an MDX query to return a count for Tracking
dropoffs - which would be the equivalent of the last entry for each Customer
in the fact table, or the maximum Time reached by each Customer in the fact
table.

I would like to show each non-empty Tracking member with a count of how many
Customers dropped off for that item.

I'm not sure how to approach this - any help would be appreciated. Thanks
and have a super weekend!

Cheers,
Rich
.

Relevant Pages

  • Re: Filter address book on PR_EMS_AB_HOME_MDB
    ... row at a time from the addressbook, and doing a seek past the one which ... > Guess I'll have to bring my laptop to the customer and do some live ... > My two other options so far seems to be one entry at a time with SeekRow ...
    (microsoft.public.win32.programmer.messaging)
  • Re: Adding a new entry to a linked table
    ... select Tools | References from the menu. ... Doug Steele, Microsoft Access MVP ... When I try and add a new entry I get this error from ... >>>I have an order entry form that has a field for the customer name. ...
    (microsoft.public.access.forms)
  • RE: How do I build a customer search?
    ... you will get the entry you selected. ... Dave Hargis, Microsoft Access MVP ... I have four things, Customer ID, First, Last, Business name(some customers ... clear button and it would clear the fields in the form heading and you would ...
    (microsoft.public.access.formscoding)
  • Re: Problems with Tesco
    ... can finish serving them. ... At which point does the customer become such, ... It's not Alex who makes the rules, it's the law. ... So if it doesn't matter to *start* being a customer, preventing entry ...
    (uk.legal)
  • Re: Question on recent PHP VuXML info
    ... dead given the last update was in 2007 according to the archives. ... We were previously tracking this entry, which pretty much sat for a while ... considered to be serious by the FreeBSD Security Team, ...
    (FreeBSD-Security)