Search results for query: *

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...

Hi Chris, Thanks for letting me know what the problem was. I guess I should have suggested that :( Oh well at least it was a relatively easy solution. Good luck with the implementation. Oliver

It is beginning to sound as if there are two problems. Firstly that the MDX isn't being persisted properly (which sounds faintly familiar but I don't really use that facility). I'm not sure what can be done about it except to report it as a bug. If you don't mind me asking, why are you...

I think something else is happening there. When you select the members you are going back to using the Crystal view on the data rather than the MDX as I understand it. This means that you won't really be executing the MDX that you put in but rather CA has extracted the view from the query and...

So if I understand you correctly you are trying to use a transition to move to a page defined by an MDX query? But not changing the query. Further to that you are can see it in the designer but not in the Web client. Which version are you using? Also is the designer on the same machine as...

Hi SqMan, I tried this with one of the sample cubes from Crystal and it seemed to work fine in CAPro 8.5 (the Version dimension in the Sales Reports cube). Can you open the cube with some other tool like the MDX Sample App? Oliver