Hi Rob,

That number converted to something understandable is roughly 270 years!? For a service request? 🙂

The easiest way to see if your processing is failing because of this number would...

Uma,

Which tool will users use when selecting those dates? Do you have any control of the generated mdx like for example in reporting services or no control (excel)?

Hi,

Ok that is true regarding calculated members.

But since you are on 2005 you can't really use dynamic sets so it will not work with approach number 1 as static...

Hi,

The example was written to be used in an mdx query.

Here is the definition for the cube mdx script:

CREATE DYNAMIC SET CurrentCube.[Days] as

{existing [Fiscal Period].[Fiscal Period Hierarchy].[Day]};

CREATE MEMBER CURRENTCUBE.[MEASURES].[LY...

Hi,

This is actually a very common problem with multiselects but there are ways to solve it. It's just that the performance might suffer as the only safe method is to...

Hi,

have a look at my blog post discussing the problem http://hrvoje.piasevoli.com/2010/09/01/importing-data-from-64-bit-excel-in-ssis/[/url]

Regards,

Hrvoje

78% correct answers?! Yeah, right.

Great question and good points in discussion by Hugo. Pleasure to read.

But, thanks to all who participated in it.

Hrvoje

Hi all!

Found this thread while searching for posts that describe problems of using SQL 2008 x64 and Excel.

Here is an article I've written that talks problems and provides solutions for...

Hello again!

Out of curiosity, I've managed to enable Oracle replication and it works OK.

Follow the steps in this article:

http://msdn.microsoft.com/en-us/library/ms151243.aspx

If you want contact me freely.

Best regards,

Hrvoje Piasevoli

I really can't be of much help with the replication configuration, but you should be able to solve the first issue:

I still can't see the oracle provider under LinkedServer---->Providers...

I just finished installing Oracle client 11.2 (both 32bit and 64 bit) on one of my test servers with Win 2k8R2 + SQL 2k8R2 64bit.

Everything installed OK and tested, no...

The hardest part of the question was figuring out what is the result of 5/3.1

IMHO the point of the question would make more sense if it had been changed to...

Great question! Thank You Sir!

Realy flexible, handy and readable method.

Hi all, played for a while with Hugo's example and ... look what I found :w00t:

First, I have tested and it errors on 2008, works on 2005.

So, the following...

Hugo what is the expected result?...