User-defined area configuration by means of Admin Console SAP Business One 9.1, version for SAP HANA Hello there as well as welcome to this session about the UDF configuration in SAP Company One 9.1, version for SAP HANA. In this session you can see this brand-new function how to generate UDF from the data source level to the HANA view degree and make a UDF likewise readily available in the analytics of HANA. So for this, we will first produce rapidly a UDF. So we most likely to personalization devices, User-Defined Area Management.I will go below to Marketing Documents and also on Row degree I will certainly add a brand-new UDF called BonusPoints. It will be numeric, and I will include it. Ok, so this is done. So in the following action, I will certainly simply develop some trial data for this scenario. So I will simply develop invoices, so swiftly choose the business partner. Select a thing. As well as additionally pick the Perk Things. So for$600 we provide 60 benefit points. Alright, and for the following consumer, we pick a different item.Ok and this will provide 63 bonus offer points.
Ok that s it. Alright, as well as now we switch over to the Admin Console. The URL is the HANA server host name or IP, complied with by the port 40,000/ Enablement/. So we login as the B1SiteUser. Click Companies, select the same schema where we logged in our United States data source. Go to the screw wheel right here and select UDF Configuration. This will open the UDF setup semantic layer. Here we have practically the same UI in Organization One in the modification in UDF monitoring. So we go here to rows. Select the BonusPoints to be designated. And now we can begin and designate the Perk Things as a measure to the various sights, as a sum. As well as I will do this currently, quickly, for every one of these. Alright, so I ve modified every procedure as an amount. Now I ll click on save. And also now I ll take a few minutes now, every view now will obtain the UDF instantly inserted.So as you can see currently, the wizard is do with importing the UDF to the HANA views.
And also if I will certainly currently go back to Company One, and also I will certainly as an example go here to the prevalent analytics designer and go in right here to develop a brand-new dashboard. And I pick this as Source, Calculation Sight, Sales. So possibly like Productivity Analysis, and also I claim ok. You can now see that we have a step likewise Bonus offer Details, and also as a measurement, I can select the let s see where we have it business Partner Code As well as we got a basic graph below. One has 60, as well as the various other one has 63. To make sure that s it, we just did a basic control panel based upon our UDF which is currently available in the HANA view. One more method, would certainly be to go to the Interactive Evaluation. As a result I pick below at the Interactive Analysis. Additionally the Profitability/Analysis. Microsoft Excel will open.
And in right here you will see we can additionally have Bonus offer Information, which I can also now check against business Partner. And after that I can see 60 and 63. Alright, so with this I want to say thank you and also really hoped that you appreciated this brand-new attribute and say bye bye.
Free Prescription Drug Cards Coupons
