To homepage To homepage

Unanswered questions

8 Topics

rory.smith
TimeXtender Xpert
rory.smithTimeXtender Xpert
asked in Data Warehouse

Should multiple SQL statements be possible in the query tool?

In v20 and before you can define multiple statements in a query tool window. This can be handy when doing comparisons or dealing with wide tables. v20 statement 1 v20 statement 2 In v21 the second statement is simply ignored for SQL DWH instances and results in an error in Snowflake:v21 SQLv21 Snowflake ; separating statements Was this taken out of v21 or should this actually work like in v20?

0
rory.smith
TimeXtender Xpert
2 days ago
christian.koeken
Contributor
christian.koekenContributor
asked in Semantic Models

Problem with project variable used in semantic model

Dear Support,TimeXtender version: 20.10.43.64In TimeXtender we have two project variables that we use in a data selection rule in a semantic model.In attachment "project variables settings” you'll see the settings of the two variables.The dynamic variable script that it has to execute is:SELECT CAST(MAX(LoadingDate) AS DATE) FROM FinFact.FacturatieControle to get the highest date. The other script will get the lowest date.In attachment "semantic model with data selection rule” you'll see the data selection rule in the semantic model. We want to filter the date dimension so that it only shows the dates which are in the fact table (FacturatieControle is the fact table).The problem now is that the project variable won't update although we set the resolve type at 'Every time’.Only a deploy and execute of the model will update the date filter. Can you help me with this issue? Best regards,Christian Koeken 

4
rory.smith
TimeXtender Xpert
2 days ago
K
Contributor
KajEmergoContributor
asked in Semantic Models

Row level security Tableau endpoint

Shortly we will be implementing Tableau endpoints with TimeXtender. With respect to RLS, I read the following in the ‘Semantic Model-Level and Row-Level Security’ tutorial:Is it on the roadmap for TX to implement RLS on Tableau endpoints as well?Maybe you can elaborate on the mechanism behind the .tds endpoints, do these need RLS like you can configure in Tableau (i.e. by configuring something on the semantic model in TX which is currently unavailable)? Or do they use a connection to the DWH (SQL db), thus using the permissions on tables related to the users of the dashboards?

1
Christian Hauggaard
Community Manager
2 days ago
rory.smith
TimeXtender Xpert
rory.smithTimeXtender Xpert
asked in Data Warehouse

Should it be possible to define a relation from a View to a Table in a Snowflake DWH instance?

I have been working on some Snowflake testing and am wondering whether not being able to drag a field from a custom view to a table to define a relation is on purpose or an oversight? This is typically useful for defining role-playing dimensions, given that you can define relations between tables and custom views don't seem to be an issue I don't think there should be a technical hurdle.

1
Thomas Lind
Community Manager
3 days ago
R
Starter
RutgerNijlandStarter
asked in Jobs & Executions

Executions, emails and MFA

Hey, in the documentation on executions/jobs I found the following information on setting up emails as notifications for succeeded and failed executions:Enter the information for the SMTP server you want to use under Mail Server. Since October 1st, 2022 Microsoft has ended basic authentication on email on online SMTP servers. To deal with this you need to add an Application (client) id for an app to use for this and the Tenant ID for your company. The app you use needs the following permissions.   You need the three options, (Mail.Send, SMTP.Send and User.Read) set on your app You need a Admin to grant consent for the three settings. The user account you add as the From Email and the User name needs to run without Multi-factor Authentication. If you use GMail to authenticate, it is not possible to use email and an std password. Here you need to turn on 2-step authentication for your email account and then use the App Password in the password field. My questio

1
erik.van.mastrigt
TimeXtender Xpert
4 days ago
rory.smith
TimeXtender Xpert
rory.smithTimeXtender Xpert
asked in 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

11
Christian Hauggaard
Community Manager
6 days ago
D
Explorer
dsvartzmanExplorer
asked in ODX

Error 503 (ODX)

hi, Lately were are getting alot of 503 exceptions.  Error message is typically: The task '983693' failed:System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> System.Net.Http.HttpRequestException: Response status code does not indicate success: 503 (The server is busy.).   at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()   at Azure.Management.REST.RestWebRequestManager.<SendRequest>d__6.MoveNext()--- End of stack trace from previous location where exception was thrown ---   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)   at Azure.Management.REST.RestWebRequestManager.<SendRequest>d__5.MoveNext()--- End of stack trace from previous location where exception was thrown ---   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()   at System.Runtime.CompilerSe

1
D
Explorer
11 days ago
S
Contributor
sierd.zuiderveldContributor
asked in ODX

Error on table with 0 files and incremental offset rule

We have data sources where we apply dynamic incremental rules, so if column == “Name” then apply incremental load with 3 day offset. Now there exist some tables in the data source that are currently empty (in the actual source). They do have the incr column and therefore the offset rule. Now we noticed that the ODX transfer on these tables works fine.However when we execute a table with such a table in the mapping we obtain this error: System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> System.InvalidOperationException: Sequence contains no elements   at System.Linq.Enumerable.Max(IEnumerable`1 source)   at DataStorageEngine.DataLakeGen2.DataLakeGen2DiscoveryHubExecution.<ProvideDataTableForDiscoveryHubSQLTransferAsync>d__14.MoveNext()   --- End of inner exception stack trace ---   at System.Threading.Tasks.Task.WaitAll(Task[] tasks, Int32 millisecondsTimeout, CancellationToken cancellationToken)   at Dat

12
Christian Hauggaard
Community Manager
12 days ago

Badge winners

Show all badges
Terms and ConditionsCookie settings