You may consider asking the users to Copy the stored process code and execute it in a  SAS Program in the Enterprise Guide instead of executing the Stored Process to review the Temporary tables. Any Prompts defined in the Stored process can be handled by the %let statement in the code. ... View more

Hi, Though I recommend contacting Tech. Support for this . You may try this in SMC, since it has worked for me. Expand Server Manager -> SASAPP - > SASAPP - Logical Workspace Server . Right click on SASAPP - Workspace Server. Go to Options Tab -> Advanced Options -> Launch Properties - > Check Allow XCMD. ... View more

I guess You can create a calculated member from an existing member and while creating you can apply a format on It. Or you can slice a cube into a sas dataset and apply the format on the dataset. ... View more

Which tool are you referring to  when you say 'user opens up the cube ..' ... View more

I think there is no way you can control the number of rows to be displayed while using the stored process as a source to your report in WRS. ... View more

We are using a calander control for date selection and it is not based on the data items. Though I have not tried applying the group breaks I can tell that we cannot control the position of the label, which does not help in our case since we have to display that at the top right corner of the report layout and I guess using the Text Object is the only option for us. Thanks. ... View more

Instead of Using the [SUB::SAS.IdentityGroups], you may try this . In the Authorization window, select the Group and click on Build the formula. For example the name of Group is XYZ and you want to enable the users in the Group to see only the data of USA then your MDX will be similar to: {  [Organization Unit].[Organization Unit].[All Organization Unit],    [Organization Unit].[Organization Unit].[All Organization Unit].[GROUP],    [Organization Unit].[Organization Unit].[All Organization Unit].[GROUP].[USA],    descendants([Organization Unit].[Organization Unit].[All Organization Unit].[GROUP].[USA] )} This support document shows information when there are more than hierarchies, but this even works when there is only one hierarchy in the dimension. http://support.sas.com/kb/37/136.html ... View more

Which Version of SAS(9.2 or 9.3) are you using? ... View more

Hi Yonib, It would be helpful for anyone to answer if you could provide some more information or sample on how the member level security has been applied on the cube. Applying security based on the user id can be tricky and I guess it requires that the member in the dimension has to match the user id. If you are using the OLAP Cube Studio 4.3, you may use the new batch security tool. ... View more

Hi Bob, You may check more about SAS Publication channels . A Google search on "SAS Publication Channels" has resulted in these links. http://support.sas.com/kb/36/401.html http://support.sas.com/documentation/cdl/en/biwaag/63149/HTML/default/viewer.htm#ag_saschannels.htm ... View more

Hi Mojerry, SAS WRS saves the selected prompt values along with the report. This is the reason why the values in the prompts are still reflecting the previous values. As a work around for this issue you have to remove the prompts from your report, save it and add the prompts again. If your report is based on the Information maps you can uncheck the prompts from the menu and add them after saving the report, incase if your report is using STP you have to remove the prompts directly from the STP. ... View more