To homepage To homepage

- - Knowledge base overview
Product Updates
Training
Portal
For Partners
Legacy

Ask Questions. Find Answers. Fast.

Because Time Matters

New to TimeXtender? Get Started now!

Community

Start discussions, ask questions, get answers

Knowledge base

Read product guides and how-to's

Ideas

Submit ideas and suggestions to our team

Product updates

Read the latest news from our product team

Training

Online training and certification

Groups

Connect with like-minded professionals

Download the latest version of TimeXtender

Explore the new cloud-enabled version of TimeXtender.

Download TimeXtender Download ODX Server

Featured topics

The latest & greatest from the community

Recent activity
Help others
Categories

WILSPVisitor

ODX

Error "Sequence contains no matching element" on Transfer task when reading from Business Central

Hi! I am using TimeXtender version 6436.1 and TimeXtender Dynamics 365 Business Central - Online version 18.0.0. When reading data from Business Central in to TimeXtender I get the error “Sequence contains no matching element” on certain tables. This is what the error looks like on the Sales Header table for example: Executing table [Sales Header]:failed with error:System.InvalidOperationException: Sequence contains no matching element at System.Linq.Enumerable.First[TSource](IEnumerable`1 source, Func`2 predicate) at TimeXtender.ODX.Account.BC365CustomDataSource.ExecutionHelper.GetIncrementalLoadPartitionSetups(AccountBC365CustomDataSource accountBC365CustomDataSource, TableModel tableModel) at TimeXtender.ODX.Account.BC365CustomDataSource.AccountBC365CustomDataSource.GetIncrementalLoadSetups(TableModel tableModel) at DataSourceEngine.Custom.CustomSourceEngine.GetIncrementalLoadSetups(TableModel tableModel) at DataStorageEngine.SQL.SQLStorageEngine.<>c__DisplayClass46

2 hours ago

CarloCDOVisitor

Data Warehouse

Removing SQL-Logins

Hi all,I recently created a bunch of SQL logins in TimeXtender to use in our Database Roles we set. After I did that I found out I made a mistake and I removed those SQL logins from the database. However, when I try to edit a database role and try to Add a login, I still see the SQL logins I removed.To make sure there is nog caching or something involved I waited a few days before checking if they were still there.Does someone have a solution to remove those logins from the list? I don't want to create new names for my SQL logins just to avoid having the same name as the previous one. Although, if that is the only option I am willing to accept that as well. Kind regards,Carlo

4 hours ago

rory.smithTimeXtender Xpert

ODX

What rights are needed to be able to create roles in the ODX Server to define access

I am trying to set up access to some tables in the ODX. when I try to add a role and search for an Azure AD user I get the error: Service request failed: Code: Authorization_RequestDenied ...Module: TimeXtender.ODX.EngineTimeXtender.ODX.Engine.ODXFaultException at TimeXtender.ODX.Engine.ODXEngine.SendServiceRequest[C,T](WcfServerSettings serverSettings, Func`3 func) at TimeXtender.DataManager.AddODXSecurityRoleWizard_MemberSelectStep.<>c__DisplayClass11_0.<SearchClicked>b__0() at TimeXtender.DataManager.ConnectingThread.ExecuteConnectingThread(Object dummy)Service request failed: Code: Authorization_RequestDenied ...Module: timeXtenderTXModelInterface.ExceptionWrapperException at TimeXtender.DataManager.ConnectingThread.HandleError() at TimeXtender.DataManager.ConnectingThread.Execute(String title, Int32 progressSteps, List`1 actions) at TimeXtender.DataManager.AddODXSecurityRoleWizard_MemberSelectStep.SearchClicked(Object sender, EventArgs e) This setup is a V

4 hours ago

KaiMuellerStarter

Semantic Models

How to manage measures in different SSLs

Hi all,what’s best practice regarding organizing/reusing measures in SSLs?In my example the customers uses a power bi endpoint and has created a set of measures used by users in power bi. Lets say these are financial measures. A few question regarding best pratice have now popped up:We want to reuse these measures in a different SSL. For example we have SSL for the financial department and one for the board of managers. We don’t want to duplicate the measures, because it makes it hard to keep them up to date. Is there a way to “copy” measures from one SSL to another or to reference measures from a different SSL? We want to “categorize” the measures. So lets say we have financial measures as well as logistics measures. Once we get to a significant amuount of measures, it’s hard to keep track of them. Is there a way to prefix them, add categories of something similar? We had the idea of creating empty “measure” tables in the MDW with a separate “Measure”-Database-Schema. But this also c

8 hours ago

Thomas LindCommunity Manager

Data Sources

Connect to CSV data sourcesTutorial

This is a CData data source, more on what this is in the following link. Add a CData data sourceCSV Information Setup of the provider Connecting to one file Connecting to more than one file Connect to more than one file across sub-directories Connect to CSV files on a FTP/SFTP server Connect to files on Azure Storage Connect using Storage Account and Access key Data Lake Gen 2 ABFSS AzureBlob AzureFile File Share Troubleshooting The file is not using the default delimiter settings Aggregate multiple files into one Select and aggregate files with similar names across folders Controlling the names of the fields Troubleshooting data types Dates are shown in the wrong timezone Convert the character set The files were made with different culture settings CSV InformationHere is a link to the file I use in this examplehttp://mysafeinfo.com/api/data?list=moviesbyearnings2005&format=csvIt is set up with elements like this.Year,Rank,Title,Gross $,Month Opened,Theatres2005,1,St

11276

9 hours ago

Greg LennoxCommunity Manager

Data Sources

Adding a SharePoint site as a data source

This article clarifies two different methods of adding a SharePoint site as a data source in the TimeXtender Portal.Method 1: Basic AuthenticationThis method specifies a user account that does not have MFA two factor authentication enabled and has been granted access to the SharePoint site. The configuration in the TimeXtender Portal for the SharePoint data source is as follows:Provider: Microsoft SharePoint Auth Scheme: Basic Share Point Edition: SharePoint Online URL: <SharePoint Site URL> i.e. https://contoso.sharepoint.com/sites/PBI User: <username> of a user that has been granted access to the site. Password: <password> for the specified user.Method 2: OAuthThis method uses an Azure App Registration and OAuth to connect to the specified SharePoint site. In the TimeXtender Portal, create a new data source and set the provider to be “Microsoft SharePoint”. Auth Scheme: “SharePointOAuth”. Share Point Edition: SharePoint Online URL: <SharePoint Site URL> i.e. h

1324

10 hours ago

Greg LennoxCommunity Manager

Data Warehouse

Create a Role-Playing Dimension

This article clarifies the concepts of role-playing dimensions and explains how to implement them in TimeXtender. What is a Role-Playing Dimension? Example Using Semantic Models Instructions Video TutorialWhat is a Role-Playing Dimension?Role playing dimensions are a useful approach that can streamline your data warehouse by reusing the same dimension table in a different context depending on how it relates to the fact table. When implemented properly, role-playing dimensions create consistency, improve query performance, simplify maintenance, and ultimately enhances the depth and breadth of business insights derived from your data warehouse.ExampleTo illustrate this concept, consider the following two tables: Fact Table: SalesTransactionsOrderID ProductID Quantity OrderDate🗝️ ShipDate🗝️ 001 101 2 2023-10-15 2023-10-16 002 103 1 2023-10-16 2023-10-17 003 108 5 2023-10-17 2023-10-17 Dimension Table: DateDateValue🗝️ Day Month Year 2023-10-1

21 hours ago

pontus.berglundContributor

General

Power BI dataset as data source

Hi,Has anyone used a Power BI dataset as a data source? I have tried using the CData SSAS connector but can not get it to work. Any advice would be appreciated.Best,//Pontus

1 day ago

bkubistekCommunity Manager

Company Announcements

📣 TimeXtender Product Announcements: v6429.1 and Enhanced Snowflake Workflow Features

Exciting News!We are delighted to share two major updates with you:TimeXtender Version 6429.1 Release: We're thrilled to announce the release of TimeXtender version 6429.1! This significant update is designed to enhance data integration and management. Explore the details here to learn more about the improvements. New Features for Snowflake Workflows: In addition to the overall release, we've introduced exciting features tailored for users leveraging Snowflake for data warehousing. Check out the specifics here, focusing on both efficiency and functionality to accelerate data workflows within the Snowflake environment.As TimeXtender continues to pioneer advancements in data management, our latest release, TimeXtender 6429.1, and the seamless integration with Snowflake underscore our unwavering dedication to innovation.We invite you to delve into the enhanced features, designed with precision for optimal efficiency, agility, and expanded capabilities. Your exploration into this transform

1 day ago

pontus.berglundContributor

ODX

OAuth with authorization prefix "Bearer "

Hi,I am trying to connect to a REST API that uses OAuth2 authentication.The API documentation is very clear on what to include in the authentication: I have entered all this information in the REST CData provider and I can successfully use the provider’s “Authorize OAuth” button.However, when I try to test the connection, error “401 - Unauthorizated” is returned.In the API documentation, they state that the token needs a prefix “Bearer “.I suspect my error is caused by the REST CData provider sending the authorization header without the Bearer prefix, like so:Authorization: {ACCESS_TOKEN}Which the API of course does not accept. Is there any way to include a prefix to the token in the authorization header?

1 day ago

WILSPVisitor

ODX

Error "Sequence contains no matching element" on Transfer task when reading from Business Central

2 hours ago

CarloCDOVisitor

Data Warehouse

Removing SQL-Logins

4 hours ago

rory.smithTimeXtender Xpert

ODX

What rights are needed to be able to create roles in the ODX Server to define access

4 hours ago

KaiMuellerStarter

Semantic Models

aftabpVisitor

ODX

Data capture with multiple API-endpoints

Hi,Has anyone worked with API from Energinet?I need some help extracing data from Energinet. Energinet delivers data with multiple endpoints. It starts with https://www.energinet.net/api/unit which gives me this [ { "unit_id": "1234ABCDfolder", "name": "My Company", "links": { "info": { "verb": "GET", "href": "/api/unitinfo/1234ABCDfolder" }, "drilldown": { "verb": "GET", "href": "/api/unit/1234ABCDfolder" } }, "datasources": [] }]Now, i have to drill down to get some info: https://www.energinet.net/api/unit/1234ACDfolder[ { "unit_id": 1Afolder", "name": "Company1", "links": { "info": { "verb": "GET", "href": "/api/unitinfo/1Afolder" }, "drilldown": { "verb": "GET", "href": "/api/unit/1Afolder" } }, "dat

3 days ago

christian.koekenContributor

Semantic Models

The stream does not have an active operation

Dear Support,My customer is having some troubles with executing a tabular semantic model. This customer has three semantic models, Finance, Sales and Logistics. Finance and Sales are running fine, but Logistics sometimes give the error "The stream does not have an active operation!”.I solve this issue by doing a Full process on the model in SQL Management Studio. But what I want to know is what causes this error? As I said Finance and Sales are running fine, but Logistics gives this error now and then.See the file in the attachment for the error. TimeXtender version: 6346.1

7 days ago

TimeXtender Desktop Q&A

Ask questions and find answers about the TimeXtender Desktop Application

ODX

127 topics
663 Replies

Data Warehouse

155 topics
604 Replies

Semantic Models

42 topics
193 Replies

Jobs & Executions

87 topics
334 Replies

TimeXtender Portal Q&A

Ask questions about the TimeXtender Portal

General

22 topics
84 Replies

Data Sources Q&A

Ask questions of about setting up data sources

General

30 topics
129 Replies

REST APIs

18 topics
126 Replies

RSD File Customization

19 topics
118 Replies

SAP

1 topic
1 Reply

Oracle

6 topics
33 Replies

ODBC

6 topics
43 Replies

General Q&A

Ask general questions

General

24 topics
73 Replies

Interoperability with other Platforms & Tools

7 topics
33 Replies

Legacy & Upgrades

50 topics
181 Replies

Security & Compliance

1 topic
3 Replies

Infrastructure & Networking

4 topics
13 Replies

XPilot

0 topics
0 Replies

Learn & Share

Share tips and best practices, show what you've created and inspire others

Success Stories

1 topic
1 Reply

Tips, Tricks and Best Practices

14 topics
16 Replies

TimeXtender Tuesdays

29 topics
40 Replies

Community Announcements

Everything you need to know about this community

Getting started in the community

7 topics
5 Replies

Company Announcements

12 topics
25 Replies

Community Statistics

851: Topics
2,854: Replies
790: Members

Awarded Badges widget

nick.van.treurenhas earned the badge Certified Solutions Architect
VitorChagashas earned the badge Certified Solutions Architect
MartinMemelinkhas earned the badge Certified Solutions Architect
fwagnerhas earned the badge Semantic Model Expert
bas.hopstakenhas earned the badge Product Expert

Show all badges

Leaderboard

Show full leaderboard

Need more help?

Troubleshooting Tips

Learn about troubleshooting techniques

Find a Partner

Find a Partner that fits your needs!

Contact Support

Submit a ticket to our Support Team

Terms and Conditions Cookie settings

Sign up

Already have an account? Login

Login with SSO

SSO login

Username *

E-mail address *

Full Name

(Private)

Only you and moderators can see this information

TX Partner / Customer *

Company

(Private)

Only you and moderators can see this information

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Login with SSO

SSO login

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.