Wish List
From Wiki
Contents
- 1 General
- 2 Admin
- 3 OLAP Report
- 4 ROLAP Report
- 5 SQL Report
- 6 KPI Report
- 7 Tree Map Report
- 8 KPI 2005 / 2008 Report
- 9 OWC Report
- 10 Reporting Services Report
- 11 Dashboard Report
- 12 Data Mining Report
- 13 ReportPortal Subscription Services
- 14 Bubble Chart
- 15 Upload in Design mode
- 16 Other
- 17 Report Tree
- 18 New Data Visualization Reports
- 19 DB Editor
- 20 Live Update
- 21 DataEntry Report
- 22 Style Sheet
- 23 Portal layout
- 24 MAP SDK
General
- ReportPortal ported to support not only Internet Explorer on Windows but also Safari on Apple, Safari on Windows, FireFox on Apple and FireFox on Windows.
- When saving a report add the ability to add footer
Admin
- User Admin: Always expand folders option [1]
- User Admin: The height of the userlist in the tree should be variable or as long as the height on screen
- Option to have user registration form so new users can register with a default role (with captcha)
- Admin > Settings > Site Settings > After having edited a given report, prompt user to confirm exit or save report.
- Admin > Settings > Report name > Show Folder Path
OLAP Report
Filter
- Date Calulations: Ability to modify the number of trailing days
- Filter to have Exclude option [2]
- Filter Display Modes: (Should multi-select be just another mode?)
- Page Mode: play, stop, next, prev, dropdown buttons.
- 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. [3]
- Measure number range mode: similar to Rows Filter but with a slider interface.
- CheckBox to allow multiple or single selection. In some reports, exists calculated fields that cause error if you select multiple items
- When you select multiple elements add checkbox to show the rest as a row (similar to Top)
Grid
- VISUALTOTALS functionality. Similarly Hierarchize has been included in the report options, you should be able to select VisualTotals [4]
Charts
- Option to create pie Chart for each column
- Add Google Maps with display of record data based on name or longitude
- Add Bing Maps [5]
- Add Pareto chart: Bar an line chart combinations where line is cumulative
- Add Trend Line to the scale Bubble chart based on a number or AVG
GeoCharts
- 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.
- Use Flash to zoom in/out? [7]
- Ability to right click on legend to change color
- SHP files http://blogs.msdn.com/robertbruckner/archive/2009/08/12/rs-maps-with-esri-shapefile.aspx
- Open layers [8]
MDX Builder
- Organize calculated members and named sets into folders
Field List
- Support multiple display folders for a single measure [9]
- Support "Sub" display folders for other than KPI
- Show Filter Groups like Adventure Works as in Tableau Software
- SSAS 2005+: Add ability you drag and drop member properties to measures as with SSAS 2000
- Make Report Tree Width work for both Design & View modes
Sparklines
- Add other Charts
- Pie, Bar, Horizontal Bar, Area
- Legend to be visible on click
- For none Time dimensions
Other
- Ability to expand and multi-select measures Asymmetrically
- Page/margin selection dialog before printing
- Show error messages on the page not in a message box
- Freeze row header when scrolling horizontally
- Ability to show MDX, Named-Set toolbar button in the view mode
- PDF export options to be saved and used with subscriptions
- Undo & Redo for the expand mode
- Top-N: ability to select column if columns have anything other than measures
- Ability to sort column dimensions via Options > Dimension dialog
ROLAP Report
- 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.
- Show the table as you have in MOLAP report with small lines for the cells.
- Add the &export=html feature for ROLAP Report as there is with the MOLAP Report.
- 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.
SQL Report
- Add Gantt Chart as Chart Type for SQL Reports [10]
- 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
- Option to show/hide design button in view mode
- Option to apply formatting to column [11]
- Add new Geo Map features from OLAP Geo Map
- Multi-Select filter
- KPI with case when x < 0.3 then 'img src=../images/kpi/KpiSadBubble.gif
- PDF export to also export a chart
- Shared Filters
- Add "Shared Filters" admin page that will allow you so select a connection, set name and build an SQL statement.
- In SQL report design mode, on the Filter setup page you will be able to select new "List Type" called "Shared Filter". When you select the type you will see all of the Shared filters defined on the “Shared Filters” admin page that have the same connection as the designed report.
KPI Report
- 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
Tree Map Report
- Add measures from the OLAP shared library
KPI 2005 / 2008 Report
- Change the name from KPI 2005 Report into KPI 2005 / 2008 Report
- Time calculations as in OLAP Report Time dimension
- Expand / Collapse the groups
- Cache discover schema to improve performance
- Add Filter Dialog: add an icon to show if it is a dimension attribute or dimension hierarchy
OWC Report
- Zoom capability
Reporting Services Report
- 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
Dashboard Report
- Support for ROLAP Reports in Dashboard Report
- 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 both horizontal and vertical reports. I see that with drag and drop it is possible I will test at another site as well
- Add a Button to add a ReportingServices URL with parameters is there is in Dashboard to be transfered to show the ReportingServices report based on the Page Filters in Dashboard II. Support for both SQL and MDX filters. Maybe this is more easy to implement than transfer all MOLAP reports from Dashboard II to PDf or Reporting Services.
- Add a feature to drag and drop tabs to have another sort / order
- Show an Dashboard Report by default full screen (without report tree) on or off
Data Mining Report
- Data Mining Model Creation Wizard [12]
- Profit and Lift Charts
- DMX Query Report
- Singleton Prediction Page
- Expanded Pie Chart [13]
ReportPortal Subscription Services
- Support for other Report Types: Crystal Reports, Reporting Services, KPI, KPI 2005, ROLAP
- 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 in above popup a button like below to show the content of the report so you can choice more easy the row and column
- Create automatic folders based on the snapshot creation date (like Jan-2008, Feb-2008,…) when number of snapshots exceeds a threshold (10)
Bubble Chart
- Add Sub Ticker (Year) for Time Slider (Month)
Upload in Design mode
- New Features:
- Add name for uploaded file to be displayed in the report tree in view mode or in the portletname in dashboard
Other
- 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 [14]
- Approver should get an email alert when a report is ready for approval
- Use this library for creating Excel file [15]
Report Tree
- URL Integration SDK
- Right Click on a report to set ad default report
- When moving or renaming a report remember the scroll position
- When Manual sorting is on, allow for drag-and-drop to move reports and folders around
New Data Visualization Reports
- Baseline Quadrant Analysis [16]
- Horizontal Bar Chart tree
- Tree and Chart report. Chart changes based on selected tree node. Top-N + Rest feature should be supported.
- Chernoff Face [17]
- KPIs with Weekly/Monthly/Yearly Calendar
- Strategy Map - a way to organize and setup relationships between KPIs [18] [19] [20]
- Expaning size bubbles [21] [22]
- Other [23]
DB Editor
- Ability to add\remove\change a table
- Export data
- Upload Data
Live Update
- 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.
DataEntry Report
- Add "Next" and "Previous" buttons to the top of the left data navigational tree
- Custom Validation for textbox (Email, URL, Number Range)
- Custom Validation for textbox (Currency = numbers only)
- Radio Button - manual list has Value and Text. Add image for an optional icon next to the Text.
- Create a Go Back button if "&goBackReportId=33" parameter is passed to the FormEdit2.aspx page
- Search to extend to columns of parent and child forms
Style Sheet
- Add the style as used in login.aspx for the inputbox (now hardcoded blue)
- Add the style as used in the portal for the lettertype
- .FilterTable also changed for the full Page Filter in OLAP Report
Portal layout
- Add a url to the logo to show View report tree