Have you optimised your model? This could help with the query that's being fired towards your oracle DB.

Also, have you copied the query being run and looked...

Couldn't you use the transaction ID as the primary key?

To remove the time part, use a view which makes use of the cast or convert function.

RE: Using time in a...

Hi Angela,

Which provider are you chosing (if there is more than 1) in the drop down list in Excel?

I have two - Microsoft OLE DB Provider for OLAP Services...

Hi Affan,

Are you saying that you want the time (HH:MM:SS) in your time dimension in your cube(s)?

If yes,then the member counts on this dimension are likely to be large, especially...

Hi John,

You should be able to specify the ExecutionLocation in the connection string (not having used Crystal to access AS, cant tell you where to find it, but it will...

We've been speaking with MSft re:PTS lately on completely different topic (performance), but to take advantage of some connection string parameters etc etc, they've instructed us to upgrade all clients...

Morty,

Do you know what version of PTS (Pivot Table Services) your client machines have? My understanding is that MSft changed their licencing so that a user can install PTS...

Definitely in MSDN subs, not sure if it's universal subs only, but heres the disk details ->

Color Disc No. Product Language Pack Shipment...

Hi Guys,

Take a quick browse at (watch out for possible line breaks in url)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql2k_anservregsettings.asp

Gives good explanation of minimum, max and default values for AS registry entries.

HTH.

Steve.

I can taste the Chamay Bleu ou Rouge from here... Maybe a delerium tremens?

steve

Hi,

You could use a calc member/measure in your cube, but this will probably use an iif statement for every query and you'll also have to cater for situations where the...

Hi Bart,

Two answers contained below... I wrote nearly all of the SQL bit, and then thought you may be doing a proof of concept/small test etc, so then wrote...

Hi bart,

It looks like you've filtered only the dimension source query, you'll need to filter the transaction query also.

If you're using views as the queries that feed your cube(s), you...

Do you mean OWC (Office Web Controls)? Everything goes through PTS eventually, even 3rd party products.

You can (theoretically, not tried it myself) connect using Excel. Just follow standard...

Hi zchen,

Are you using IIS security (e.g. basic authentication)? If yes, then the user connecting needs to exist in the domain of the IIS server, or be from a...