Difference between revisions of "Wish List"

From Wiki
Jump to: navigation, search
(DataEntry Report)
(DataEntry Report)
 
(39 intermediate revisions by the same user not shown)
Line 4: Line 4:
 
* Import Excel or Text file to a Filter via the Search button [http://www.reportportal.com/forum/topic.asp?TOPIC_ID=1698]
 
* Import Excel or Text file to a Filter via the Search button [http://www.reportportal.com/forum/topic.asp?TOPIC_ID=1698]
 
* Make Filter like OWC Filter. Parent member to get highlighted if I select any child member.
 
* Make Filter like OWC Filter. Parent member to get highlighted if I select any child member.
* Date Calulations: Ability to modify the number of trailing days
+
* Date Calculations: Ability to modify the number of trailing days
* Filter to have Exclude option [http://www.reportportal.com/forum/topic.asp?TOPIC_ID=608]
+
* Pin feature can be modified to include Data Calculations.  Custom range function for each level. 
 +
* Filter to have Exclude option [http://www.reportportal.com/forum/topic.asp?TOPIC_ID=608]. Where ([Dim Content].[Format Class].&[eBook], EXCEPT([Dim Content].[Publisher].[All].Children,[Dim Content].[Publisher].[LexisNexis])).
 
* Filter Display Modes: (Should multi-select be just another mode?)
 
* Filter Display Modes: (Should multi-select be just another mode?)
** Page Mode: play, stop, next, prev, dropdown buttons.
+
** Page Mode: play, stop, next, prev, drop down buttons.
 
** Time-line slider mode
 
** Time-line slider mode
** Panel Mode: have the height of the pulldown menu in the Dimension Filter in the Page Area be as high as the first level items so there is no need for scrolling down or changing the height with the mouse. [http://powerpivotpro.files.wordpress.com/2009/11/powerpivotreport.jpg]
+
** Panel Mode: have the height of the pull down menu in the Dimension Filter in the Page Area be as high as the first level items so there is no need for scrolling down or changing the height with the mouse. [http://powerpivotpro.files.wordpress.com/2009/11/powerpivotreport.jpg]
 
** Measure number range mode: similar to Rows Filter but with a slider interface.
 
** Measure number range mode: similar to Rows Filter but with a slider interface.
* When you select multiple elements add checkbox to show the rest as a row (similar to Top)
+
* When you select multiple elements add check-box to show the rest as a row (similar to Top)
 +
* Filter option to show parent level.  Instead of January show 2015-January. Instead of Q1 show 2015-Q1.
  
 
====Grid====
 
====Grid====
Line 35: Line 37:
 
* [http://www.humblesoftware.com/ interactive chart based on time]
 
* [http://www.humblesoftware.com/ interactive chart based on time]
 
* [http://jsfiddle.net/calfzhou/TUt2U/ Variable Width bar chart]
 
* [http://jsfiddle.net/calfzhou/TUt2U/ Variable Width bar chart]
 +
* [https://developers.google.com/chart/interactive/docs/more_charts TermCloud]
  
 
====GeoCharts====
 
====GeoCharts====
Line 51: Line 54:
 
* Organize calculated members and named sets into folders (alexian)
 
* Organize calculated members and named sets into folders (alexian)
 
* Select the measure group for the field list
 
* Select the measure group for the field list
 +
* New Tab: Colorss for Conditional formatting: with member [Measures].[sss] as [Measures].[Internet Sales Amount], FORE_COLOR= RGB(255,0,0), back_color= IIF([Measures].[Store Cost] > 50000, RGB(0,255,0), RGB(225,0,0)) [http://www.databasejournal.com/img/2007/05/ANSYS059_002.jpg]
  
 
====Named Sets====
 
====Named Sets====
Line 58: Line 62:
 
* Ability to build named set based on existing named set
 
* Ability to build named set based on existing named set
 
* Show named sets in a separate folder in the field list
 
* Show named sets in a separate folder in the field list
 +
* Organize named-sets in folders
  
 
====Field List====
 
====Field List====
* Support multiple display folders for a single measure  [http://sqlblog.com/blogs/mosha/archive/2006/12/13/display-folders.aspx]
+
* Support "Sub" display folders for dimensions
* Support "Sub" display folders for other than KPI
+
 
* Show Filter Groups like Adventure Works as in Tableau Software
 
* Show Filter Groups like Adventure Works as in Tableau Software
 
* Ability to dock to right
 
* Ability to dock to right
 
* Add Search capability [http://rquintino.wordpress.com/2012/12/04/smartpivot-new-beta-release-with-ssas-and-powerpivot-instant-text-search-now-supports-for-excel2013/]
 
* Add Search capability [http://rquintino.wordpress.com/2012/12/04/smartpivot-new-beta-release-with-ssas-and-powerpivot-instant-text-search-now-supports-for-excel2013/]
 +
* Drop dimension  dimension to measures to see district count like: Count(NonEmptyCrossJoin([Customers].[Name].Members))
  
 
====Sparklines====
 
====Sparklines====
Line 78: Line 83:
  
 
====OLAP Other ====
 
====OLAP Other ====
 +
* Paging: Replace last button name with the last page number.  Remove 1 "of 123". Hide last and first buttons when it is the last of first page.
 
* Ability to expand and multi-select measures Asymmetrically
 
* Ability to expand and multi-select measures Asymmetrically
 
* Page/margin selection dialog before printing
 
* Page/margin selection dialog before printing
Line 91: Line 97:
 
* Report option to enable "HTML output escaping"
 
* Report option to enable "HTML output escaping"
 
* Allow saving of private cell comments.  Currently, everyone can see all comments.
 
* Allow saving of private cell comments.  Currently, everyone can see all comments.
 +
* Measure formatting option: create an XMLA session to run two MDX queries like Language(Measures.Members) = 1046; Select non empty {[Measures].[Unit Sales]} on columns From [Sales]
 +
* ROLAP Report Action
  
 
====Conditional formatting ====
 
====Conditional formatting ====
Line 98: Line 106:
 
==Tree Map Report==
 
==Tree Map Report==
 
* Add calculated measures from the OLAP shared library
 
* Add calculated measures from the OLAP shared library
 +
* Add 'Go Back' button. (When I drill-down to next level, I can't go back to previous level.)
 +
* Time Filter Slider (as in moving bubble)
  
 
==Pie-Chart Report==
 
==Pie-Chart Report==
Line 131: Line 141:
 
* Cell Exception highlighting (painting) – 40 hours
 
* Cell Exception highlighting (painting) – 40 hours
 
* KPI inside the cube cells – 40 hours
 
* KPI inside the cube cells – 40 hours
* Add UNION mode
 
* Add Expand Mode [http://www.reportportal.com/wiki/images/RolapExpand.xml]
 
 
* Ability add computed metric at the "top level" like: sum(p.total - p.internal_total_cost) / sum(nullif(p.total, 0)) as gross_margin
 
* Ability add computed metric at the "top level" like: sum(p.total - p.internal_total_cost) / sum(nullif(p.total, 0)) as gross_margin
 
* Filter Type: Date Range
 
* Filter Type: Date Range
* All member for columns and filters
 
 
* Parent-Child Dimension Type
 
* Parent-Child Dimension Type
 
* Add Top-N using "cross apply" SQL clause
 
* Add Top-N using "cross apply" SQL clause
 
* Support hierarchy on Columns in expand mode
 
* Support hierarchy on Columns in expand mode
 +
* Alternate Cell Color: tr.RowData:nth-child(2n) td
  
 
==SQL Report==
 
==SQL Report==
 +
* Date Filter Calculations: This Year, This Quarter, Previous Quarter, This Month, Previous Month, Last 3 months.
 
* Add Gantt Chart as Chart Type for SQL Reports [http://www.fusioncharts.com/free/Gallery.asp?gMenuItemId=3]
 
* Add Gantt Chart as Chart Type for SQL Reports [http://www.fusioncharts.com/free/Gallery.asp?gMenuItemId=3]
 
* Add number of records in the View button so you see the number of records will lower when you choice from page filters
 
* Add number of records in the View button so you see the number of records will lower when you choice from page filters
Line 195: Line 204:
 
* Option to have a summary tab that would list all of the reports and filters used in the dashboard.
 
* Option to have a summary tab that would list all of the reports and filters used in the dashboard.
 
* Add a Button to add a Reporting Services URL with parameters is there is in Dashboard to be transferred to show the Reporting Services report based on the Page Filters in Dashboard.  
 
* Add a Button to add a Reporting Services URL with parameters is there is in Dashboard to be transferred to show the Reporting Services report based on the Page Filters in Dashboard.  
* Add a feature to drag and drop tabs to have another sort / order
 
 
* Excel Chart exporting
 
* Excel Chart exporting
 
* Add multiple reports at once
 
* Add multiple reports at once
 
* Chart/Grid toggle
 
* Chart/Grid toggle
* New Report Option next to "Refresh Rate": Refresh tabs sequentially (like: 1,2,3,1,2,...)
 
 
* Add the search capability to non-OLAP reports
 
* Add the search capability to non-OLAP reports
  
 
==DataEntry Report==
 
==DataEntry Report==
* Add "Next" and "Previous" buttons to the top of the left data navigational tree
+
* Custom Validation for textbox (Email, URL)
* Custom Validation for textbox (Email, URL, Number Range)
+
* New Column Type: Slider http://www.eyecon.ro/bootstrap-slider/
* Custom Validation for textbox (Currency = numbers only)
+
* Formatting for numeric values (like 1,234.56)
+
 
* Radio Button - manual list has Value and Text.  Add image for an optional icon next to the Text.
 
* Radio Button - manual list has Value and Text.  Add image for an optional icon next to the Text.
* Import data into the  grid
 
 
* Validation of minimum and maximum value for numeric and date fields
 
* Validation of minimum and maximum value for numeric and date fields
* Type=File to be available for text fields.  The text field will store file name.  Attributes for this type will be Folder path and "Folder Indexed" checkbox indicating if the user can search the contents inside of the folder. When file is uploaded it will go to the folder and update the field with the file name.
+
* Edit Grid to show textbox and drop down only when a cell is clicked
* Edit Grid to show textbox and dropdown only when a cell is clicked
+
 
* Ability to hide folders in the Data Entry tree (because you already have tabs)
 
* Ability to hide folders in the Data Entry tree (because you already have tabs)
* Add a new checkbox under Columns panel called "Grid Filter"This will let you filter the grid by one or more filters.
+
* Connect Dialog to accept SQL. Will create new SQL panel.  View only mode (insert, delete, update options not available)
* The ability to create a dependent many-to-many available list is not currently available.  It will be dependent on other dropdowns and other many-to-many selected lists.
+
* Ability to use forms from other connections
* For new forms, suggest List table and column based on the foreign keys
+
* Wizard to be able to create multiple forms for a connection.
* In design mode, "Used By" tab that would show forms using this form
+
* List Type = Table > (Set to current column) : suggest List table and column based on the foreign keys
 +
* With Report ID store Table and Database name (in case report is re-created and id changes)
 +
* Conditional formatting based on a value (http://www.reportportal.com/forum/topic.asp?TOPIC_ID=1941)
 +
* If a table is referencing or is being referenced by other tables and child (and forms are not defined) there should "virtual" child or parent nodes (the name column should be the first text field with the word “name” in it)
 +
* Child Data Entry Form, Type = Parent to create DB lookup to be able to change the parent
 +
* Connect dialog - "View Only" checkbox
 +
* Grid Export: Include Lookup fields
 +
* Save Record History: Select and create History table
 +
* Search - between col1 and col2
 +
* Actions - New PDF Merge Type
 +
 
 +
* Design : Child
 +
** match Local Column and Key Column on "Local Column" select
 +
** button to add forms that are linked to this form
 +
** When a new form is created, child / parents forms will be added based on foreign keys
 +
 
 +
* When "Name Column" is checked present another checkbox: "Group By Column"
 +
** Ability to select another Icon
 +
** Multiple Group by columns?
 +
** Calculated Column
  
 
==RP Subscription Services==
 
==RP Subscription Services==
* Support for other Report Types: [[SSRS Scheduler| SSRS Server Report]], KPI, KPI 2005, SQL view report  
+
* Support for other Report Types: KPI, KPI 2005, SQL view report  
 
* Add Schedule to support for example: Every week on mon till Fri from 08:00 till 17:30 every 1 hour (like in Windows 2003 Scheduler)
 
* Add Schedule to support for example: Every week on mon till Fri from 08:00 till 17:30 every 1 hour (like in Windows 2003 Scheduler)
 
* Create automatic folders based on the snapshot creation date (like Jan-2008, Feb-2008,…) when number of snapshots exceeds a threshold (10)
 
* Create automatic folders based on the snapshot creation date (like Jan-2008, Feb-2008,…) when number of snapshots exceeds a threshold (10)
Line 254: Line 276:
 
** Report name > Show Folder Path
 
** Report name > Show Folder Path
 
** OLAP (or SQL, ROLAP) Report > Exporting > Header = Always Export, Don't Export, Ask during exporting (credo2u)
 
** OLAP (or SQL, ROLAP) Report > Exporting > Header = Always Export, Don't Export, Ask during exporting (credo2u)
** Ratigns: ability to clear ratings per roport and/or all reports
+
** Ratings: ability to clear ratings per report and/or all reports
** Report Tree > Folder visibility in the view mode (dropdown): 1-Show all folders, 2-Show folders with reports only, 3-Show allowed folders only
+
** Report Tree > Folder visibility in the view mode (drop down): 1-Show all folders, 2-Show folders with reports only, 3-Show allowed folders only
 +
** New Admin option Admin > Security > “Show login page only when Windows password is blank or invalid”. 
 +
*** This option will be visible only when Admin > Security > Security Authentication Mode = “Windows | Mixed” and Enable pass-through authentication = True.
 +
*** Maybe this option is not needed and Security > “XML for Analysis Security Enabled” should be used instead?
 
* Role-Connection updating feature to support multiple roles. In that case, the user will need to select connection, server, database or a cube before viewing a report.  (Accretive)
 
* Role-Connection updating feature to support multiple roles. In that case, the user will need to select connection, server, database or a cube before viewing a report.  (Accretive)
 
* Admin > Selected Report Types > Ability to add new report type groups and move report type groups up and down
 
* Admin > Selected Report Types > Ability to add new report type groups and move report type groups up and down
Line 274: Line 299:
 
* Tie Private reports to the original report. An admin option will determine if all of the private reports will be deleted when the original report is deleted or has its security changed.
 
* Tie Private reports to the original report. An admin option will determine if all of the private reports will be deleted when the original report is deleted or has its security changed.
 
* Ability to restrict GetSecurityToken to a report
 
* Ability to restrict GetSecurityToken to a report
* Encrypt/Decrypt - support for unicode
 
 
* Windows Authentication for nested groups (fatal communication error: [http://forums.iis.net/t/1139442.aspx])
 
* Windows Authentication for nested groups (fatal communication error: [http://forums.iis.net/t/1139442.aspx])
 +
* Report caching option.  After the report runs save the HTML (and images) for: current hour (day, week, month or year) OR next x minutes (hours, days, weeks or months). Option to save for user or for all users.
  
 
==Live Update==
 
==Live Update==
Line 312: Line 337:
 
* Data-Driven Documents [http://d3js.org/]
 
* Data-Driven Documents [http://d3js.org/]
 
* Boxes [[Image:Foto.PNG|20px]]
 
* Boxes [[Image:Foto.PNG|20px]]
 +
* Sunburst [https://github.com/mbostock/d3/wiki/Gallery]
  
 
==Look and Feel==
 
==Look and Feel==
Line 335: Line 361:
 
* jq widgets [http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxtree/index.htm?(arctic)#demos/jqxtree/treebindingxml.htm]
 
* jq widgets [http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxtree/index.htm?(arctic)#demos/jqxtree/treebindingxml.htm]
 
* bootstrap dashboard [http://themes.startbootstrap.com/flex-admin-v1.2/]
 
* bootstrap dashboard [http://themes.startbootstrap.com/flex-admin-v1.2/]
 +
* sliders [http://ionden.com/a/plugins/ion.rangeSlider/en.html]
  
 
==Compatibility with==
 
==Compatibility with==
 
* [http://www.sybase.com/iqexpressedition Express version of Sybase IQ]
 
* [http://www.sybase.com/iqexpressedition Express version of Sybase IQ]
 
* [http://sourceforge.net/projects/mondrian/files/mondrian/mondrian-3.3.0.14703/ Mondrian]
 
* [http://sourceforge.net/projects/mondrian/files/mondrian/mondrian-3.3.0.14703/ Mondrian]

Latest revision as of 07:42, 16 June 2019

OLAP Report[edit]

Filter[edit]

  • Import Excel or Text file to a Filter via the Search button [1]
  • Make Filter like OWC Filter. Parent member to get highlighted if I select any child member.
  • Date Calculations: Ability to modify the number of trailing days
  • Pin feature can be modified to include Data Calculations. Custom range function for each level.
  • Filter to have Exclude option [2]. Where ([Dim Content].[Format Class].&[eBook], EXCEPT([Dim Content].[Publisher].[All].Children,[Dim Content].[Publisher].[LexisNexis])).
  • Filter Display Modes: (Should multi-select be just another mode?)
    • Page Mode: play, stop, next, prev, drop down buttons.
    • Time-line slider mode
    • Panel Mode: have the height of the pull down menu in the Dimension Filter in the Page Area be as high as the first level items so there is no need for scrolling down or changing the height with the mouse. [3]
    • Measure number range mode: similar to Rows Filter but with a slider interface.
  • When you select multiple elements add check-box to show the rest as a row (similar to Top)
  • Filter option to show parent level. Instead of January show 2015-January. Instead of Q1 show 2015-Q1.

Grid[edit]

  • Ability to rename measures on rows
  • Copy Grid
  • New Options tab called "Measures" that would show:
    • Dropdown with currently selected measures
    • Checkbox called "Show tooltips on mouse over"
    • Available / selected measure lists to let you select tooltip measures
    • For calculated measure a checkbox called "Show measures used in the calculation"

Charts[edit]

  • Option to create pie Chart for each column
  • Add Bing Maps [4]
  • Add Pareto chart: Bar an line chart combinations where line is cumulative [5]
  • Change the OLAP Report Chart “Save As Image” functionality add the legend when it is located to the left or right (vmware)
  • Rename measure - bubble chart y & x axis
  • Ability to Change Legend Item Text (Main.js - oChangedColors, LegendItem.aspx)
  • Add a threashhold beyond which no rows will be displayed, add 'Rest' option. by default all rows will be displayed
  • G raphaeljs
  • highcharts
  • thermometer chart
  • interactive chart based on time
  • Variable Width bar chart
  • TermCloud

GeoCharts[edit]

  • Geo Maps in HTML and Flash [6];
  • Ability to control the type of chart to use after a polygon is clicked.
  • Ability to change from Heat Map mode to:
    • Add a Line, Pie or Bar Chart in the center of each polygon. Each column will be represented as a slice or a bar. The chart should popup when clicked.
    • Bubble in the center of each polygon. Size will depend of the first measure (columns) and the color will depend on the second measure.
  • Add the new Map of The Netherlands with a right scale.
  • Open layers [7]

Drillthough[edit]

  • Custom context menus (for Drillthough): [8] (westat)

Calculated members dialog[edit]

  • Organize calculated members and named sets into folders (alexian)
  • Select the measure group for the field list
  • New Tab: Colorss for Conditional formatting: with member [Measures].[sss] as [Measures].[Internet Sales Amount], FORE_COLOR= RGB(255,0,0), back_color= IIF([Measures].[Store Cost] > 50000, RGB(0,255,0), RGB(225,0,0)) [9]

Named Sets[edit]

  • Imported Lists: upload or copy and paste. MDX or Text. Select dimension and attribute before validating the list.
  • Show results with named set dialog
  • "Display as one member" option will aggregate set into a calculated member
  • Ability to build named set based on existing named set
  • Show named sets in a separate folder in the field list
  • Organize named-sets in folders

Field List[edit]

  • Support "Sub" display folders for dimensions
  • Show Filter Groups like Adventure Works as in Tableau Software
  • Ability to dock to right
  • Add Search capability [10]
  • Drop dimension dimension to measures to see district count like: Count(NonEmptyCrossJoin([Customers].[Name].Members))

Sparklines[edit]

  • Add other Charts: Pie, Bar, Horizontal Bar, Area (Legend will be visible on click)
  • Icon Chart [11]
  • Win\Loss Graphs [12]
  • jQuery Sparklines [13]

PDF export[edit]

  • Options to be saved and used with subscriptions
  • Negative bars
  • include logo image

OLAP Other[edit]

  • Paging: Replace last button name with the last page number. Remove 1 "of 123". Hide last and first buttons when it is the last of first page.
  • Ability to expand and multi-select measures Asymmetrically
  • Page/margin selection dialog before printing
  • Freeze row header when scrolling horizontally
  • Ability to show MDX, Named-Set toolbar button in the view mode
  • Undo & Redo for the expand mode
  • Right click on OLAP Report > Hyperlink - Show filters as in Subscription Filters
  • SSAS Rowset Action [14]
  • New Drill Down Mode (For each dimension)
  • New Expand Options: Drill Member / Drill Position (Don't Reset)
  • Ability to disable Analyze cell context menu item
  • Report option to enable "HTML output escaping"
  • Allow saving of private cell comments. Currently, everyone can see all comments.
  • Measure formatting option: create an XMLA session to run two MDX queries like Language(Measures.Members) = 1046; Select non empty {[Measures].[Unit Sales]} on columns From [Sales]
  • ROLAP Report Action

Conditional formatting[edit]

  • Adjust Conditional formatting on the percentage (for example from 30% to 60%) using a slider control next to the Filters
  • New Type: Bubble Size

Tree Map Report[edit]

  • Add calculated measures from the OLAP shared library
  • Add 'Go Back' button. (When I drill-down to next level, I can't go back to previous level.)
  • Time Filter Slider (as in moving bubble)

Pie-Chart Report[edit]

  • Option to export my pie chart to PDF, word or excel (telware)
  • Group Hierarchy dropdown by dimensions
  • Option to Show "Rest" as one slice

Blog Report[edit]

  • Ratings per blog entry

OWC Report[edit]

Crystal Report[edit]

Data Mining Report[edit]

  • Data Mining Model Creation Wizard [17]
  • Profit and Lift Charts
  • DMX Query Report
  • Singleton Prediction Page
  • Expanded Pie Chart [18]
  • Forcasting [19]

ROLAP Report[edit]

  • Show data in rows / columns based on order field not only in filter
  • Show report with fact records eliminated by the inner join to the dimensional table. Show value and count.
  • Create new Cube tab called: "Exceptions" that would show the count and distinct count of fact records that do not have corresponding dimensional records. Rows: Fact Dimension Keys. Columns: Count and Distinct Count. It should be possible to drill down to see the list of distinct values and the list of fact records.
  • Theme support
  • Design mode: resise measures, rows, filters and columns
  •  % generator – 30 hours, Top n restrictions – 30 hours, SQL formula calculator – 40 hours
  • Cell Exception highlighting (painting) – 40 hours
  • KPI inside the cube cells – 40 hours
  • Ability add computed metric at the "top level" like: sum(p.total - p.internal_total_cost) / sum(nullif(p.total, 0)) as gross_margin
  • Filter Type: Date Range
  • Parent-Child Dimension Type
  • Add Top-N using "cross apply" SQL clause
  • Support hierarchy on Columns in expand mode
  • Alternate Cell Color: tr.RowData:nth-child(2n) td

SQL Report[edit]

  • Date Filter Calculations: This Year, This Quarter, Previous Quarter, This Month, Previous Month, Last 3 months.
  • Add Gantt Chart as Chart Type for SQL Reports [20]
  • Add number of records in the View button so you see the number of records will lower when you choice from page filters
  • Option to Show the list full 100% width of screen
  • Multi-Select filter
  • KPI with case when x < 0.3 then 'img src=../images/kpi/KpiSadBubble.gif
  • Dynamic Report Description based on SQL results of a single row cell query
  • Theme support
  • Make sure that Date Picker filter is using the following ANSI formatting: Convert(DATETIME,'::2',102)
  • In memory: Sorting, Grouping for large non-paging data set
  • Excel Export Multi-Retult to mulple tabs
  • Application level setting for "Run on load" option (the same for Crystal report) (credo2u)
  • SQL/MDX in report description

SQL View Report[edit]

  • Max, Min, Year-Month for date
  • Support for stored procedures

SSRS Server[edit]

  • Reports in the left box be dockable
  • Add on the list support for SQL Server 2008 R2 Reporting Services (like gauges and charts, etc) in ReportPortal so you can use other modules
  • Button to create SSRS connections based on RP Connections
  • SSRS Scheduler
  • Add Filters like OLAP / SSAS KPI Report as replacement for SSRS MDX Parameters and parameter area (2)

SSRS File[edit]

  • Cascading filters
  • Default value from SQL
  • Not Selected Filter
  • Checkbox Filter

KPI Report[edit]

  • Export the KPI graphic to Excel
  • Filters
  • Change "column, row number" for multiple KPIs
  • Ability to Rank importance of each KPI and order them by importance
  • Bullet Charts - [21] and [22]
  • Thermometer [23]

Analysis Services KPI[edit]

  • Expand / Collapse the groups
  • Cache discover schema to improve performance
  • Use the same field list as in OLAP report to add a filter
  • Order filters like in OLAP field list
  • Add a wysiwyg comment review feature, now it is text based (2)
  • Add a section right to display value, goal, status and trend for chosen period as YT Period in filter
  • Add Sparkline

Dashboard Report[edit]

  • Option for the width to be Percentage based or Pixel based
  • Option to link a sub report to another report. Option to choose target report. When clicking on a expand icon or a chart item pass parameters to the target report. (Edit > Actions dialog > Add Filter Action > Pick Source and Taget)
  • Pre-select filters based on newly added report
  • Option to open sub report in the same window. Filters and tabs will remain. Next and Previous buttons will appear on the toolbar.
  • Option to have a summary tab that would list all of the reports and filters used in the dashboard.
  • Add a Button to add a Reporting Services URL with parameters is there is in Dashboard to be transferred to show the Reporting Services report based on the Page Filters in Dashboard.
  • Excel Chart exporting
  • Add multiple reports at once
  • Chart/Grid toggle
  • Add the search capability to non-OLAP reports

DataEntry Report[edit]

  • Custom Validation for textbox (Email, URL)
  • New Column Type: Slider http://www.eyecon.ro/bootstrap-slider/
  • Radio Button - manual list has Value and Text. Add image for an optional icon next to the Text.
  • Validation of minimum and maximum value for numeric and date fields
  • Edit Grid to show textbox and drop down only when a cell is clicked
  • Ability to hide folders in the Data Entry tree (because you already have tabs)
  • Connect Dialog to accept SQL. Will create new SQL panel. View only mode (insert, delete, update options not available)
  • Ability to use forms from other connections
  • Wizard to be able to create multiple forms for a connection.
  • List Type = Table > (Set to current column) : suggest List table and column based on the foreign keys
  • With Report ID store Table and Database name (in case report is re-created and id changes)
  • Conditional formatting based on a value (http://www.reportportal.com/forum/topic.asp?TOPIC_ID=1941)
  • If a table is referencing or is being referenced by other tables and child (and forms are not defined) there should "virtual" child or parent nodes (the name column should be the first text field with the word “name” in it)
  • Child Data Entry Form, Type = Parent to create DB lookup to be able to change the parent
  • Connect dialog - "View Only" checkbox
  • Grid Export: Include Lookup fields
  • Save Record History: Select and create History table
  • Search - between col1 and col2
  • Actions - New PDF Merge Type
  • Design : Child
    • match Local Column and Key Column on "Local Column" select
    • button to add forms that are linked to this form
    • When a new form is created, child / parents forms will be added based on foreign keys
  • When "Name Column" is checked present another checkbox: "Group By Column"
    • Ability to select another Icon
    • Multiple Group by columns?
    • Calculated Column

RP Subscription Services[edit]

  • Support for other Report Types: KPI, KPI 2005, SQL view report
  • Add Schedule to support for example: Every week on mon till Fri from 08:00 till 17:30 every 1 hour (like in Windows 2003 Scheduler)
  • Create automatic folders based on the snapshot creation date (like Jan-2008, Feb-2008,…) when number of snapshots exceeds a threshold (10)
  • For OLAP report change from row-number and column-number based to tuple based

Report Tree[edit]

  • Optimize it is to have the My Reports for each user to be loaded on demand instead of all in once
  • When Manual sorting is on, allow for drag-and-drop to move reports and folders around
  • Add most used reports to top of Report Tree
  • Show search results in the right window (vmware)
  • Connection View to include other report types

DB Admin[edit]

  • Cannot drop database because it is currently in use - Kill sessions
  • Session > Kill: use Master DB
  • Edit Data
  • Tree - by default hide other databases and add link called "Show other databases"
  • Add Comuted Columns: ALTER TABLE ReportNote ADD CommentName As convert(varchar(20), Comment)
  • Compare Databases (tables, users, premissions, views, SPs and functions)
  • Export SQL - SQL Server - SET IDENTITY_INSERT [TableName] ON (when table has an identity column)
  • Create DB Admin report type
    • Cannot edit schema in design and view modes
    • Can select columns (XMLA Discover)
    • Can select toolbar buttons (Table View)

Admin[edit]

  • User Admin:
    • Always expand folders option [24]
    • The height of the userlist in the tree should be variable or as long as the height on screen
    • The secondary Admin: user will not be able to change the settings of himself and administrator
  • Option to have user registration form so new users can register with a default role (with captcha). Also give the ability to create a user based on Google or Facebook account.
  • Admin > Settings
    • Site Settings > After having edited a given report, prompt user to confirm exit or save report.
    • Report name > Show Folder Path
    • OLAP (or SQL, ROLAP) Report > Exporting > Header = Always Export, Don't Export, Ask during exporting (credo2u)
    • Ratings: ability to clear ratings per report and/or all reports
    • Report Tree > Folder visibility in the view mode (drop down): 1-Show all folders, 2-Show folders with reports only, 3-Show allowed folders only
    • New Admin option Admin > Security > “Show login page only when Windows password is blank or invalid”.
      • This option will be visible only when Admin > Security > Security Authentication Mode = “Windows | Mixed” and Enable pass-through authentication = True.
      • Maybe this option is not needed and Security > “XML for Analysis Security Enabled” should be used instead?
  • Role-Connection updating feature to support multiple roles. In that case, the user will need to select connection, server, database or a cube before viewing a report. (Accretive)
  • Admin > Selected Report Types > Ability to add new report type groups and move report type groups up and down
  • Admin > Localize > Import and Export into XML Files
  • Admin > Connection
    • When you click on the Cache button you will see a dialog with the multi-select list of cubes to be cached.
    • Database Type = Excel [25] [26]
    • Database Type = DMX (Provider=MSOLAP.4;Persist Security Info=False;Initial Catalog=Adventure Works DW;Data Source=http://localhost/xmla/msmdpump.dll)

Other[edit]

  • When saving a report add the ability to add footer
  • MS Windows SharePoint Services ver 3 Integration via Web Parts
  • The Auditor to have the opportunity to set his comment to a read only flag or rewritable
  • Sparklines as chart type in the table for ROLAP, KPI, KPI2005 Reports [27]
  • Application option that would prevent “Publishers” from seeing Security menu item (decisivebi)
  • Report name should be saved with for example english reportname, dutch reportname and france reportname and if an user is logged in for example with dutch that the reportname is shown in dutch, etc.
  • HTML Injection: Server.HtmlEncode
  • Tie Private reports to the original report. An admin option will determine if all of the private reports will be deleted when the original report is deleted or has its security changed.
  • Ability to restrict GetSecurityToken to a report
  • Windows Authentication for nested groups (fatal communication error: [28])
  • Report caching option. After the report runs save the HTML (and images) for: current hour (day, week, month or year) OR next x minutes (hours, days, weeks or months). Option to save for user or for all users.

Live Update[edit]

  • Live Update in production even if the server don't have internet connection (security).
  • Live Update scheduled so the software is always up to date with any new build / patches.
  • Copy web.config

Setup Program[edit]

  • XMLA Setup for non-default site
  • Activate / Deative License Utility
  • Should delete live updates
  • File Access Permissions for ReportPortal folder
  • If the database already exists present the following options:
    • Update Themes
    • Update Colors
    • Update Languages

New Report Types[edit]

  • Search based on Microsoft Index Server [29] [30] [31]
  • Organizational Chart [32] [33]
  • Power Pivot report
  • Forum (based on common/Comments.aspx)

New Data Visualization Reports[edit]

  • Baseline Quadrant Analysis [34]
  • Horizontal Bar Chart tree
  • Geo Chart Tree - expands into another map or into pie [35]
  • Tree and Chart report. Chart changes based on selected tree node. Top-N + Rest feature should be supported.
  • Chernoff Face [36]
  • KPIs with Weekly/Monthly/Yearly Calendar
  • Strategy Map - a way to organize and setup relationships between KPIs [37] [38] [39]
  • Expaning size bubbles [40] [41]
  • Other [42] [43] [44]
  • Force-Directed Graph [45]
  • Nested Pie Charts[46]
  • Data-Driven Documents [47]
  • Boxes 20px
  • Sunburst [48]

Look and Feel[edit]

Compatibility with[edit]