You have a table in other database server, lets call in DB1 in ServerA. Then you created a SSAS Solution using BIDS, use DB1 as a data source, created a...

This is what I would do ....

1. Create SSIS package (put all the data flow in one dtsx)

2. Use variable for start date and end date

3. Create a simple form...

I don't really understand what you are trying to do, because you had one row in Dec.

CMIIW ...

When you browse the cube in Time.Year level you want to see...

Question 1

CMIIW ...

For example: You have these members in your hierarchy

Prod A

- Prod AA

- Prod AB

...

You can create a simple code using VS. There is an API called AMO to connect directly to OLAP cube, and using this API you can list down all ...

Hi Cris, thanks for the reply.

I disagree with your statement that planning & budgeting is not highly related to BI. Over the last two years (start from 2007), Microsoft announced...

Since data warehouse is not a mission critical, I completely agree with Ron. Added a FK would not decrease a process at all, because we do it in a batch....

I agree that you should always add a FK in your data warehouse.

My other consideration is that you can always use the benefits of index between FK column in...

Happened to me, on testing environment using SQL Server 2005 Enterprise. Anybody knows how to solve this problem other than re-install? 

1. Grant those users access to the database

use db1

exec sp_grantdbaccess 'user1'

2. Add those users to db_owner fixed database role

use db1

exec sp_addrolemember 'db_owner', 'user1'

Have you tried to installed it manually. Locate the .msi on this folder "C:\Program Files\Microsoft SQL Server\90\Tools\Samples\SQLServerSamples.msi"

I'm sorry. I don't understand what's going on with my server. Suddenly, after I restart my OS, the problem is solved.

Great, I just don't get it. Why this function placed under Aggregate function . I guess I can also use this function in case...

Hi, there

I also experinced the same problem recently. A kind of funny. I have 2 database server, the first one for production and the other one for testing. Both installed Win...

You need to establish SQL Mail first before SQL Server could send an email. Refer to BOL for step by step instruction

But you must make sure that user account used...