This might help.

http://social.technet.microsoft.com/Forums/nl-NL/sharepointadminprevious/thread/be0555e0-0c95-460d-90d6-6f5bdb232226

I'd try the dimension relationships. Make sure that measure group and dimensions have relationship in the dimension usage page.

The secure/best method is to not save the password in config file and use Windows Authorization. If that's not possible, save in the config and restric access to that folder.

Details:...

Hi,

What you're currently doing is called a Type 1 update. This is the most easy of all. Although, instead of updating all columns you can look for only the columns...

Hi there! i would recommend starting from these resources. These are not "live scenarios" you asked for, but learn a topic and practice on your machine. I think that itself...

Look at the remarks section here: http://msdn.microsoft.com/en-us/library/ms184325.aspx

When using ISNULL, check and replacement expressions should be of compatible data types.

Try this, it will give you a start.

SELECT DeptName

, [2001]

, [2002]

, [2003]

, [All]

FROM (

SELECT DeptName

, startyear = isnull(cast(year(StartDate) AS CHAR(4)), 'All')

, Cnt = Count(empid)

FROM StaffHistory

GROUP BY DeptName

, year(StartDate)

WITH rollup

) src

pivot(sum(Cnt)...

Create table. This will be very simple if AMonth is a date column. I made this change.

CREATE TABLE [dbo].[test1](

Ayear smallint NOT NULL ,

AMonth date NOT NULL,

AGroup varchar(3) NOT NULL ,

MonthlyAmt...

Thanks Sturner.

Not tackling this article. I'm extremely sorry for hanging onto this one for a very long time and dropping the ball, Steve!

Did you look at the below link:

http://msdn.microsoft.com/en-us/library/ms153586(v=sql.105).aspx

SSRS reports can be called from a ASP.net application.

If you are asking if SSAS uses tempDB, No. SSAS doesn't use TempDB for querying.

TempDB might be used when source data is processed to SSAS.

There is no way unless you have pre-captured this data. There is SSAS flight recorder, but you may not have any luck there too.

I would suggest enabling SQL profiler trace...

Not an expert advice 🙂

How about a simple star schema with three dimensions: Calendar, Branch, Metrics, and fact table called FactGoals.

Measure in the fact table can be GoalValue.

Add an...

From what i understand, you will have to play with dimension usage and ignoreunrelateddimensions propert of a measure group.

Please try to provide any examples of your cube.

Does the following problem...