When creating ETL project, a lot of debugging is needed. At this moment to check if data is correct, I'm exporting data to CSV right from DataPreview vindow. The problem - it exports only data visible on screen.
Sure - with BIG data, it is ok.
My...
Right now, auditing is only possible on data cubes. However, it should be possible on permission cubes as well, so that it can be tracked who granted/revoked which permission to a user etc. By the way: Auditing of attribute cubes would be sometime...
I'd like a menu in the Web (System Administrator) for backup and recover databases using an easy interface.
Sometimes is very useful to snapshot a database and recover it from a known status.
Stop services, copy directories, in windows or linux ...
Create Load/Transform from Extract and Load from transform
in the flow of creating new models we commonly create Extract, Transform and Load for each dimension. It would be nice to create a transform right from the editing window of an extract and jump right into it's settings, to edit it directly.
For very large tables in SAP it tooks a long time to select all fields to export. It would be nice if there is a select option to export all existing fields of a SAP-Table by one click.
Ability to add visibility logics to objects in Canvas
There are times where based on certain variables A user would like to see/not see certain objects in Canvas.For eg. a pie chart showing revenue distribution by products across 12 months is shown on canvas, but the user wants to look at a detailed ...
Set ETL variable value based on other variables (via formula)
Sometimes a variable in ETL is just a simple math calculation based on another variable.
Example: year_end = year_start + 10
Another case would be a simple "if then else" condition based on another variable.
==>
It would be great to just defi...