DrewGillow
Cloud Apps
Joined 3 years ago
User Profile
User Widgets
Contributions
Multi-Currency Support
Request: Provide a standard way for supporting multi-currency support. Use Case: Enable end users to create widget and dashboards where they can switch between multiple currencies. Background: There are various posts on how to implement multi-currency by adding an exchange rate dimension and using a formula similar to Local Amount = (Amount Field) * (Exchange Rate) and using a filter to select the desired currency (E.g. USD, EUR, GBP). This process works well when you have dashboard designers, but it doesn't work well if you want end users to create their own reports. If they do things wrong the Amount may be multiplied by the number of currencies supported. They are required to enter a formula instead of simply selecting a field to report. Recommended Solution: Add ability to add Formula fields to the data Model. The data designer would create a standard field with the formula. The formula would be evaluated within the dashboard not during cube build. Note: there are probably other uses cases for data model defined Formulas that are evaluated within the dashboard. Add ability for automatically adding the Currency filter when the data source is used.Re: Transfer ownership of objects (data models, dashboards)
Able to configure a location where objects are sent when a user is deleted. Put them all in some recycle bin with information about who the former owner was. Automatically purge the recycle bin after client configurable length of time (e.g 90 days)1KViews1like0CommentsRe: Ability for column level security to show/hide shared formulas as it can with attributes
Additionally we find that shared formulas can be modified by anyone that has access to them. We want dashboard designers to reuse the formulas but have data designers build the formulas.1.4KViews3likes0CommentsRe: Email templates - provide dashboard id
We have similar need. My understanding is that this is also made difficult with the SSO integration. We need to perform the SSO login and then "deep link" into the embedded dashboard. I understand other integration methods could allow for this, but let's keep it simple.839Views0likes0CommentsRe: Allow user to "receive forget password email"/"reset their own password" whe
We have the same use case. Client users are SSO and internal users have login, but cannot reset their passwords. Being able to flag users as SSO or NOT_SSO and allowing the reset password to work if they are NOT_SSO would be helpful.880Views1like0CommentsAllow Functions and reuse of conditional coloring rules in Pulse Thresholds
Goal Enable dynamic alerting based on history using formulas Enable reuse of conditional coloring rules for pulse threshold Background Pulse allows you to trigger off of a threshold (e.g. > 10,000, <= 10) Conditional Coloring of widget values allows for functions (e.g. Min([Months in Date], [# of unique Transactions]) Perhaps the Automatic anomaly detection does this, but we have no visibility into what is results in an anomaly. Also not sure if you have to wait for the anomaly detection to learn. e.g. the cube has been built every day for years and has years of data, but the widget was only created a couple weeks ago and the pulse alert was added yesterday. Will it detect anomalies or out of bound conditions that we could write with a formula Desired Functionality Enable use of functions in Pulse thresholds similar to Conditional Coloring of widget values Ideally enable reference to the Conditional coloring options for the widget. The dashboard designer already built it into the dashboard. The user just wants a pulse alert when the widget turns RED. Provide means of selecting from existing conditional coloring rules (Whether they are static values or forumlas) when building/editing the Pulse tile.748Views2likes1CommentRe: Allow creation of security rules for data that does not exist yet
We have the same problem. We want to create security groups, etc for new tenants, but we can't apply the data security until there is at least 1 record that meets the criteria. We used to be able to do this, but an "enhancement" or "bug fix" broke our ability to do this.913Views0likes0CommentsRe: Right Align Numeric Dimensions In Pivot And Table Widgets
years ago there was a script posted to automatically right align number columns so users could add, remove, hide, and rearrange their table widget and still get numbers to right align. But that script seems to have stopped working with upgrades This is what I found. How do we get something that works with tables and piot tables? /* Right Align numbers in the table */ widget.on('domready', function (a, b) { _.each ($('td', element), function (td) { var $td = $(td); if (!isNaN(parseFloat($td.text()))) { $td.css({ 'text-align': 'right' }); } }); });629Views0likes0CommentsRe: Widget Text and Column formatting Megathread
Formatting left align, right align, center in tables. Numbers should default to right aligned. Text should default to left aligned. Default numbers to show same number of decimal places instead of variable. Makes it hard to scan a list in the table of pivot table widget Setting default formats in the data model (e.g. currency fields by default may want to show 2 decimal places or may want to default to no decimal places, may want the item price or exchange rate field to default to 4 decimals).1.9KViews4likes0Comments