You may want to check out Kimballs Data Warehouse Lifecycle (toolkit) books. It sounds like you're wanting to produce a 'stock on hand' type model, where your measures are...

Have you checked out the Distinct Count doco from msdn (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/distinct2.asp) ? It's a little aged but still relevant to AS2K. You may want to seperate out the...

Not quite sure what you mean by generic data source, but if you're refering to the naming of the DS, then yes, following the steps outlined in the Ops guide...

You need to check whether you have anonymous or integrated security on the IIS virtual directory - it owuld appear that your app is attempting to access the report server...

It should be in your samples directory (under the RS installation directory).  Also check out Books On Line, it has descriptions of the samples as well as details on where...

Have you checked your log files for clues as to why the subscription/email is failing?  They're typically found under the install directory.

Brad,

A rough overview of the process is:

1. create the report in VS, test run it etc in VS

2. assuming step1 is all good and ready to go live, within the...

Forgot to emntion, theres also a sample script that publishes the sample reports to the RS server.  You could easily mod this to publish your production reports as a first...

If you're system admins are OK with command line tools, then rs.exe could be the way to go.  The following is straight from the RS BOL.  Type rs.exe into the...

What sort of expression do yuo have for the sort expression e.g. is it VB.net code doing something neat or just simply "sort this field ascending"?

You could try using the filter function with descendants function, so a similar example using foodmart is

SELECT

 {[Measures].[Store Sales]} ON 0,

 Filter(Descendants([Time].[All Time], 3), [Time].CurrentMember.Parent.Name = "Q1" OR [Time].CurrentMember.Parent.Name =...

Hi Matei,

I can't remember if mine is a default install path, but you should be able to find the Foodmart 200.cab file somewhere close to C:\Program Files\Microsoft Analysis Services\Samples . ...

No suprise on the panorama front, and proclarity have always been at or near the top of the heap for AS client tools.  I'm suprised that PPlay doesn't/won't work with...

Hi Canute,

Not sure if my test is replicating what you're trying to achieve but I had no issues getting the views into the Model.  Basic test was (using my sql2k...

you can also make the cube available to Powerplay, for a simple test, go to program files|cognos..|tools|Powerplay Connect.  Change the server type from the remote cognos to msssodbo (or which...