Hi Experts, Requirement is that the excel report to be converted into a SAS dataset and then be replicate the report thru WRS then view it in IDP. I tried to convert the worksheet into a dataset and as expected, it ain't an easy job because of the merged columns. Hoping for your suggestions on how to convert this report template into a sas dataset correctly. Thanks! Milton ... View more

Hi, I have a BI Dashboard Portlet with a Graph Indicator referencing on a Stored Process URL. On the first logon instead of the stored process displaying the result the SAS Logon Manager screen appears instead. Is there a way to automatically authenticate the user to execute the Stored Process so the result will be the one displayed? Thanks! Milton ... View more

Hi, I have this sample dataset. What I want to happen on my proc report is that I on the row for the totals,  I only want a value displayed for the column two and column one should not have a summary value. Is this possible? Please see script below and current and desired results. Thanks! data test;     input nm $ one two;     datalines; one 1 10 two 2 20 three 3 30 ; proc report data=test;     column nm one two ;     define nm / display;     define one / analysis sum;     define two / analysis sum;     rbreak after / summarize;     compute after;         if _break_ = '_RBREAK_' then do;             nm = 'Total';         end;     endcomp; run; quit; Current Output nm one two one 1 10 two 2 20 three 3 30 total 6 60 Desired Output nm one two one 1 10 two 2 20 three 3 30 total 60 ... View more

Hi, I would like to know if there is a limitation regarding the size of an OLAP cube? Thanks! ... View more