Search results for query: *

As OliverS says, you can use the default member option in the member selector. The other way would be to prompt for that member using the parameters options available. This way you can select when you view the report as to which period you actually want to show

This should be possible as I recall it being a requirement of using parameters. If it isn't documented, then there should be something on the BOBJ web-site. Others may recall more precisely how to do this...

On the OLAP server, you need to have IIS (or personal web server) running. You then need to copy MSOLAP.ASP (as I recall it being called) into the wwwroot directory. This is all documented somewhere in the OLAP Services documentation (sorry it's some time since I did all this now). You will...

The authentication will affect the members that you can see; certinaly if you've set up roles on your MSAS server. If a member isn't found, then reloading the sets of members to display can get a little interesting

Sure I've used this before, but can't recall exactly off the top of my head. I recall that if you are too high through the hierarchies in the dimensions, then the results for the drill through get very large very quickly - almost making them unusable - that's a data problem not a program...

If the different users always want to start at the same (individual) starting point, then the easiest way is to use the parameters. Create a memberset type parameter that contains Dimension.DefaultMember. For each user set their default member to be the specified member Put the parameter into...

This is certainly something you can use OLAP for. The way I'd do this is to set up a "Named Set" on the server, or create a set from an expression in CA (using the member selector). Define the set to be the last 3 months, can't recall exactly how to but should be easy. You can then create a...

Have you tried executing the above query in the MDX Sample Application? Does it work okay in there?

PTS is the client component that many OLAP Clients use to connect to the Analysis Services server. You will find it installed as MSOLAP80.DLL and MSOLAP.DLL located in \Program Files\Common Files\System\Ole DB I'm still unclear as to where the olap module is running. Is this on the machine...

So is your problem connecting from the client laptop to the application server? The obvious thing is to make sure that a good version of PTS is installed on your laptop. You should be able to find one on the SQL CD (under something like msolap\x86\pts) or aternatively download from the MS...

Have not heard anything about it but would like to hear more.

Crystal should be able to get the value of calculated members that are not on the measures dimension. Do you get the values in other versions of the Crystal client?

Stupid question: Have you processed the cube? Which version of Crystal Analysis are you using? If you've specified a user name and password when you defined the connection to the server and you're using NTLM security then this might not work. If you leave them blank then connection is made...

Depends on how you are viewing the cubes You have two choices: 1) Expose the cubes as http cubes (or iCubes) 2) If you are using some form of portal, then you may need to use Kerberos to provide a secure token to get into the server. Some details: 1) To do iCubes, you need to copy msolap.asp...

Just some points of caution on this. If you're trying to impersonate someone else, this could also give you problems unless you're using Kerberos (or Negotiate) security protocols. If you're using NTLM and you're impersonating someone elses credentials then the security token for NTLM is not...

Sounds like a permissions thing potentially. Does it work for any user on the local box or is it only you? What if you access it from another box? If you are an admin then don't forget you will have more privilage than others anyway.

This all depends on the type of cube you're connecting to. I'll assume you're using MS AS so what you need to know is as follows: The toggle description toggles between the member's Name and Caption. By default these are the same but they don't have to be. To set them to be different, you need...

Depends on what you want!

Okay, so stupid questions first... Have you installed the client components (or PTS) on the machine you're running Crystal Analysis on? If the answer to this is yes, then I what is xxx? Is it the machine name or IParseDisplayName? If you haven't then you won't be able to connect. Does the user...

I suspect you're more likely to get an answer to this on the Crystal Reports forum