Targit User 1

Remove duplicates in data source

1. Community
2. Data Discovery

Can I remove duplicates from a data source in TARGIT Data Discovery?

• Created February 17, 2021 14:39
• 2 followers
• 1 comment
• 0 votes

Google sheets as data source?

1. Community
2. Data Discovery

Is it possible to use Google Sheets as a data source?

• Created February 17, 2021 14:38
• 4 followers
• 3 comments
• 0 votes

One drive for business as data source?

1. Community
2. Data Discovery

Is it possible to use One Drive for business as a data source?

• Created February 17, 2021 14:38
• 2 followers
• 1 comment
• 0 votes

Mash-up of data sources

1. Community
2. Data Discovery

I have a table showing absence registrations for different departments represented with an Employee number. Then I have another table showing extra data on each Employee (and the Employee number)....

• Created February 17, 2021 14:37
• 2 followers
• 1 comment
• 0 votes

Manipulate source data before using in cubes

1. Community
2. Data Discovery

I have a first name column and a last name column in my excel sheet – can I somehow concatenate them in TARGIT Data Discovery?

• Created February 17, 2021 14:32
• 2 followers
• 1 comment
• 0 votes

Hide unused data source types

1. Community
2. Data Discovery

We seem to have a lot of different options for data sources, but only use Excel, CSV and SQL Server tables – can we somehow disable/hide the rest of the data source types?

• Created February 17, 2021 14:31
• 2 followers
• 1 comment
• 1 vote

Data Sources update failure

1. Community
2. Data Discovery

How do I setup notifications that tells me when a data source has failed to update according to update schedule?

• Created February 17, 2021 14:31
• 2 followers
• 1 comment
• 0 votes

Month attribute in Data Discovery

1. Community
2. Data Discovery

I’ve noticed that date hierarchies are automatically generated when there is a date column in my data. Can’t I just have a month attribute (without the hierarchy)?

• Created February 17, 2021 14:30
• 2 followers
• 1 comment
• 0 votes

Control of what becomes sum measures

1. Community
2. Data Discovery

My invoice numbers are offered as sum measures in source data – that doesn’t make sense. Is there a way to avoid this?

• Created February 17, 2021 14:29
• 2 followers
• 1 comment
• 0 votes

"raw" folder in source data

1. Community
2. Data Discovery

What is in the “raw” folder in source data for my data discovery cube?

• Created February 17, 2021 14:28
• 2 followers
• 1 comment
• 0 votes