The price of fame

glyph

There is a forum for "Integration Services" under the heading Data Wareshouse....further down the page than this forum and heading.

There are 2 basic approaches you can take with inferred members in your fact table.

1. Use a generic "Unknown" reference to your dimension. If your dimension has surrogate keys...

Eutopia

Accidentally

I would do this in one dataset with a UNION between the data. I would expect you can use an open query or four part naming to get access...

Kevlar

Why not add the lookup key to your matirx?

My guess would be that the security instance the SQL Agent is running under on DB04 does not have permission to access DB03. I would further guess that DENVER\PRODDB04$...

There are several different versions of AdventureWorks that you may have the wrong version installed. Double check the version you are supposed to be using and make sure that...

You can get rid of the formatting that adds the comma, or just widen your column.

I don't think you can directly control the type of chart with an expressions.

However what you should be able to do is put several different charts in your report and...

Luck is when opportunity meets preparation.

To me your expression for Changed looks correct. Just route that output to an update routine in an OLEDB command, or if your datasets are really large route it...