Did you know… Create a Dataset from a Visualization?
Have you ever experienced re-creating the same data manipulations, filters, calculations over and over again? One solution is to save your visualization as a new dataset.
In the example below, there is a chart that has gone through some data manipulations, filters, calculations etc and you would like to save the result set as a new dataset. In order to do that, click on the option button and choose “Create New Dataset”.
After that, a new dataset is created. When you go to the drop down list of datasets, you can see the new one you just created. You can rename it if you want. Now save this document as a new .lums file and share with others so that they can re-use the new dataset without the need to re-apply all the same data manipulations, filters and calculations.
- Create a folder near the root, e.g. C:\Data or shared drive, e.g. L:\ instead of the user account’s path, so the file can be shared
- Only acquire the fields that are needed
- Keep dimension names short but explicit
- Minimize the number of measures
“Did you know…” is a series of short blogs by the BI & Analytics Competence Centre, a global team within SAP engineering focused 100% on customer success. They are a useful reminder of Lumira hints, tips and best practices.