Dev edition should be no problem (it's basically Enterprise but without the license to run it in PROD). I would check the SP level of the local install (client)...

depends a little on how you're populating your fact, but assuming for the moment you're using straight TSQL to move data from some staging area to the fact, then you...

re: the excel connectivity, one thing to make sure of is to have the same service pack level on the client as is installed on the server.

re: the...

Hey Sam,

Any hints on what you want the output to look like? Based on what you've written, is it really necessary to get the 'active' date if what you're...

Just out of interest, if you're using Excel 2007 pivot tables, have you made sure that the option 'Show calculated members from OLAP server' is checked? In case you're...

I'll say upfront, I haven't looked in to the Change Data Capture that's in SQL 2K8 but if you're running that version, you may well want to look in to...

And this isn't running on a 64bit box? We've hit issues before with the provider, needing to not execute under 64bit 🙁

Here's the 2k5 instructions...

Did you try defining a parent-child hierarchy in the dimension itself? (ie ignore the table self-reference, simply set it up in the dim in the AS database).

These are the...

You can definitely create a cube (or cubes) via code and this approach allows you to create all of the required objects (e.g. datasource, DSV, dimensions, cubes, KPI's etc etc)....

looks like you already got there 🙂

and you've tried text stream [DT_TEXT] instead of string?

two questions

- have you gone in to the advanced settings of the flat file connector and made sure that the length for the input field is long enough (...

I think Bill Pearson has this covered. Look at tutorial #35 (scroll down, it's in the Msft Reporting Services Series of Tutorials).

List of his articles and tutes here

HTH,

Assuming AS2005/8 you don't need multiple cubes, simply use multiple fact tables (Measure Groups) and join from the facts to associated dimensions at the appropriate level (e.g. Plan may join...