-
PDP Automation and Managed Attributes
I use PDP Automation across most of my datasets, but I am having an issue with how to configure policies that use managed attributes in the Configuration Dataset. In the below image the first record works without issue. The second record ends up setting the policy as DM Email = 'Email' instead of DM Email = Attribute:…
-
PDP question
Sorry for the vague title. My brain just couldn't think of anything else. I have a commission report and I just can't seem to come up with a path to get the PDP setup correctly. I have 3 distinct levels of access: Role level: Salesperson can see only their personal rows. Supervisor can see the rows of everyone that reports…
-
PDP based on multi-select field
For my company the primary data point for PDP is division. In all but 1 system this is a single select required field and is seamless. In one system location is multi-select which is understandably problematic for PDP. This is how it is set on one of the "good" datasets Compared to the "bad" dataset I have to add a rule…
-
PDP issue on Dashboard with more than one dataset
I have a dashboard with 6 cards. 4 cards are on General Ledger Data Mart, 1 on Accounts Receivable Data Mart and 1 on SO Document Detail. All 3 datasets have identical PDP using the value of the 'Division' column. When looking at dashboards where only 1 of the above datasets are used, PDP works without issue. But when I am…
-
Input DataSet - Load New data
I am working on a new dataflow using Magic ETL. I have 11 input datasets. All are Workbench jobs with the Update method set to Append and they each have an assigned Upsert Key. I have configured each of the inputs to load New data. When I save my dataflow 3 of the 11 throw an error. "This data set does not support data…
-
Filtering Question
I have a mega table report that is displaying customer invoice data. One of my filters is for the Aging Range. I have been asked to modify the filter to include all invoices for a customer if any of their invoices are in the filtered range. Meaning that in the below dataset if they selected to filter 151-180 all invoices…
-
Partitioning for Dummies?
Can someone point me to a good step by step guide to setting up partitioning in Workbench 5.2? I have a very large dataset (currently 5.8 million rows) that gets updated daily with a full replace. As you can imagine it takes a HOT MINUTE to run. On average there are 12.5k new records and 100 records updated or deleted…
-
Any row is added alert issue
I have had an alert set on a view for the past several months that has been helping us track a bug with a vendor. Essentially we get daily flat files and randomly we will get files that are missing data and are their flagged as 'Problematic'. When I set up the alert 'Any row is added' was was a prebuilt option that I…
-
Removing Datasets
I have been in the process for the past 6ish months of revamping the underlying data structure that feeds into Domo. As part of this I have created new dataflows and datasets in Domo. I still have a handful of reports that are populated from the old dataflow. This dataflow is turned off and the dataset is stale, but we…
-
NULL value Handling
I'm a bit frustrated by this one. I have done everything along the path to ensure NULL values are being handled appropriately in my data. Starting from flat files and ending in a dataset (with several non-Domo steps in the middle). All of my data appears as expected in the dataset, but as soon as I add the column to a card…
-
GROUP_CONCAT function in Dataset View vs MySQL Dataflow
I have created a MySQL Dataflow where I was able to successfully use the GROUP_CONCAT function. It is preferred that I use a Dataset View in this circumstance since the underlying data is coming from AppDB and therefore updates every 15 minutes if there is new data. I have copied and pasted the exact query that is…
-
Displaying 1 to many records in a table
I have created a custom app for my users to be able to add notes to Invoices that are in collections. The relationship is 1 Invoice to many notes. Initially, my plan was to display the Invoice details in a table card ( Customer, Invoice #, Contact, Invoice Date, Invoiced Amount, Total Due, etc.) and the note data would…
