It sounds like the month column is actually a text field rather than a SAS date? If you utilize a SAS date format, the sorting will be automatic. You also have the ability to choose from a multitude of formats. Included is the direct reference to format documentation (in SAS Base Language Dictionary: http://support.sas.com/documentation/cdl/en/lrdict/63026/HTML/default/viewer.htm#a001263753.htm) ~ Angela ... View more

John, Is this using an OLAP cube source? If so... You could consider creating a Calculated Member in OLAP Cube Studio to use in the Info Map (and subsequent WRS report). Otherwise you would need to create this new measure in your Information Map. In both methods, you will need to utilize MDX code to create the calculation. I would actually recommend opening the cube in Enterprise Guide and creating/testing the calculation here (create a new 'calculated measure'). Then saving the calculation back into the OLAP Cube via the Cube Studio 'calculated member' widget. Example of the SUM function = http://msdn.microsoft.com/en-us/library/ms145484.aspx ~ Angela ... View more

There are estimators for SPDE. A quick search returned this pdf: http://support.sas.com/rnd/scalability/spde/spde_setup.pdf ~ Angela ... View more

1. From what I understand, comment functionality will be available in BI Dashboard 4.3 ~ Angela Hall http://sas-bi.blogspot.com ... View more

If you havent already, I would suggest opening a track with Technical Support. Sounds like a configuration issue with SSO. ~ Angela ... View more

It sounds like you're interested in setting a filter based on the group the user is in. An example - the Sales team would only see Sales data, where the Executives could see everything. Check out the SAS 9.2 documentation summarizing Cube Security: http://support.sas.com/documentation/cdl/en/olapug/59574/HTML/default/viewer.htm#a003212372.htm There are several different ways to do this, however you might find the first to be the easiest to implement. (Permissions on Cube Dimensions) ~ Angela http://sas-bi.blogspot.com ... View more

Andre, There are still mechanisms to accomplish this via SAS Stored Processes. You could pass the values from Report A into Report B (which is built in SAS Stored Processes). Several resources exist but might not totally explain how this works: http://support.sas.com/kb/19/597.html http://support.sas.com/documentation/cdl/en/citug/61084/HTML/default/n1cxoydhoyhsain13of3rrl6yfir.htm#n0g6pyz7q5xcncn1mh76i8bzf0df Maybe a SAS Global Forum 2011 paper is in order? What I would have is a link (to the stored process, passing the parameters) defined within the data table itself, then select the 'Display as Hyperlink' button in Information Map Studio (similar to my post on doing this for formats: http://sas-bi.blogspot.com/2010/01/custom-colors-on-categories-in-web.html). Then the data cells should link to the Report B passing the information you require. ~ Angela ... View more

Barry, I was doing some research on this and found some old notes (2005). There is likely a difference in how the users are setup. The domain string cannot be located either from the Metadata or from the user themselves and so the default @!(... string is included. Can you verify whether the users that show this '(generatedpassworddomain)' are defined on the host machine? You could also review the setups in SAS Management Console User manager. Wonder if the 'Authentication' tab is different for the different users. There is information on different auth setups documented at: http://support.sas.com/rnd/itech/doc9/admin_oma/security/grpuserlog_defs.html Let me know what you find in Mgmt Console. ~ Angela ... View more

Great news! Thanks for the update & resolution information! ~ Angela ... View more

Publication channels are created and managed through SAS Management Console. They defined where the content is saved on the content server and who has access to it. More information is available: 9.2: http://support.sas.com/documentation/cdl/en/biwaag/63536/HTML/default/viewer.htm#ag_saschannels.htm 9.1.3: http://www2.sas.com/proceedings/sugi31/217-31.pdf ~ Angela ... View more

We've gotten past the initial error, but at this point I think you should give SAS Technical Support a ring. http://support.sas.com/ctx/supportform/createForm You will need to provide the information in this discussion as well as information on where the format is being ignored (EG? IMap? etc). ~ Angela ... View more

There isn't a clean mechanism to promote SAS Portal content. It is typically much easier/cheaper to create content in the Portal than it is to attempt a metadata move. Suggest creating multiple groups within the Portal (in Production) and assigning a content manager from the business to create the content for a 'test group'. Example - two groups would exist for each content area. An 'Executive' group where all the executives are members and you are the content administrator, and an 'Executive Development' group where the business content creator can develop but none of the actual executives are a part of/can see. As the web administrator, you have the ultimate ability to reassign the content from the 'dev' group to the live area. ~ Angela ... View more

For metadata elements, this is addressed within the wizard. However for SAS code (such as code nodes in DI studio or Stored Processes), you will need to estabilish macros/processes to ensure no code modification is required when moving from one environment to the next. There are many strategies (user papers, etc out there) that provide ideas on how to accomplish this. A simple technique that I recommend is estabilishing a set of your own 'reserved macro variables' in the autoexec_usermods.sas file (on each system Dev-Test-Prod) that are then used through out the BI infrastructure. ~Angela ... View more

Responded to your 2nd post. http://support.sas.com/forums/thread.jspa?messageID=44097 ~ A ... View more

I would lean toward the Export Wizard. Run from Management Console, you can then follow the prompts to select the dependent objects (in 9.2), ensuring that none of the linkages are broken during migration. Also, this allows you to choose a specific part of the content. ~ Angela ... View more