Hi Beto, I am not prettly clear on your question. Please see the below script to arrive 'status' column DATA OUTPUT; INPUT ID DATE SCHEDULE ACTUAL ADD  ; LENGTH STATUS $25. ; INFORMAT DATE MMDDYY8. ; FORMAT DATE MMDDYY8. ; IF ACTUAL NE 0 THEN DO;      IF SCHEDULE NE ACTUAL THEN STATUS = 'SHORT';      ELSE STATUS = 'CORRECT'; END; ELSE DO;      IF SCHEDULE NE ADD THEN STATUS = 'MISSED REPLEN';      ELSE STATUS = 'WRONG REPLEN'; END; DATALINES; 1.  11/20/13  100.  100.  0. 2.  11/20/13  100.   80.   0. 3.  11/20/13  100.  00.    100. 4.  11/20/13  100.  00.  00. RUN; Hope this will meets your requirement ... View more

I believe below link will help you in understanding informat http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000178244.htm ... View more

Hi, You can try the below code Proc sql; SELECT B.* FROM B LEFT JOIN A ON A.ID = B.ID AND A.SCORE = B.SCORE WHERE A.ID IS NULL ; quit; ... View more

I am quite not sure about 9.1.3 . but in OLAP cube studio right click the particular cube and then select disable option. Then try to delete physical cube option. I hope it will work. ... View more

Please find the details below max measures  = 1024 max dimensions  = 128 max levels per cube = 256 max levels per hierarchy = 19 max properties per  level = 256 max members per  hierarchy = 2^32 ... View more

Hi, This might be due to rights permission for user. Check whether user is having access to OLAP Server and check the roles of the user also. Regards, Akilan R ... View more

Hi, In your case you can use prompts or uncheck hidden from user option while creating filter in the information Map ... View more

check this link http://support.sas.com/kb/20/672.html Hope this will resolve your issue. ... View more

Hi Shri, You can give the security in the below way. Select Insert ► Filter to open the New Filter dialog box. give a name to the filter, select empid dataitem isequal to Derive Identity Values(for row level permission) (SAS.PersonName or SAS.IdentityName) and add to the combination filter. Then in the same filter, select managerid is equal to  Derive Identity Values(for row level permission) (SAS.PersonName or SAS.IdentityName) and add to the combination filter. use  OR operator to join both the condition. then right click information map -> authorisation -> click employee group -> add condition -> add the filter to the employee group. Hope this will resolve your issue ... View more

Let us take a example, There is a table called products, It consist of dataitem Product_id,Product_name,QTY and another table sales_fact, Consist of Sales_Id,Sales_person,Product_ID Inner Join above two table with product_id add dataitem only related to products table in the information map selected items. Create a prompt 'Name of the Sales person' and apply to Sales_person in the SALES_FACT table Save the Infomap. Hope this will resolve your issue ... View more

Hello Ramesh, There is a way to do this. Create a dataset with the required colums, In that create number of stores column with the hyperlink pointing to the stored process of the report linking to the number of stores report. and in the same way create a number of person column pointing to another stored process linking to the number of persons report. Using the created data set, use proc report to display the result. Copy the code and create a stored process. Use the stored process to create the report Note: This will be a work around to see the links in the web report studio but if you import the same report in AMO, then it will be imported with full URL and the value(77) . Regards, Akilan R ... View more