Requires Admin permissions.
Now that you have more options for creating analyses, it may sometimes be difficult to know exactly which flavor of the report builder suits your needs. This article guides you through choosing the best way to build your analysis.
SQL Report Builder?
Look at some of the more common reasons that you would use the SQL Report Builder over the traditional Report Builder.
Part of the beauty of the
SQL Report Builder is that it gives you the ability to use functions that are not currently available in the Data Warehouse Manager. In the past, an analyst may have had to step in to help you fully realize your vision.
The SQL Report Builder supports functions like
GETDATE, which you could not previously use. You can access the
full list, but some other SQL-specific functions include:
If you want to try different techniques and strategies to figure out what works best for your analysis, you might want to use the
SQL Report Builder. Building out columns in the Data Warehouse Manager takes time and columns that you create using the DWM depend on update cycles.
At best, you must wait through one update cycle before you can use your column. If you realize you made a mistake in building the column, you have to wait through two cycles: one to initially populate the column, and another cycle for the revisions to propagate.
As mentioned in the section above, creating a column in the Data Warehouse Manager takes time. If you only plan on using a column you create in one report, Adobe suggests using the
SQL Report Builder. This eliminates the need to wait for an update cycle to complete, getting you back to work more quickly.
Sometimes, the structure of your data might make the
SQL Report Builder a more efficient and logical choice to build your analysis. Creating columns for one-to-one relationships is straightforward in the Data Warehouse Manager, but things can get a little confusing when you’re dealing with one-to-many relationships.
Say that a single product is considered a part of multiple product categories, and you would like to view the revenue associated with each category of each product. Trying to create this relationship using the DWM can be tedious and difficult, but writing a SQL query may be a bit more straightforward:
SQL Report Builder gives you more control and access to previously unavailable functionality, it might not always be the right choice. Adobe suggests that you also consider the following when deciding what flavor of the report builder to use.
If what you want to create is straightforward, using the traditional Report Builder can be much faster than writing a full SQL query. It helps if any columns that you need to create the analysis are already in the Data Warehouse Manager.
Are users across your organization using/viewing this analysis? Depending on who you are sharing your work with, sticking with the Visual Report Builder may be better sometimes. Users can quickly look at the definition in the Visual Report Builder versus reading a potentially long SQL query.
If there are some people who need the report but are not familiar with SQL, Adobe suggests using the original flavor of the Report Builder. It makes things easier on them.
SQL Report Builder and
Visual Report Builder are suitable for a wide variety of use cases. This typically depends on what your analytical needs are and who are consuming the analysis.