on 10-08-2012 6:50 PM
Hi,
I have a question, as the topic, we have a customer going to running on SSM7.5 but there is a upgrade to SSM10 in December.
There are about 140 scorecards and around 3500 KPIs, considered business connect between these scorecard ( A problem with the capacity for the number of kpis to built Pas Model , we made many cubes and in some cases dont link with some scorecards).
In SSM 7.5 have one Pas Model for many scorecard (approximatelly 8 to 12 socrecards) , therefore we built many cubes to group scorecards and kpis.
In SSM10 I want to know how many metrics(kpis) in the PAS Model can built? Because the version SSM7.5 have 400 kpis standard and index kpis for dimensional model. Watch the attach file. I checked to make the PAS model in SSM 7.5 and not allow me to add more than 200 KPIs (200 * 2=400 , I guess the option "Yes" in the KPI generated target and actual kpi).
I read SSM 10 and not found the maximum or limit for "kpis" in the dimensional model.
I found 5000 measures or more(MAXSETS=x)...? , but I understand that one KPI have 5 measures, so (5000 measures / 5 ) = 1000 kpis???... I want to know what is the diferrence between SSM 7.5 to SSM 10 in the number of kpis of pas model?
Can I build a single PAS model and link to many scorecards with more than 200 kpis in SSM 10?
Please, help
Thanks.
Regards,
Amado
I can't directly answer your question, but believe PAS is easily able to excede those numbers. Your assumption that 5000 measures = 1000 KPIs is valid.
However my concern is do you really have 3500 KPIs? This is an extraordinary number and I wonder whether you are not modelling correctly. Typically the same KPI will appear in multiple scorecards. If I have a KPI of Staff Satisfaction, and if I have 140 scorecards I do not need 140 KPIs. Usually scorecards represent different departments of an orgnaisation. If I have 140 departments, I would deal with it as follows:
Typically 140 departments might have 25 KPIs each but most of these would be shared over multiple departments. I would be surprised if you needed more than 200 core KPIs and maybe another 500 single scorecard KPIs.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you very much, is a great feedback...
I have a new question, is there a way to connect multiple PAS model (cubes) with a single context? Can have kpis with loaded That is, I found some metrics in different cubes and I want to connect to a single context. Do not think it's a very important limiting?
In SSM 7.5 can not be, I want to know whether the SSM version 10 can be made.
I ask this question because the scenario are 140 scorecards, effectivately on average are 25 KPIs for each scorecard, but the problem is that there are 500 or 600 core KPIs in multiple departments, and 1000 or 1100 single scorecard KPIs.
If SSM 7.5 have 200 metrics in the cube, what I recommended for modelling?
Does it change the scenario when you design your modellling in SSM 7.5 if there is a upgrade to SSM 10?
Any suggestion?
Regards,
Amado
My exposure to V10 is limited (sorry) but I do not think there are many changes from V7.5 with regards to these modelling issues. The changes were more in the presentation.
I do not believe a single context can read multiple cubes because the scorecard uses a connection and the connection is the link to the cube.
I would try to make a single large cube. I am confident PAS can handle vary large numbers of measures and that the advertised limits are merely recommendations. Try a test on a large cube with all your measures and see what happens.
Another path to check is that PAS has a way to link cubes into virtual cubes. I have read about it but not used it, but it might be a way to join your cubes.
Amado,
A single Context can only by linked to a single PAS model but a model can have up to 10,000 metrics which is the equivalent of 2,000 KPIs.
If you do need more than that or you suspect that you will then you can go to a multi-model appraoch so that the base more operational KPIs only appear in the models that power the more operational levels of your Contexts. Where you need the data in multiple models then you can either load it multiple times or move it between models (see the discussion at http://scn.sap.com/thread/3205742 )
In SSM 7.5 there was a limit of 200 KPIs within a Context but this limit does not appear to be there in SSM 10. However if you have even close to 200 KPIs in a Context you should be asking yourself how 'Key' those KPIs really are!
Regards
Colin Cooper
User | Count |
---|---|
12 | |
3 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.