Forum Discussion

Christian_Schlegel's avatar
Christian_Schlegel
Former Employee
Dec 09, 2024

Additional commonly asked Q&A related to Search in DFP continued

Hello everyone,

We are excited to continue our weekly spotlight series with a focus on frequently asked questions about DFP's Search feature. To assist you in navigating and optimizing this feature, we've compiled a comprehensive Q&A that you can find below. If you need further clarification or have additional questions, feel free to reply here in the Fraud Protection forum. We value your feedback and are here to help.

Kind regards,

DFP Product Team

 

 

1. What is Search and how does it work?

In Microsoft Dynamics 365 Fraud Protection, the search functionality allows fraud investigators and support agents to locate and investigate specific transactions and associated data. This capability is essential for quickly resolving customer issues, analyzing fraudulent activities, and taking appropriate action.  

                How it works: 

  • Initiate Search: The user navigates to the appropriate section (e.g., Purchase) and enters the search criteria in the search field.
  • View Results: The system returns a list of transactions that match the search criteria. Users can click on any transaction to view expanded details.
  • Investigate and Take Action: Based on the detailed information provided, fraud investigators can determine the legitimacy of a transaction and decide on the appropriate course of action, such as unblocking a customer or flagging a transaction for further review.

                References: 

 

 

2. How can I enable Search?

To enable the Search feature in Microsoft Dynamics 365 Fraud Protection, you need to have Product Admin role permissions. Here are the steps to enable Search: 

  • Sign in to the Dynamics 365 Fraud Protection portal with your Product Admin role credentials. 
  • Go to Settings and select the Search tab. 
  • Toggle the switch to On to provision search for your Fraud Protection tenant. 
  • Once enabled, you can use the search to find and review transactions and events in Fraud Protection. Please note that you cannot turn off the search feature after enabling it. 

References: 

 

 

3. Are null values supported in search?

In Microsoft Dynamics 365 Fraud Protection, null values are supported in search.  The Is null operator can be used to find records that aren't required on payloads and with an unknown value: 1) not on the payload or 2) with a null value.  Example: Search for payloads where a user ID value isn't required on the payload and unknown. 

References: 

 

 

4. When I exported a CSV it changed all the numbers to scientific notations.  Why did this happen & how do I fix it?

The issue you're experiencing with numbers changing to scientific notation in a CSV file is a common occurrence when opening CSV files in Excel. This happens because Excel automatically formats numbers that are longer than a certain length (usually more than 10 digits) into scientific notation to save space in the cell. 

Here's how you can fix it: 

  • Open the CSV with a Text Editor: If you open the CSV file with a text editor like Notepad, you will see the full numbers without scientific notation. This confirms that the CSV file itself is correct. 
  • Format as Text in Excel: When opening the CSV in Excel, you can prevent numbers from being displayed in scientific notation by formatting the cells as text before importing the data. Here's how: 
  • Open Excel and go to the "Data" tab. 
  • Choose "From Text/CSV" to import your CSV file. 
  • In the import wizard, select the column with the numbers. 
  • Change the column's data format to "Text". 
  • Finish the import process. 
  • Text to Columns Wizard: Another method is to use the Text to Columns wizard in Excel: 
  • Open the CSV file in Excel. 
  • Select the column with the scientific notation. 
  • Go to the "Data" tab and select "Text to Columns". 
  • Choose "Delimited" and click "Next". 
  • Uncheck all delimiters and click "Next". 
  • Select "Text" as the column data format and finish the wizard. 
  • Prevent Automatic Formatting: To prevent Excel from automatically formatting large numbers in scientific notation, you can also add an apostrophe (') before the number in the CSV file. This forces Excel to treat the number as text. 
  • Please note that these steps are general guidelines and the exact process may vary depending on the version of Excel you are using. 

 

 

5. How long is search data available for?

In Microsoft Dynamics 365 Fraud Protection, you can search for events and transactions within a timeframe of up to the past 13 months. 

References: 

 

 

6. Is there a cost for search to be on? Is there a downside to search being on?

There is no cost or downside to enabling search. 

Note: You can't turn search off after you enable it. 

 

 

7. Exporting data to CSV for analysis: can it be accessed or pushed to PowerPivot or similar so a large volume of data can be analyzed?

Once the search data has been exported and downloaded as a CSV, the user can choose how to analyze this data, including pushing it to our tools like PowerPivot. 

DFP also supports event tracing if the user desires to export data regularly.  Once the data has been traced to the data store defined, the customer can analyze this data in any way they choose. 

References: 

 

 

Fraud Protection
No RepliesBe the first to reply

Resources