Hi, hope everyone's well.
I'm new to the reportnet world so please bear with me. I have been presented with a project which involves analysis regarding our corporate "customers" and "products" with multiple navigation routes to the facts.
I wanted to get some expert input as to the optimal solution for the challenge.
Basically, the users have requested multi-analysis cube type logic to analyze either our customer base or product line. The specifications require that there is a hierarchical level of reporting for both of the analysis subjects and, at any point in time, different dimensions may be selected by clicking a measure of interest leading to details of that measure. The report must be presented in a crosstab with time dimensions and there are 6 or so levels of "drill-down" or analysis views in total.
The initial scope at a glance seemed to be a solution which would have 30 or so reports encompassing all the different views of the data but I'm convinced there has to be a better way to do this than 30 linked/multi-drill reports. I can only imagine the administration and maintenance nightmare.
One solution recommended was to create stored procedures with parameters for the different navigation paths/levels, thus directing a majority of the work at the back end rather than in Reportnet, and reducing the number or reports to about 12 or so. The data group however, does not agree with this solution stating that there should not be back-end programs created for the purposes of reporting and that the reporting tool should be utilized to its fullest potential.
I'm convinced that that the solution may lie in 2 or 3 complex reports with multiple conditional parameners and crosstabs which "hide" and "show" crosstabs based on a criteria matrix and input from the parent report(s).
Any additional thoughts or opinions would be greatly appreciated.
Were utilizing 1.1 mr2 by the way.
Cheers!
I'm new to the reportnet world so please bear with me. I have been presented with a project which involves analysis regarding our corporate "customers" and "products" with multiple navigation routes to the facts.
I wanted to get some expert input as to the optimal solution for the challenge.
Basically, the users have requested multi-analysis cube type logic to analyze either our customer base or product line. The specifications require that there is a hierarchical level of reporting for both of the analysis subjects and, at any point in time, different dimensions may be selected by clicking a measure of interest leading to details of that measure. The report must be presented in a crosstab with time dimensions and there are 6 or so levels of "drill-down" or analysis views in total.
The initial scope at a glance seemed to be a solution which would have 30 or so reports encompassing all the different views of the data but I'm convinced there has to be a better way to do this than 30 linked/multi-drill reports. I can only imagine the administration and maintenance nightmare.
One solution recommended was to create stored procedures with parameters for the different navigation paths/levels, thus directing a majority of the work at the back end rather than in Reportnet, and reducing the number or reports to about 12 or so. The data group however, does not agree with this solution stating that there should not be back-end programs created for the purposes of reporting and that the reporting tool should be utilized to its fullest potential.
I'm convinced that that the solution may lie in 2 or 3 complex reports with multiple conditional parameners and crosstabs which "hide" and "show" crosstabs based on a criteria matrix and input from the parent report(s).
Any additional thoughts or opinions would be greatly appreciated.
Were utilizing 1.1 mr2 by the way.
Cheers!