based on the sample data and structure, not sure why you're not able to query what you need/want.

re: the processing error, have you processed (full) your dimensions first and then...

If you're hand coding the MDX, then make sure you aren't using NON EMPTY at the beginning of your Row axis statement.

depends on which tool you're using to browse. assuming excel, right click in the background of the pivot table, look for PivotTableOptions, go to the Display tab, then look...

You need Team Explorer for VS 2008, and maybe even the update if trying to hit TFS 2010. Have you tried looking under the VIew menu for the...

Little known usage of SSMS, but it'll open XML quite happily. Eithe ruse File|Open or simply have SSMS open, go to Windows Explorer and click|drag the file into SSMS.

You're on target there Dave - always process (refresh preferably) your dimensions first, and your facts (partitions in the measure groups) second. THink of it this way - you...

Have you confirmed that the images still exist, that the paths (on disk) haven't changed?

Unless you have Dundas (external add-on), you can't use dual axis charts in 2005. It was added in 2008.

In debug you'll want to run in 32b mode. In prod, where you dont interactively run BIDS to execute the package, you'll probably want the driver/s running in 64. ...

It's 32-bit only. For written confirmation 😉 , look at the top of this page here.

ahhh, gotcha. Well, you could use predefined MDX, maybe using SSRS still (local reports vs using report server instance). Alternative would be to look at Dundas or equiv...

I would probably lean towards dashboard designer in SharePoint2010 if i had access to it, if I was specifically looking to create dashboards. You could definitely still do this...

I'd probably call that better way a "front end, user tool", and yes there's several. Oftenthe easiest option is Excel, with 2010 giving you a fair amount of functionality. ...

You should be able to specify 2 columns (City and Province/State) as the key "column" for the attribute. In the properites pane, click the ellipses [...] button next to...

Parent has a very specific meaning here, indicating that the Attribute is a parent in a parent-child relationship (also known in DB terms as a self-reference, like an employee table...