Maybe I am not fully understanding this and might need an example of what is in each table, but from the sounds of it you have two dimension tables (Tree...

How are you currently processing the cube? If you are simply using a SQL Agent job with a script you should be able to get the time based on...

You might want to take a look at that project http://ranetuilibraryolap.codeplex.com/[/url] and you could also take a look at what Dundas has to offer. They did have some OLAP...

I would review the prep guide that is available online and take the transcender practice exams before you take the certification test. I have some feedback here in regards...

I do have some feedback on the 70-448 and 70-452 exams here

Quick Feedback on the 71-448 (70-448) Beta Exam ...

Quick Feedback on the 71-452 (70-452) Beta Exam ...

You can get...

This would definitely be a good move and with the DBA background a nice compliment. I might be a tad biased though:) As previously stated I would check out...

What items are currently causing you issues? Once you modify KPIs, Scorecards, Reports, and Data Sources and publish them to the repository these changes will take effect immediately on...

This has finally been resolved in SSRS 2008 R2 "Calculating Aggregates of Aggregates" http://technet.microsoft.com/en-us/library/ms170438(SQL.105).aspx

For the time being you could probably setup a Function in the Code section and then pass...

A little confused with your wording at the beginning about how these tables are related. Maybe you could simplify this and cut out some of the wording or possibly...

You can definitely set the AttributeHierarchyVisible property to False, but you must make sure that any attribute that is part of a user defined hierarchy has the AttributeHierarchyEnabled property to...

Are you using Report Builder 2.0? What exactly are the issues that they are having creating reports? It is fairly straight forward with the SSAS Query Designer. ...

Just curious if you have Attribute relationships defined in the dimensions and if you have designed and setup any aggregations on the measure groups. Typically both of these usually...

Check out this thread in the Microsoft Forums DISTINCT COUNT MEASURE sql 2005 and also take a look at the article in the link - Handling Data Integrity Issues in...

Can you provide an example of what you are referring to? Not sure what you mean by triangle. Sounds like you just might want to use a matrix...

So from the sounds of it you might have three dimension tables and then a factless fact table? The date, status, and employee keys would be placed in a...