Use dropdowns in reports

[dcolleoni]

Attach dropdown to settable prop of Report Mutable Scope.

-Work on issue with Slices: Some default slices make more sense after some non default slices: Eg in PV EconomicBasis is default but when slice by GroupOfContracct is selected it is better to slice before by GOC and then by EconomicBasis

-Work on issue with Filter: Select multiple options: the following scenario should be allowed: Filter by Dim1: EconomicBasis = L Filter by Dim2: GOC = [GIC1,GIC2]

in total there are 3 filters and the resulting filter should be: Filter(Dim1) & ( Filter(Dim2,GIC1) || Filter(Dim2,GIC2) )

[dcolleoni]

Dear @dtrzesniak dear @andrey-katz-systemorph
I have summarized here our discussion and assigned priority to the todos. Pls review and let me know if anything is missing or needs correction. Thanks!

List of remaining todos discussed today:

• Scenario scope :

  1. Short term populate the dropdown with "Delta" and "All" options. PRIO1 Long term extract a ComparisonView scope, more general than comparison of scenarios. PRIO3

• ReportingNode scope :

  1. rename controller variable and backend variable (to support old way of reporting from NB) => extend to all scopes PRIO3
  2. trigger init of ReportingNodeMapping if null => (to support old way of reporting from NB) PRIO3

• Filters scope:

  1. decide whether to wait for new controllers or improve current version => align on timeline from platform
  2. FilterName => init with a method to be overwritten in each scope inheriting this one PRIO1
  3. All queries should use GetAutocompleteMappings PRIO1
  4. move queries to the storage PRIO2
  5. Filter can handle or cases => adapt controllers and backend PRIO2

• Slice scope:

  1. same point 1 of filter applies here
  2. separate slicesForRows from SliceForColumns PRIO1
  3. sliceColumn/RowName is init with a method to be overwritten in each scope inheriting this one PRIO1 or define a generic to which each scopes adds/remove. note : put the options is some logical order (RN,GOC, close together)

• Data scope

  1. remove filter from id. Create a method return filtered DataCube PRIO2

• Report scope:

  1. add method to generate an export (support both xlsx and csv) PRIO1
  2. add method to generate graph PRIO2
  3. add method to report .ForObject PRIO1

• ReportScopes:

  1. check default slices PRIO1
  2. test adding [NotVisible] to hide controllers PRIO2

• ReportConfigurationAndUtils:

  1. GetAutocompleteMappings : support Hierarchical Dimensions and Ordered dimension and make use of the order to order the dropdownvalues PRIO3