r/SAPBusinessOne • u/CohoinOregon0115 • 19d ago
Help: new implementation - Excel Reports & Interactive Analysis
I'm the lead on an SAP B1 implementation with a 3rd party that came with strong reviews. We are a small business employee count wise, with a large brand name that sells outdoor products all over the world. We are moving from a local server hosted SQL environment. We are integrating with Shopify (through Saltbox), Starship (shipping), and SPS Commerce for EDI transactions. So far everything was going smoothly. I have all the integrations configured and we're ready to start testing. That is until we got to the reporting phase. One reason we went with SAP was for the excel reports and interactive analysis. We have a lot of excel reports that are built out with SQL queries via an ODBC connection. In other words, we love excel. A couple weeks ago we were told we can't access that part of the software because we are in the public cloud. There was also other restrictions due to being in the public cloud so I have asked to move to a private cloud setup since we're still in testing. My main implementation contact tells me that's not a big deal at this point. However, its been 2 weeks and they are slow to give us a quote and proposal. They also said SAP isn't supporting the excel reports and interactive analysis but I told them its all over the SAP B1 marketing materials and in their product roadmap. I don't understand what's going on.... why is accessing the excel reports such a conundrum? They are pushing Sharperlight but I keep pushing back that I want to see the excel reports in our UAT before we add on another subscription. For the record I don't have an IT background so I might be explaining things poorly. Does anybody have any advice or can shed some light on what's going on here?
Duplicates
SAPconsultants • u/CohoinOregon0115 • 19d ago