Great, that worked a treat. Thanks!

Sam

I can virtually use Bill's formula, which is great. The formula I have is:

Avg (LastPeriods (3, [Time].[FiscalMonth].CurrentMember), [Measures].[Cc Matl Cost])

Note that my Time dimension has four hierarchies: fiscal week/month...

Thanks Steve, I should've checked there first. Looks like I'll be able to work it out from there.

Thanks James,

I've come up with the following code:

CREATE VIEW VwHistoryCostPopulator AS

SELECT TOP 100 PERCENT list.item_id,

1 AS trxtype_id,

1 AS reftype_id,

list.time_id AS trx_date_id,

0 AS quantity,

-- repeat about 10 times for relevant different...

I've come up with the following code to give me the maximum cost for each day where transactions exist:

SELECT MAX(inv_trx_id),

item_id,

trx_date_id,

MAX(sc_total)

FROM FactInventoryTrx

GROUP BY item_id, trx_date_id

ORDER BY item_id, trx_date_id

Is this useful to...

Hi Jack,

I've just tried both of those and got the same error. My entire function is here, if it helps:

---------------

Public Shared Function PcDiff(LastYear As Single, ThisYear As Single) As...

There is a query builder in SSRS 2005 which makes things a lot easier. As long as you don't need anything too technical, you can get by without MDX....

Hi Steve,

I am using SSRS and created a named set in SSAS. I created a non-queried list of values for my parameter and pointed one of them to my...

Hmmm, I spoke too soon. While that function does what I asked for, I realise I asked for the wrong thing.

The MDX for my KeyAccounts calculated member is as...

Perfect, and so logical! Thanks for that

We've tried using Crystal Reports (v9 - v11) and had no end of problems with it (though we haven't tried Business Objects). SSRS has proven to be much more...

Are you excluding anything from the totals? The aggregates coming from Analysis Services are already aggregrated and are only for the full amounts. I don't actually know the...

I'm interested in how to do this as well. I'll try and help out, but I don't know a lot about this.

There's perhaps four parts to this:

1. Getting the...

Hi Wendy,

There's a few reasons why this could happen, but it sounds like there might be some kind of sender verification happening. Can you first check that the "from"...

I started out using matrices but soon found that tables are far more flexible. Have you tried using a table instead? You can then add a column and...