Recent content by OliverS

Mikael, The ActiveX viewer is almost identical to the full content creation tool. The only difference is the container in which the components are displayed. So I don't think it is possible to reduce the size. OliverS

Which makes me think of another possibility. Assuming you can pass the parameters from csp, then you could write some cunning CSP that resolves the parameters at the point they access the report. You would need a custom management console to generate the parameter values so I don't know how...

If you are prepared to do the work on the MSAS side then make the snapshot date the default member of that dimension. Then make OLAPI use the default member in that report.

Hi SydneyUser, The ActiveX viewer is largely the same as CAPro itself. So I don't see an easy way to avoid registry changes. The domain issue is because the ActiveX viewer makes a direct connection to the analysis server and the only way I know of to avoid the domain issue is to use http...

I'm intrigued, what better OLAP tools does BO have? O

If you are prepared to connect to Analysis Services via HTTP then you don't have to have the ActiveX viewer in the same domain, in fact it can be anywhere on the web. You can also force the user to reenter their authentication details each time. However it does mean that you need to expose your...

The settings for using the Crystal Reports ActiveX viewer and the Crystal Analysis ActiveX viewer are separate. You need to make sure that both are set. I have a nasty recollection that you need to ensure that Crystal Analysis is installed last on the server to get the options but I'm not...

Ah possibly true, but I didn't think that the NT logon token was passed all the way down to MSAS. I had a suspicion that the WCS credentials were used for the MSAS roles. Now given the problem as originally described is that the dimension order has reverted to what is the original CAR file...

I don't think that the authentication method should affect things. As I recall (and I don't use Crystal at the moment so I'm working from memory) the authentication is used only to establish whether the user can see the view rather than what they see. So are you sure that the second user is...

The way around this is to use http connectivity to MSOLAP. If you set up IIS on the OLAP server machine correctly then you can force PTS to connect to the server over http (it is one of the connection options in CAPro). Then provided that your OLAP server machine is visible through your...

Hi Krist, As I see it Crystal Reports is great for scheduling formatted reports from OLAP sources but if you want interactive access then Crystal Analysis is better. Crystal Analysis has better OLAP navigation through the Analysis Buttons but Crystal Reports is better at printing and...

Have you got a Global NULL filter? That often causes Calculated members that have no results to disappear. Just right-click in the top left of the worksheet and you should be able to switch it off. Oliver

Hi Ken, I presume you mean on the Worksheet? I'm not totally clear on what you mean. I have an image in my mind of a checkbox next to each member in the Worksheet and an update button. The update button then reduces the worksheet to look at the ones selected. I think this might be possible...

I don't have a long delay (~10s) when selecting all base members in the MemberSelector, but I do get really long delays when trying to edit the MDX after selecting lots of members. I'm wondering if CAPro does use something similar to the [Dim Name].[Level Name].members internally but for some...

Crystal Analysis is actively promoted by Crystal as their OLAP client. I'm not sure that it necessarily what your users want but liking OLAP myself I would think they could get some value from it. You'd need to set up an OLAP server for it to use, I guess you have SQL Server Analysis Services...