Hana Driver Odbc' title='Hana Driver Odbc' />SAP BI Blog News information about SAP Business Intelligence tools and SAP HANAIt has been some time since I last posted a blog about SAP Business. Objects. In part that was due to a lack of major changes in the SAP Business. Object platform. A few Support Pack were released but there were only a handful of changes or enhancement that caught my attention. In addition to this, I am also excited to now be a part of the Protiviti family. In November of 2. Decision First Technologies were mutually acquired by Protiviti. I am now acting as a Director within the Protiviti Data and Analytics practice. I look forward to all the benefits we can now offer our customers but unfortunately the acquisition transition required some of my time. Now that things are settling, I hope to focus more on my blogging. Now lets get to the good partsWith the release of SAP Business. Objects 4. 2 SP2, SAP has introduced a treasure trove of new enhancements. It contains a proverbial wish list of enhancements that have been desired for years. Much to my delight, SAP Web Intelligence has received several significant enhancements. Windows Xp Professional Torrent. Particularly in terms of its integration with SAP HANA. However, there were also enhancement to the platform itself. For example, there is now a recycling bin. Once enabled, user can accidentally delete a file and the administrator can save the day and recover the file. Find the driver for your database so that you can connect Tableau to your data. SAP Adaptive Server Enterprise 16. Release Bulletin SAP Adaptive Server Enterprise 16. HPUX Release Bulletin SAP Adaptive Server Enterprise 16. IBM AIX. Note that there is a time limit or a configured number of days before the file is permanently deleted. Lets take a more detailed look at my top 1. Web Intelligence Shared Elements. This is the starting point for something that I have always desired to see in Web Intelligence. Hana Driver Odbc' title='Hana Driver Odbc' />Semantic Layer Mission 5 Make business users autonomous Enable single user experience over all data structured unstructured Enable the use of HANA connections. ARY News is a wonderful channel always disclose the govt sectors scams without any fear. There are Many channels are in Pakistan but only few are working in right and. Complete guide on SAP HANA certification along with HANA material, tutorial and self learning guide. Free interview questions and updates on SAP HANA. For many years I have wanted a way to define a central report variable repository. While its not quite implemented the way I desired, within the shared elements feature, the end results is much the same. Hopefully they will take this a step further in the future but I can live with shared elements for now. Hana Driver Odbc' title='Hana Driver Odbc' />With that said, developers now have the option to publish report elements to a central located platform public folder. They can also refresh or re sync these elements using the new shared elements panel within Webi. While this might not seem like an earth shattering enhancement, lets take a moment to discuss how this works and one way we can use it to our advantage. Take for example, a report table. Within that report table I have assigned a few key dimensions and measures. I have also assigned 5 report variables. BI4-on-HANA-06.png?ssl=1' alt='Hana Driver Odbc' title='Hana Driver Odbc' />These variables contain advanced calculations that are critical to the organization. When I publish this table to a shared elements folder, the table, dimensions, measures and variables are all published. Thats right, the variables are published too. Later on I can import this shared element into another report and all of the dimensions, measures and variables are also imported with the table. One important functionality note is that Web Intelligence will add a new query to support the shared elements containing universe objects. It does not add the required dimensions and measures to any existing query. This might complicate matters if you are only attempting to retrieve the variables. However, you can manually update your variable to support existing queries. If you have not had the epiphany yet, let me help you out. As a best practice, we strive to maintain critical business logic in a central repository. This is one of many ways that we can achieve a single version of the truth. For the first time, we now have the ability to store Web Intelligence elements including variables in a central repository. Arguably, I still think it would be better to store variables within the Universe. However, shared elements are a good start. Assuming that developers can communicate and coordinate the use of shared elements, reports can now be increasingly more consistent throughout the organization. I dont want to underscore the other great benefits of shared elements. Variables are not the only benefit. Outside of variable, this is also an exceptional way for organization to implement a central repository of analytics. This means user can quickly import frequently utilized logos, charts and visualizations into their reports. Because the elements have all their constituent dependencies included, user will find this as an excellent way to simplify their self service needs. I find it most fascinating in terms of charts or visual analytics. For the casual user they dont need to focus on defining the queries, formats, and elements of the chart. They can simply import someone elses work. Web Intelligence Parallel Data Provider Refresh. I was quite pleasantly surprised that this enhancement was delivered in 4. In the past, Web Intelligence would execute each query defined in a report in serial. If there were four queries and each required 2. When queries are executed in parallel, users only have to wait for the longest running query to complete. In my previous example, that means that report will refresh in 2. Keep in mind that you can disabled this feature. This is something you might have to do if your database can not handle the extra concurrent workload. You can also increase or decrease the number of parallel queries to optimize your environment as needed. Web Intelligence Geo Maps. Maps in Web Intelligence Yes really, maps in Web Intelligence are no longer reserved for the mobile application. You can now create or view them in Web Intelligence desktop, browser or mobile. The feature also include a geo encoder engine. This engine allows you to geocode any city, state, country dimension within your existing dataset. Simply right click a dimension in the Available Objects panel to Edit as Geography A wizard will appear to help you geo encode the object. Note that the engine runs within an adaptive processing server and the feature will not work unless this service is running. I found this true even when using the desktop version of Web Intelligence. Web Intelligence Direct access to HANA views. For those that did not like the idea of creating a Universe for each SAP HANA information view, 4. SAP HANA information view without the need to first create a universe. From what I can decipher, this option simply generates a universe on the fly. However, it appears that metadata matters. The naming of objects is based on the label column names defined within SAP HANA. If you dont have the label columns nicely defined, your available objects panel will look quite disorganized. In addition, objects are not organized into folders based on the attribute view or other shared object semantics. With that said, there is an option to organize dimension objects based on hierarchies defined in the HANA semantics. However, measures seem to be absent from this view in Web Intelligence relational connections which makes me scratch my head a little. Overall, I think its a great option but still just an option. If you want complete control over the semantics or how they will be presented within Web Intelligence, you still need to define a Universe. Tecdoc Keygen Manager here. Web Intelligence SAP HANA Online. Let me start by saying this, this is not the same as direct access to HANA views. While the workflow might appear to be similar, there is a profound difference in how the data is processed in SAP HANA online. For starters, the core data in this mode remains on HANA. Only the results of your visualization or table are actually transferred. In addition, report side filters appear to get pushed to SAP HANA.