Hi @AravindPalanichamy    In SMC, "Actions after the state of the flow is determined" option should be available under the attributes tab of the properties section of the flow you have created. In-case that is grayed out, you should try logging into SMC using the flow owner ID Or else try to schedule a flow using SMC, which when prompted for credentials enter the apt. user id and pass.   This allows SMC to make the connection to read info from the files on OS. Once you have done this, try to open other flow and see if these options are now available.   Also, as advised by @jklaverstijn, with SAS LSF license you don't get flow editor, only flowmanager and caleditor clients are available. ... View more

It looks to me like SAS is doing nothing else than reporting what DB2 tells it that happens. I don't know if there is a way to change the CLI Load Utility behaviour. It's a question you need to ask a DB2 DBA. You could use the CLI Load Utility to first load the data into a DB2 staging table and then use a "normal" insert to load the staging table into your target table (DB2 to DB2). ... View more

That's a mostly-safe categorization. There are some lines where the detail starts on the line below, and some "details" are XML, some are SAS logs, and others are just a dump of information. And most of the lines are stand-alone log entries (what you labelled headers).   There are also strategies you can use by altering the logging xml config file "SASCustIntelCore-log4j.xml" in the Lev1\Web\Common\LogConfig directory by defining new output files for only certain logging contexts, which might allow you to get some smaller files to work with if you're only looking for certain types of messages. Depending on which contexts you include you still may have to contend with the header/details concepts. ... View more

This is theoretical... maybe worth investigating.   Teradata has a function called query banding. If you are not using Teradata perhaps it has a similar function. If the user id at the time of the process could be used in the query band metadata you could then see usage from the database end.   http://documentation.sas.com/?docsetId=acreldb&docsetTarget=n0p09ar7svz98en1evbfbivj6ac8.htm&docsetVersion=9.4&locale=en   So... in SAS (again theoretically... not sure how &ci_user. could be supplied): libname db teradata user=myusr1 password=mypwd1           QUERY_BAND="SAS_User_ID=&ci_user.;SAS_Application=CIS;";   In Teradata: select * from DBC.AccessLogV where queryband like '%SAS_User ID=john_doe%'   ... View more

Hi   as mentioned, rebuilding might be the best way to go.   You might already be familiar with this info? As future ref for renaming cubes: http://support.sas.com/documentation/cdl/en/olapug/69844/HTML/default/viewer.htm#n1hehwp07vbxf1n18pa1q3h510q6.htm   Thanks Anja       ... View more

Hi,   What version of SAS and EMiner are you one?   In the SAS note that was referred to, it is explained that the permissions for read meta are being set in the library manager. The permissions should be set on the FOLDER, not the library in the Lib Manager.   Some input, maybe it helps. It works in my environment.   Ad Permissions Before you create a library (and this is true for general library creations), go to the Folders tab in SASMC and create a folder structure, or, a single folder, as location for the libraries you are going to create, and the tables you are going to register.   The creation of a SAS Folder is not only important for the EMiner scenario, but generally for libraries that are being created. This is important because the folder that's associsated with the library has to have the RM permissions assigned. An easy way to do that is to grant RM to SASUSERS on this folder.     Ad Library Creation  Pre-assigning a library in SASMC:   During creation of a new library, choose ADVANCED OPTIONS in the Library Properties window (in window for path specifications) and check Library is pre-assigned. If you want to pre-assign an already existing library, right click on the lib in the Library Manager, Options tab, Advanced Options, check Library is pre-assigned.      Ad METAAUTORESOURCE   EMiner requires metadata libraries to be pre-initialized. Only pre-initialized metadata objects can actually be seen from the EMiner client. In order to pre-initialize a library for EMiner, you have to add the METAAUTORESOURCES option.   METAAUTORESOURCES System Option "Identifies the metadata resources that are assigned when you start the SAS Metadata Server." http://support.sas.com/documentation/cdl/en/lrmeta/70119/HTML/default/viewer.htm#p1wdznofxy2l9ln17ldabix1qlmh.htm   The METAAUTORESOURCES option functions like a telephone operator. When you start EMiner, this option tells the metadata server to start a workspace server, and with that, users have the metadata libraries available in EMiner.   In SASMC, go to Application Management Click the SAS Enterprise Miner icon Expand the Projects folder In the Projects folder, right-click the logical workspace server icon (SASApp), and select Properties from the pop-up menu In the Options tab, in the MPCONNECT launch command field, add  On Windows SAS -metaautoresources "SASApp" -config "c:\sas_config_dir\lev1\sasapp\sasv9.cfg"   On UNIX: /installdir/…/Lev1/SASApp/sas.sh -metaautoresources "SASApp"   Give it a shot, maybe checking this entire set up will help to pin point the issue. Definitely, as Juan mentioned, check permissions.   Resources & Further details: http://support.sas.com/documentation/cdl/en/emxndg/67980/HTML/default/viewer.htm#p15m68fofeq4imn1jmsgmg8xp7xp.htm   http://support.sas.com/documentation/cdl/en/emxndg/67980/HTML/default/viewer.htm#p0vvvenme5cpfkn1pjz1ojeaj1m7.htm   Cheers Anja  ... View more

You will have to modify the sasv9.cfg in your Program Files\SAS\SASFoundation path.   -encoding=wlatin1 ... View more

It is possible to install plugins in Firefox for debugging, like one called FireBug, very popular. But if it is your first time to debug and investigate the front end, I think it would be a good idea for you to sit together with an experienced collega on this area. ... View more

If the data is sorted by type ID data want;      set have;      by typeId;      if first.typeid then exclID = 1000*typeId;      exclID + 1; run; ... View more