GANTT Charts

[Alfredomulet]

Hello there, can you create Gantt Charts with Microstrategy? If so, can anyone give me some guidelines on how to get started?

Thanks in advance for your help in this matter,

Alfredo

 

[Z3]

Sure. We have done before in 2000. MicroStrategy returns data in XML, so you just need to format it with XSL or ASP or JSP. The key is to get an HTML sample that users like, then you just write your code (XSL, JSP, ASP) by looking at the XML and HTML. I believe MSTR also has a kit to do Gantt charts - contact them to see if you can have someone doing it in a few weeks.

 

[Alfredomulet]

Thanks z3, I was expecting to create the Gantt without XSL customization (maybe using the column graphs), since the graph details are very simple.

Whe have 5 sales rep. An objective of customers to visit on a given week, the customer visited on this week and the customers remaining to visit.

The idea is to have a chart like:

SALES CYCLE
SALES REP M T W TH F M T W TH F M T W TH F M T W TH F
Alfredo ---------------+++++++++++
Jose L. --------++++++++++++++++++

where - are customer visited and + are number of customers remaining (sum of - plus + gives me the total assigned).

Piled columns maybe??
cheers,
alfredo

 

[Z3]

In that case your XSL is going to be very simple. It's not worth trying other options.

I don't know a way to have the correct # of '-' or '+' signs displayed on a graph that scales correctly. That's a lot to ask to the graphic engine.