You should find that the entire cube data is updated. http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/viewer.htm#a003241630.htm "The new cube generation enables the original cube to remain online for queries during the entire update process. This is because the original cube is not modified. The original cube continues in production as before while the new cube is available for administrative review and updates (such as security updates or new global calculated members). This provides the administrator with an opportunity to examine and verify the correctness of the updates before bringing the cube online for production without affecting the original cube. " ~ Angela ... View more

Try this - after logging into the SAS Portal, search for and open the webdav file. Once opened, use the Internet Explorer menu (File -> Send -> Link by Email). This will open an email message on your machine with the URL. Use this URL in a SAS Portal URL Display Portlet - then authentication will not be requested again. (You still have to log in once - to the SAS Portal. But then the file is available immediately, without having to reauthenticate to the WebDav server.) ~Angela ... View more

Bob, Do you have the STP registered to a workspace server? To have the stored process generate streaming results, it needs to be registered to the stored process server. Also - I would move the line: file _webout; To be immediately below the first data _null_ statement. ~ Angela ... View more

In your IIF statement - have you tried to replace: IIF( SAS.IdentityGroupName IS 'SalesTeamLead' with: IIF( "SUB::SAS.IdentityGroupName" IS "SalesTeamLead" ~ Angela (The only documentation I have seen is: http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/viewer.htm#a003212399.htm - so seems like we need a SASGF paper for 2012 in Orlando!) ... View more

Lol, I started trying it after I posted the response. Unfortunately, it didn't work. ~ Angela ... View more

The %stpbegin and %stpend macros can lock the webout location from further updates. Here is my blog post on how to write code out to the stored process streaming location. http://sas-bi.blogspot.com/2010/07/combining-graphsprocs-with-custom-html.html Also - here is a sample from SAS on putting out HTML code without worrying about all the ' and " values: http://support.sas.com/kb/37/050.html ~ Angela ... View more

Oh sorry about that. My understanding is that it's not supported in the Theme or in the properties. However, I have seen folks modify the java itself (NOT SUPPORTED) and run the redeploy wizard to ensure that the browser title is different. C:\Program Files\SAS\SASInformationDeliveryPortal\4.2\Static\wars\sas.portal\jsp\html\portal\HeadInclude.jsp Change: <idportal:Text key="desktop.title.txt" /> to: Your new title bar title here ~ Angela ... View more

Bob, What is the issue you are having? Is the user still able to see everything? Ensure that the security_subset option is on in the OLAP Cube. http://sas-bi.blogspot.com/2011/01/implementing-olap-member-level-security.html Is the edit expression returning an error? Here is documentation: http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/viewer.htm#a003212399.htm Also in 9.2.M3 - you can set up a security batch table. See the bottom of the pg: http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/viewer.htm#a003212372.htm ~ Angela ... View more

Craig, A quick search for "SAS Logon page title" yielded this TS tip: http://support.sas.com/kb/37/606.html There is a link in there for IDP as well. ~ Angela ... View more

Bob, You will need to include some javascript in your stored process to retrieve the browser language. A quick search via google found this: var userLang = (navigator.language) ? navigator.language : navigator.userLanguage; alert ("The language is: " + userLang); (retrieved from: http://answers.yahoo.com/question/index?qid=20080418104516AAssAjm) ~ Angela ... View more

You can create a custom data element for the measure (in Information Map Studio) you would like to display as 0 rather than MISSING. Edit the expression of this new custom data element and set as: sum(olddataname, 0) ~ Angela Reference: http://www.sascommunity.org/wiki/Tips:Convert_MISSING_to_0 ... View more

No problem. This test is done on the Information Map Studio side. Here is some online documentation: http://support.sas.com/documentation/cdl/en/imsgs/61225/HTML/default/viewer.htm#p0j4b2vippx9uzn1cd1xh5eitzrn.htm ~ Angela ... View more

For Number 1 - click the ''Run a Test Query" icon on the menu bar, "Insert all" the available data elements, then select the "view SQL" button. ~ Angela ... View more

If you would like the stored process to utilize the prompt value, the prompt must be defined within the stored process definition rather than the web report. There are samples on the support site that integrate stored processes with information maps when prompts are utilized. Here are some links: http://support.sas.com/kb/37/028.html http://support.sas.com/kb/40/758.html http://support.sas.com/kb/36/193.html ~ Angela ... View more

Hi Bob, That's a really good idea. However, don't think you can do that in the current version. An idea is to have a 'master set' of reports in one folder and set up a copy of the metadata from the master to multiple locations & can be runs on a schedule to sync up. This could be considered a 'promotion'. Here is one paper that might give you some ideas on how to do this: http://support.sas.com/resources/papers/sgf2008/migratemetadata.pdf ~ Angela ... View more