Hi Rajesh., Thanks for your Replay.... i done with test connection, its successful. as per my opinion problem with specific target in SMC. can u provide a clear cut idea regarding this. And no one is there to handle SMC in my team i have to handle the problem. Regards., Venkatesh. ... View more

Hi., 1) Cube Designer in DI Studio and Cube Designer in OLAP Cube studio both are similar but if u will create a cube in DI studio it will reflect in OLAP Cube Studio.... 2). Difference b/w Splitter and Extract. Using Splitter Transformation u can Split the data in to two different datasets as per conditions. For every dataset can provide the conditions. For example u have data set called EMP (eid, ename, joining_date) now based on Joining date u have to split the data in two different data sets one for joined before 1/1/2008 and after........ But in Extract transformation only one condition will apply. U can’t give two conditions (either of the condition dataset only). Aggregations: An aggregation is the summarization of one or more levels. To improve performance, add additional aggregations designed to match the data requested from the client. The Advanced Aggregation Tuning function provides automatic generation of cube aggregations. The Advanced Aggregation Tuning function includes two aggregation generation methods Cross-Dimensional: constructs aggregations using the different combinations of levels across all hierarchies. ARM Analysis: constructs aggregations using the ARM log (created when the cube is queried with ARM logging on). Constructs aggregations using the different combinations of levels across all hierarchies. ... View more

Hi., The Problem is[as u mentioned for variables startdate and enddate date9. informats, SAS will read from 10 column for Enddate and it is blank(null) so the values showing as missing data] space between the startdate and enddate. If u will mentioned as follows it works fine. 17oct199712nov1997 22jan199810mar1998 15dec199915feb2000 04jan200111jan2001 ... View more

Thank you Cynthia.... Cheers... ... View more

Hi GR., now u have a SAS dataset...... In a SAS Data Integration Studio job, if you want to put data into an XML table, you must use an XML Writer transformation. You cannot use the Table Loader transformation to load an XML table.\ for example. The XML Writer is a transformation that puts data into an XML table. The target of an XML Writer must be an XML table in a SAS XML Library. Access to the library must not be set to READONLY. (For more information about library access options, see Define Metadata for XML Libraries.) When you add an XML table to a process flow and you make the XML table an output, an XML Writer is inserted before the XML table. For example, if you drag an XML table named C_TEMP from the Inventory tree, drop it into a job in the Process Editor, and then right-click the table and select Make Output from the pop-up menu, an XML Writer transformation is added just before the table, To complete the process flow, you can drag a source table into the empty drop zone. If you then submit the job for execution, the XML Writer reads the data from the source table and loads it into the target (C_TEMP). In many cases, you can accept the default metadata for a XML Writer transformation and then run the job. In other cases, you can right-click the transformation, select Properties from the pop-up menu and then update the metadata on a tab in the properties window. For example, you could click the Options tab and specify XML engine options for the LIBNAME statement that the XML Writer transformation generates. For details about XML engine options, see the SAS XML LIBNAME Engine User' Guide. For an example of how an XML writer transformation can be used in a job, see Data Flow for a Web Service Job. I hope this will helps u...... Cheers Venky.. ... View more

Hi GR.... first u have to register xml files into DI Studio. You can access XML tables through a SAS XML library, a library that uses the SAS XML LIBNAME engine to access an XML file. The metadata for a SAS XML Library includes the following unique attributes specifies the SAS XML engine to use when accessing XML files in this library. This field corresponds to the XML option on the LIBNAME statement. XML File specifies the XML document to import or export. You must specify the entire pathname and file extension. Corresponds to the XML-document-path option on the LIBNAME statement. For example, you could specify the pathname for a directory where XML files are stored, or an XML document that contains data and metadata for one or more tables. specifies the XML format used by files in the library. Specify a blank value if you are accessing an XMLMap. This field corresponds to the XMLTYPE= option on the LIBNAME statement. Valid values include blank, GENERIC, ORACLE, CDISCODM, EXPORT, and MSACCESS. specifies the type of access that users are allowed to the library. Valid values are blank, TEMP and READONLY. Corresponds to the ACCESS= option on the LIBNAME statement. See the Usage Note below. displays the Advanced Options window for XML libraries. Enables you to specify XMLMaps, options for working with CDISC ODM elements, and other options. An XMLMap is used by the SAS XML LIBNAME engine in order to import an XML document as a SAS data set. If your XML document is not in the physical structure required by the XML engine, you can create an XMLMap to tell the XML engine how to interpret the XML markup in order to successfully import the document. After assigning library....by using source desiner u can get the table as data sets now u will get all the xml files into sas data set...run the jobs as u desired out to combine tables or splitting tables or what ever u required..... after completing the staging process do the targets and EG or WEB Reports as xml formats......etc..... cheers.. Message was edited by: venkatesh ... View more

Hi., u can create the table in physical location by running the job successfully. Cheers., ... View more

Hi., Thanks for Quick Reply.... Table name called Credit_card_Details...and the fields are name cardno password etc.... cardno and password fields are to be anonymous with different charrecters... cardno:50811441456478 password:v3nky@123 this is just example..... desired output: as my wish but when i required deanonymous has to apper original values... ... View more

Hi GR., I think your instalation and work libraries are in same disk.u will get these error low disk space..... ... View more

Hi., if u have a admin rights in Management Console u can create the security rights for specified folder or specified report. Message was edited by: venkatesh ... View more

First i have to confirm whether u are using DI Studio or Base sas If u want to access through DI Studio first u need to register access file to windows environment. these will do your administrator. By using source designer u can get it....... ... View more