[Cloud release: 2025.11.26]
[On-prem release: 2026 January]
[On-prem build: 26.01.21003]
The TARGIT Server can be used as a data source for designing new data warehouses and new cubes. Benefits include:
- All data centered around one data source: The TARGIT Server.
- The TARGIT server may already be connected to multiple data warehouses from different source systems. Using these connections as data sources for a new data model, you can analyze the data in new unified and mashed up relations.
- Data from existing TARGIT connections are already well-structured and consistent due to the Data Model layer, allowing for immediate reuse in new connections.
The Data Discovery data source
In the Data Discovery interface you can add the TARGIT Server as a new data source:
First, you will need to provide address and login credentials for the TARGIT Server:
Then press the Source data 'Select' button to start selecting data - database, cube, dimensions and measures:
Press the Criteria 'Configure' button to apply filters for the imported data:
Preview of the imported data:
These data - as with any other Data Discovery data sources - can now be used in a Data Discovery cube's data model.
In 'Advanced Settings' you have two options:
- Simplify column names: Will try to reduce the length of imported field names by removing duplicate dimension/hierarchy/level strings in the name. E.g., "Company.Company.Company" is simplified to "Company".
- Custom query: This is an option to modify the existing query - or to create a new custom query - with your own SQL query scripts and clauses.
Limitations
- The TARGIT Server data source can connect to the current TARGIT server only. The TARGIT Server data source can not connect to any external TARGIT servers.
Comments
Det fungerer rigtig godt. Vil det blive muligt at kriterieafgrænse på dynamisk tid?
It works really well. Will it be possible to define criteria by dynamic time?Hi Mona,
No. That option was left out due to complexity. Instead, you will need to load the full dataset and then apply dynamic filters through the client afterwards.
BR / Ole
Please sign in to leave a comment.