Bi support tool

Looks like I got my wires crossed. Any ideas. We run the Tool with no administrative rights on the BI-Server, but with full access read, write, execute to the SupportTool folder. In addition: I just tested on my local VM with full administrative rights. Still revieve the error from above when exporting Patch History to pdf. Thanks for reporting the problem. This is a known issue. We are currently re-writing the export functionality right now and hope to release this soon.

We will likely disable the PDF export until this is ready since it is out of sync with the currently functionality. One of my developer required all the universe and reports information. I just copied the content into excel from the BI Support Platform tool. I guess you might be aware of this issue as well. It would be great if you can add an option to export the Semantic Layer Analysis Report into an Excel.

Appreciate it. Thanks, yes we are aware and hope to have the new export solution ready soon. One other trick is to open the HTML file for the desired report in MS Excel and it will automatically create an excel file with the data for you. I'm just getting started with installing what looks like an awesome tool. This could be due to network connectivity, bad credentials, or misconfiguration. Please try again. I tried deleting the service from the offending node and reinstalled the HostAgent again without any issues.

This page can't be displayed. Then I realized the URL for the host should use a mgmt. All 4 hosts now validate. Now I'm off to configure JMX for tomcat. I'm having issues with the platform support tool specifically seems to be the host agent on my new 4. I understand the Host Agent is now supposed to be integrated in the 4. The prerequisites still indicate that I need to install the Host Agent separately.

Perhaps I've overwritten the default agent that came with 4. The BIP 4. For example:. My initial issue was that I was trying to generate a landscape analysis report and the BIPST could no longer communicate with my other nodes. Upon discovery, I noticed the host agent service wasn't running on my other nodes, nor could I get the agent to start. It said invalid credentials. Although, I never changed my password or started using a different password. So my thought was that I'd uninstall and reinstall the host agent, but then I read the information about 4.

Because then I couldn't get it to reinstall - it'd fail with failed to register error. I eventually got the host agent to reinstall successfully don't know how I finally got it to work, you tend to lose track of your bread crumb of trails after trying many different things that span many different days. One of the things I tried was uninstalling 4. This may have contributed to it finally working as well, not sure.

That's the article I followed to uninstall, and removing the sapadm user. But it wouldn't reinstall after I followed those steps. I was only needing to create a landscape analysis report to submit with an incident to SAP Support regarding an issue I was having with installing 4. More specifically, if I running this tool from a desktop or laptop on Windows is it going to require a need to access the folders via Samba? If accessing the folders on the server directly isn't an option, would it be acceptable to copy the files in those folders to an alternate location and read them from there?

Does the sapadm account have to be used for Host Agent and the folder paths? Ideally, if we have multiple BIP Admins we would like to have individual user credentials to use with the tool vs sharing the the credentials of sapadm with multiple people.

Sorry, I didnt see your comment until now not sure why I'm not getting notifications. Here's the answers:. If you are using the Host Agent, you don't need to create any samba share. We did test this scenario and it is working ok.

I also want to mention that in the next patch 2. Please try this version when it becomes available early Aug. If you have anymore questions or concerns let me know. Hi I have a question related to largest instances. I am running a report in BI Platform Support tool, for the largest instances.

Please advice. Thanks Loki. Here's a teaser pic. Yes, we are done with development of version 2. We are aiming for end of the month but it could be early Sept for release depending on how everything goes. There will be communications on SCN and twitter once the version is released. Thanks Toby. I want to install this tool for a test but found something that I probably got wrong or needs to be corrected in the manual. In the paragraph where you wrote how to configure JMX for Tomcat, I find that the file in the image is not setenv.

As you can see below, all other configurations in setenv. Technically your right. When Tomcat is started by startup. Sourcing the variables set in a script has the same end result as exporting the variable from the startup. Toby, thanks a lot for the clarification, now I understand how it works and why it was like it is in the manual.

Hey Toby - unable to gather patch history errors I reviewed comment above and reviewed the recommendation to check that all forward slashes are back slashes in the landscape config, and they are. Any other suggestions on why this error might occur? Did you deploy the operations files on the server s? Also, publishing of the reports failed yesterday and is still failing today. Not sure if this is a known issue or if I have misconfigured something again?

Maybe your network is blocking outbound access to FTP protocol on port 21? The SFTP solution will be replaced soon with a web service which will be a much more accessible option.

Not blocking outboud on port I used to be able to submit files and I used to get emails back from the system. Recently, I changed my portal password. I wonder if it hasn't synced everywhere yet. Thanks for the reply. I see, maybe the FTP server was temporarily down. Please check network connections and try again.

Yesterday nigth I was able to restart tomcat for development system and sadly the port did not get opened. Today I found what looks to be the problem so just want to write to you to clarify something else. So according to logs, seems that I set port and authentication to false but then another line in the script setenv.

Here is the extract from the setenv. Thanks for your help, at the end everything worked fine. Now I will do some tests, probably an stupid question, but when doing universe consistency check there is no way to save the report. Is this rigth? Not a stupid question as it's not obvious but you can save the output of Universe Analyzer by going to File, Save, Save Landscape Analysis when you have the Universe Analysis results tab selected.

This will save the results in HTML format. Thanks again Toby for your patience and help, and thank you guys for this tool, in just some minutes I was able to get a LOT of information and recomendations for my systems. I've sent it off for publishing on Wed so it should be available anytime now. I'll post the new link asap.

According to some messages before, you mention that this is a problem with Host Agent version, the problem here is that we are using 7. Logging directory is configured in Landscape Configuration.

Regarding the issue, your Host Agent version is fine. It could be that the permissions are not strict enough on the operations files. If you face further issue after upgrading and fixing the permissions, please email me the sapstartsrv. E2E trace worked without problems now after installing the new patch and copying the new operations.

Also, I had problems also with patch History and now it is working flawlessly. Successfully ran and collected across 8 nodes; small issue when running across 16 nodes. Would you consider adding the name of the node to the status message?

If tool gets hung would be easy to see which node still requires the. That's great, thanks for the feedback. Yes, I could add the name of the node to the status bar, I'll add it to the backlog. Wanted to add to the wish list of features for the next version of Support Tool.

I tried on another machine and I'm running into same issue. I was able to get it to work and collect traces couple of random times. What version of IE are you running? Are you using the "Run As Administrator" option? You may also try to make sure that there are no residual iexplore. Is the problem specific to a particular workflow? What happens if you just try to trace the logon for BI Launchpad?

Does this work consistently? In the past I've seen this happen but usually closing all IE processes and trying again resulted in success. I have IE I'm using the BISupportTool This issue is with all the workflows.

The sent and receive bytes continues to be '0' and after about 2 mins, that window disappears. Sorry for the delay.

Hope you fared well with the hurricane. We are still without power in Volusia unfortunately. Then try to record a transaction and see if the sent bytes is showing transmission. With this test, we will know if it's an issue with the plugin itself or with the BIPST launching the plugin.

I followed instructions to install SAP Host agents,. Could you email me the logs from the server where the Host Agent is running? The log I'm looking for is sapstartsrv. My email is toby. Also, could you show me the permissions of the operations. In your landscape configuration where you configure Host Agent credentials for each node, are you using sapadm account and correct credentials?

Is this validating successfully? Thank you very much for your help; you were right about wrong credentials. I've been able to run a scenario , and record it, and anallyze it with GLFViewer.

This analyzing tool is very interesting, and I was wondering where I could find documentation around it. For example , do we have to set HIGH trace level during recording? It's quite hard to navigate through the log data flow, with event analyzer for example. I would be interested in event analyzer information also , or the log analyzer too. Have a look at these articles, I think they will help you to better understand how to parse the logs using FlexiLogReader and GLF Viewer and understand the workflow.

But when I look at :. Did you experience this? Please make sure you are using version 2. Also in the next version 2. I have a couple questions related to this very topic e2e tracing from the Support Tool. We do have the latest version of the Support Tool 2. Would the e2e tracing work from the Support Tool without the host agent deployed on the BO server?

Any insight to get the e2e tracing working over Citrix? In this case you don't need a Host Agent. In the case of promotion management, you would need to collect logs from 2 or more CMS landscapes but currently, BIPST only targets one environment at a time.

The others for example the PromMgmt and Destination landscape you would have to collect the logs yourself. Firstly, you typically need local admin access while running the sapclientplugin either manually or via the BIPST. Otherwise the plugin will be unable to create a proxy between IE and the server. To use the E2E Trace Wizard in the BIPST you need to configure your landscape under Landscape Configuration to use either a host agent or alternatively configure shared folder directories for each node.

Thanks Toby, very insightful! Your message made it clear that we do need to use the UNC patch to connect to connect to the BI and application server hosts, since we don't the Host Agent install on the BO node. However, the issue here is that our deployment is a RHEL6-based, we don't have Samba installed on the Linux nodes, either.

Are you able to run the sapclientplugin by using the option "Run As Administrator"? Appears the message: "Public access to folder expired". Can you put it accessible again? Sorry for the delay, I've been out on vacation. The NOUI link is updated now. Also, we will be releasing a new command line and scheduling option for 2. Thanks for raising this concern. If you download from the SAP download center, there is an md5 checksum which can be used to validate the software package.

However, this is a good idea and we will look at adding this to the next big release version 2. Was a couple of versions behind and just updated from 2. Excited to see the addition of using a random password and to disable new aliases to the Enterprise Alias Manager.

But, have a few questions:. If it's the former, any possibility of doing the later in the future as creating multiple accounts, even if they are disabled, all with the same password would be a violation of our security rules. Thanks for the info, that's great news. There is no urgency on the pword fix, but if you need testers, will be happy to help. I am able to collect all the metrics and reports from BI and also Tomcats. All the prerequisites have succeeded under Landscape Configuration and all has been validated.

However, after you launch Internet Explorer, the active SAP client plugin window should disappear and a new window with activated fields should launch again. In my case, there is no window launched at all and basically cannot trace anything as I am not able to Start Transaction,.. It just disappears and never launches back again. I am using Internet Explorer 10 native on Window Server Anyway, I managed to collect E2E traces manually, but just letting you know about this issue.

Thanks for reporting this issue. If so, try just running the BIPST client as the domainuser you are logged on to the Windows host with without the right click run as administrator. You may need to reconfigure your landscape configuration if this is the case since we depend on the user home directory for persisting the landscape configuration. Since we are switching the context of the user account "during run as administrator for the sapclientplugin step , it's best to just be logged on as a regular user when running the BIPST client.

On step 4, if your BusinessTransaction. Then continue with the log collection and it should work. Does the sapclientplugin work in this scenario? Let me know how it works out. I'm definitely very interested in making it work for you and would be willing to do a citrix gotomeeting if you face further trouble.

I am having an issue downloading the tool. I getting prompted for my S-User and Password during the download, but it does not seem to be authenticating to allow me to install. Can you try to browse for the software in the Software Download Center and download from there?

Refe to: How to download from the Software Download Center. There are no restrictions to download the software except your S-USER needs to general download permissions. You might need to contact your super user to have them grant download rights on the software download center. Support tool and The step by step configuration wiki that you have created is something called as Phenomenal work that you have done. Just wanted to appreciate your efforts to make the stuff so easy for US.

What is the status? Is there a planned features list? Feature development is done and we are in the product release and QA phase now. Should be early Q2 if all goes well. This week I'll post a blog on the SCN explaining all the new features and functionality, I'm happy to say we have implemented almost all of the customer requested enhancements made during Thanks Toby for the quick reply!

What you have written about the enhancements sounds promising this compensates the later release. Check port and authentication options and try again. I can confirm that the password is correct, the HostAgent Settings have been validated, the port that I am using is free so, it can be used and there is no Firewall blocking the communication.

Also, there is nothing logged in my Tomcat logs. You can send to my email toby. I downloaded the 2. I extracted it and ran the BISupportTool The installer won't start and the exe file just disappears from the folder. I have admin rights on my laptop, and I tried to run the installer from different locations and it is still the same issue. I'm trying to install it on a 64 Bit Windows 10 laptop.

I confirmed the media downloaded from the Software Download Center is installing ok. Go to your antivirus in your system tray and check there then add it to your trusted list. I am using McAfee here and do not have any issue. Let me know how it goes. I wanted to follow up and make sure this is resolved.

Feel free to email me at toby. You are right, I was able to get it installed on other machines and later on mine too. I think it was something to do with the antivirus. It would be nice if the differences between this note and what is included in the Support Tool could be shored up. I lost two days in processing a HIGH incident because of this discrepancy. Sorry for the confusion. Did they say what exactly was missing from the logs? Could you email me the incident number so I can follow up with them?

I was afraid that was the case, but it is difficult to tell support that I don't trust them. Would appreciate if you could follow up to close the gap. He advised the BusinessTransaction. I sent him an email to find out why he told you that. I think it's a training issue or something along those lines. Will try to rectify. There are some situations when passport does not kick in and some information are not grabbed, this is documented in Note In that case there is the need to manually set the server properties for trace log details to high.

The 'Change Analysis' feature was developed to compare two different extractions from the same landscape. This feature is basically doing a text comparison between the various data points. The original intent of this comparison feature was to compare the same landscape at two different moments in time.

Let's say you start to notice a new problem and you know some settings were changed a few weeks ago. Using the tool to go back and compare an extraction from a month ago to today's extraction might help uncover those changes.

We have spoken about the ability to compare two different landscapes but this hasn't made it into the current product just yet. But it is on the drawing board. Hello team! Any update on 2. Deploying a new system and wondering if I should load up 2. Development is finished. We are just waiting for security validation team and other release processes to conclude then it will be released.

Current RTC date is October 31 if all goes according to plan. Should also mention that upgrade to 2. Same as applying a patch version for 2. In the documentation for application updates, it states " Since all your history data and preferences are stored in your user roaming profile, this information will remain after the update. Therefore, to insure all system alerts are checked, make sure you run all available analysis types in your Landscape Analysis Report. System Alerts can now be disabled in the Alerting interface if you would no longer like to check for that specific alert.

Many new system alerts have been added in this version. In the event that the data contained in the report is confidential it is often impossible for this document with saved data to be provided to SAP. The Webi Doc Masker was designed to allow the customer to obfuscate and scramble sensitive report data before sending this to SAP Support.

The document formulas and structure are kept intact such that the original issue can still be reproduced.

The Webi Doc Masker works by first creating an xlsx datasource from each Webi dataprovider. Finally the new Webi document is published back to the CMS as specified by the end user. The aim is really to recreate a faulty behaviour as it appears in the original report to be reproduced on sap support side.

The obfuscation process is generating a secure, randomly generated transient dictionary that is only used once per session. The Publications Analyzer allows an administrator to explore the publications in their CMS system and get various metrics and detailed information about the publication objects and instances.

Predictive Support Alerts is a new support channel that goes live in When new configuration issues or bugs are discovered, we can understand which customer landscapes this issue applies to and proactively send you a customized email notification along with a solution. In version 2. One quick question on the Server and Services Alerts.

I tried to find a Best Practices document or Note that offered guidance on this setting without success. I found on blog post that suggested a maximum value of 2. When I return from holiday's I'll dig into it and let you know. Typically, all BI specific alerts come from an official whitepaper or some official documentation. I'll get back to you asap. We've been actively looking into this one during the break and I'll come back with more info once I have a better answer.

I found the SAP Note you referenced and although it does say to use 2, it's a note that probably needs to be archived. There's very little information in the note and it's not linked to a customer incident. Plus the engineer is no longer with SAP and we cannot ask for more details about why it was written. How do I share a Power BI dashboard or report?

Read about collaborating and sharing dashboards and reports. See limitations and considerations and troubleshoot sharing. How do I administer Power BI in my organization? How do I sign up for Power BI? If you get an error message when signing up for Power BI, see troubleshooting the sign-up process. Documentation Read in-depth articles on Power BI tools and features, from getting started to advanced techniques.

The software offers features for both advanced users such as data analysts and average business users. The SQL mode enables analysts to create their own queries while, on the other hand, the intuitive drag-and-drop interface ensures a visually intuitive way of entering your values and creating powerful charts and dashboards, simply by using effective visual analytics.

Intuitive drag-and-drop interface: Simply drag your KPIs into the interface and see how your charts and graphs transform into a professional dashboard without any IT involvement or advanced coding.

Easy-to-use predictive analytics: Advanced analytics features, including predictive analysis based on a forecast engine, where you simply select the KPI, determine the number of data points you want to forecast, specify the previous data points for the calculation, and finally define the model quality by appointing the desired confidence interval. Many interactive dashboard features: Dig deep into each part of the dashboard with advanced dashboard software features such as drill-downs, chart zooms, widget linking, hierarchical filters, among others, that will ensure a detailed data discovery process.

Multiple reporting options: Take advantage of BI reporting tools and create standard or customized reports by sharing via password-protected live URL, enabling viewer access, or sending an e-mail report which you can automate at specific time intervals. Additionally, you can embed datapine into your own application and get all the benefits of BI software without spending all the money and resources on one of your own.

Smart insights and alarms based on artificial intelligence: With artificial intelligence, machine learning, and pattern recognition technologies, they alert the user if a business anomaly occurs or generate multiple types of insights, including growth, trends, value drivers, what-if scenarios, among others. They do offer mobile access, but the dashboards are not directly accessible unless you download their app and customize them within the mobile view.

SAS Business Intelligence is a BI tool offering numerous products and technologies for data scientists, text analysts, data engineers, forecasting analysts, econometricians, and optimization modelers, among others.

Founded in the 70s, SAS Business Intelligence enjoys a long tradition in the market, building and expanding its products every year. With a Capterra rating of 4. Text analytics capabilities: Interesting features are text analytics that enables you to gain insights from text data such as social media and location analytics that combines data in a geographical context.

Reports and dashboards across devices: Dynamic visuals are organized into interactive reports and dashboards, similar to other tools in our lists, and you can access them also on mobile and tablet devices both Android and iOS. Considering the complexity of the product and its offers, the higher price range and limited customization options can be huge factors in deciding if this business intelligence tool would be the right choice, as most users indicate on Capterra and G2crowd. Infor Birst is a cloud-based analytics and business intelligence platform that helps users to understand and optimize complex processes.

Infor, a global company with an extensive portfolio of software products for specific industries, acquired Birst in Today, Infor Birst is an advanced end-to-end solution with a data warehouse, visualization and reporting platform, and a networked BI approach based on extensive automation and learning technologies. Customers of the BI vendor rated the software with a solid 4. Modern data architecture: Birst's native cloud BI platform is based on Infor's modern data architecture. The advantages of this are high flexibility, data security as well as scalability to adapt to changing business conditions.

Adaptive interface: Cross-device access to the platform that meets the needs of modern work styles, enabling a positive user experience with the same interface, whether online or offline. Embedded BI: Infor Birst's cloud solution gives you the option to integrate it with your own application. This allows you to monetize data in a familiar software environment without having to develop an analytics product yourself. Industry analytics: Different role and industry-specific data models, as well as analysis options, are offered.

With their help, specific trends but also weak signals can be identified in order to react to them at an early stage and increase profitability. Some customer reviews describe the user interface as confusing in parts. In addition, data integration is more complicated than described, as the business intelligence tool does not create a data model based on the linked data sources in a completely automated way.

SAP BusinessObjects is a business intelligence platform designed for comprehensive reporting, analysis, and data visualization. They provide Office integrations with Excel and PowerPoint where you can create live presentations and hybrid analytics that connects to their on-premises and cloud SAP systems. To be accurate, more than M users leverage SAP across the world, making it one of the largest software suppliers in the world.

On Capterra, the company obtained a review of 4. A BI enterprise reporting system: Reporting and analysis are done with ad hoc queries and a complex BI enterprise reporting system designed to guide your overall company strategy. Self-service, role-based dashboards: Analytics applications and data visualization are focused on self-service capabilities, similar to other tools, where you can build your own role-based dashboards and applications to assess risks, for example.

Cross-enterprise sharing: You can create a cross-enterprise sharing functionality that will enable you to communicate your findings with other stakeholders and partners. Integration with Office: By using Microsoft Excel with SAP, you can analyze larger volumes of data, and embed analytics in PowerPoint, making this solution easily integrated with Office.

Some reviews report that extensive analysis functions are rarely usable without additional user training. In addition, the costs for the individual modules are relatively high and there are comparatively few feature updates. Domo is a business intelligence software comprised of multiple systems that are featured in this platform, starting with connecting the data and finishing with extending data with pre-built and custom apps from the Domo Appstore.

You can use Domo also for your data lakes, warehouses, and ETL tools, alongside R or Python scripts to prepare data for predictive modeling. Similar to other tools, you can connect the data across your enterprise, utilize their machine learning and artificial intelligence capabilities while enabling users to explore the data on their own.

With a firm 4. Automatically suggested visualizations: Data visualization enables you to go from raw data to charts, graphs, maps, and other visualizations which are suggested automatically by Domo after you upload your data source. You can refine the data, annotate for further commentary or discussions, or refine and control who has access to it. Roboto as an AI engine: Predictive analysis is powered with Mr.

Domo Appstore: Their open cloud platform is an ecosystem of pre-built apps, connector APIs and dashboards, giving you also the possibility to build your own and share it on the Domo Appstore. Domo is not built for newcomers as the learning curve can be steep, but they do offer training, therefore, be prepared to learn. Oracle Business Intelligence is a portfolio of technology and applications with a focus on providing end-to-end solutions to help businesses optimize their performance and empower them to make faster and more informed mobile-enabled decision-making.

Oracle has 4. Ad hoc capabilities Oracle BI answers: This feature provides users with true ad hoc capabilities in an intuitive way.

With no room for complex processes and preventing runaway queries, users can easily generate charts and visualize their data fast and efficiently.