Iniciar sesión
 
InicioBibliotecaAprendizajeDescargaSoporteComunidadForos
Recursos para Profesionales de TI >
> 
> 
How to add a company dimension/view in the standard reports?

问题 How to add a company dimension/view in the standard reports?

  • jueves, 05 de julio de 2012 9:06
     
     
    Inicie sesión para votar
    0

    Dear SCSM people,

    How to add a company dimension/view in the standard reports?

    I would like to use the SCSM standard incident management reports by company.

    Unfortanetly the standard reports does not contain the possibility to create a view per company. The company field is part of the affected user table.

    I'm wondering if there is an example how to customize the reports to include the company field? Any suggestions?

    In my opinion a solution can be setting up a master data table with company information and connect this table to the user table.

    At the end this must be integrated and customized in the datawarehouse too.

    Looking forward to discuss this further!

    Thanks in advance.

     

Todas las respuestas

  • jueves, 05 de julio de 2012 19:50
    Moderador
     
     
    Inicie sesión para votar
    0

    Please see my response to your comment on my blog:

    http://scsmnz.net/how-to-get-your-incident-logs-from-the-data-warehouse-into-your-report/#comment-171

    Rob Ford scsmnz.net


     
  • viernes, 06 de julio de 2012 10:04
     
     
    Inicie sesión para votar
    0

    Do you have any idea if a customer masterdata table will be part of the SCSM datawarehouse roadmap?

     
  • domingo, 08 de julio de 2012 18:55
    Moderador
     
     
    Inicie sesión para votar
    0
    Perhaps I have misunderstood your requirements? Not sure. Check the view UserDimVw in the Data Warehouse, this exists by default. Does this not contain the information you require?

    Rob Ford scsmnz.net

     
  • lunes, 16 de julio de 2012 8:56
     
     
    Inicie sesión para votar
    0

    Hi Rob, thanks for your reply.

    Yes it is true, the UserDimVw contain the user/company information. But I'm looking forward to a solution with a seperate company table to setup multiple users per customer and create numberranges for different companies in a seperate company table. At this moment the company field is just a text field, not the best way for creating reports...:)

    Any suggestions, best practices and/or examples?

    Br,

    Guido

     
  • lunes, 16 de julio de 2012 19:27
    Moderador
     
     
    Inicie sesión para votar
    0

    You could create a new class, say, "Company", and a new relationship "UserRelatesToCompany" that links a user CI to an instance of "Company". You'd obviously have to create some way of linking the two, perhaps a custom console task that creates the relationship. If you create a dim and fact for your class and relationship, this could then be reported on from the DW. Also, you'd need some way to create/import your company data.

    So, it is a little work but possible.

    Rob Ford scsmnz.net



     
  • viernes, 20 de julio de 2012 7:53
     
     
    Inicie sesión para votar
    0

    Hi Rob, thanks for your reply. I can imagine this is customizable.

    If you use SCSM for multi-company purpose a 'company' table will be a must have to create reports per customer.

    Shouldn't this be part of standard SCSM out-of-the-box BI functionality?

    Any idea if this is part of the SCSM roadmap?


    • Editado GuidoP martes, 24 de julio de 2012 8:56
    •