Excel Pivot Table on Web Page

Question

This is probably a closed-ended question, but in fact, I believe that Stackoverflow is the best source where you can find a practical answer.

I am working on a webpage displaying a pivot table. My solution is based on pure jQuery + html. Still works well, although some css work is still needed. Anyway, my project manager asks me to try to place the excel pivot table table connecting the analisys services as an object in the browser. I don’t like too much of such a solution, but I need to have a few more points than just saying that it is an outdated architecture. The first point that comes to me is that it only works in IE, but, unfortunately, the end client is not only happy with this, but also requires IE. Another interesting point is that the protocol that this funny beast is likely to use to communicate with the server is not something like HTTP, just to make the firewall happy. The end customer (yes, the one who says that IE is a must) will eventually want to see an application running on the iPad, even if the project seems to be developing someday, I doubt Apple will be enough this time. to properly ActiveX object in Safari.

What? The reason moi is pointless, moreover, you see?

Answer 1

Enterprise decisions are based on data and infrastructure, not code.

• If all your customer data is stored in Analysis Services, then all of your jQuery + CSS workshops do not matter if they cannot rotate the data they want

• Analysis Services custom protocol is designed to create billions of records; your jQuery / CSS may not be scalable yet.

• Most enterprises only have IE6 / 7 infrastructure, they don’t even have Firefox, not to mention Chrome. They want you to support IE, not update every desktop.

• Customers who emphasize IE compatibility are unlikely to get around iPad support in their infrastructure. Think about it. Worry about things when they come, and don't waste your efforts on skeptical / fictional things. My favorite quote here as a programmer is:

  We design architectures and frameworks that support thousands of future opportunities. The customer somehow manages to come up with a thousand and something that we never planned. Surely they should be smarter than us?

So, you need to have an open mind regarding what you were asked to do.

I apologize if this post does not directly answer your question. But I want to leave it that way.