Check to see if any of the dimensions have a default value. If the default value is set, but the dimension is otherwise not used, that filter is automatically...

I'm not sure what you're expecting with dimension tables connected to other dimension tables. There are a few times that would be okay, but a good BI solution normally...

Not positive I know what you are asking for here. If you mean can Analysis Service be forced to make the join above the date level, the answer is...

If all the tables were prefixed "tbl" I could see some of these points. But like previous posts indicate, there are other possible prefixes. I think it's awkward,...

I solved this. I had to edit the expression from the data flow overall icon (the one you see when you are looking at the package). I had...

I would appreciate more details. I have tried to use a variable both in a sql statement in the sqlcommand property and even created an entire sql statement within...

I use a char(4) field, but I manually created my own time dimension table, dtblCalendar, to manage my date information.

I recommend you create the new column that you would prefer not to create and have it populated as part of the download process. While such columns are normally...

I would recommend not setting that in the stored procedure because this reduces the possibilities of the return. When the stored proc is called from programming code, the call...

I received the same error installing it on a laptop and trying to use an account that was a SQL Server Admin account.

The problem seemed to be because it was...

Need more information? Are you even able to complete the connection. I found I had to click Test Security in BIDS, and then everything would work. A...

Some of my most rewarding professional days were with Access and VBA and even now sometimes I miss it. You might find you enjoy it. Good luck!

By the way, what you're saying makes sense, but I have often used a data sheet view in the subforms and just hidden the join column. If you're not...

Make sure you don't have any hidden objects.

The subform will also appear as a seperate report in the report window. You need to set the properties of that individual report object, and then it will appear...