You could make a UDF that contains the logic and then use it inline. Primary contents would be

DECLARE

@jDate INT,

@jBase INT

SET @jBase = 998799780 -- 1900-01-01

SET @jDate = 1056915413...

Sabarinathan,

(Assuming you want to optimize the querying experience) In short, you need to ensure you have:

- attribute relationships set up correctly in your dimensions

- partitioning where appropriate

- aggregations on partitions...

The data directories are impacted by the usual things (version of SSAS, whether you're using instance and whether you changed them from their defaults), but as an example, my local...

Ok, sounds like you're interested just in adding custom code to your reports. I believe it's VB 2008, not VBA. MSDN has a section using code here.

Billy,

If you can expand a little on *why* you want to write code for this project, it might help us point you towards where to look as there are several...

Sorta sounds like a Crystal Reports requirement being pushed at SSRS....

It's a litttle hard to tell exactly what you're trying to achieve but you *might* be able to get what...

I would argue that there is a much larger advantage but it is relevant only when the data is to...

What sort of features are you looking to compare? Purely the OLAP side, or into things like reporting (for Microsoft it's SSRS for Cognos its [insert suite name here,...

Put simply, if you want to be able to access the machines 'in the office' you need to be on the same network - so you either drive in, sit...

Stewart is right, I regularly connect to the office domain using a VPN connection and work will all of the mentioned services and more.

Keep in mind that to connect using...

It's obviously not set up specifically for your particular rules but if you have 2008, there was a new Data Profiling task added - have you tried to run this...

It replaces the object/reference within the DSV, not the actual base view/table. Using a named query like

SELECT fieldA, fieldB FROM TableA WHERE Field3 = 'ABC'

is the equivalent of...

To do 'exactly' what you want, you need to use a Named Query rather than a calculation (or even use a view in the source DB). There, you'll use...

This should work

(SELECT TOP 1 data FROM DimDate WHERE DimDate.data >= '2008-01-01')

however, if you post the business problem you're trying to solve rather than simply a TSQL query we...

Not sure what to tell you Mark. I couldn't try the first approach as my sample cube didn't have a time dim, so no average over time. I...