qdirector | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
Posted an answer
DataLink / JDBC / EXEC

Hello - we have set a release date of 19.1.1 including a fix for this issue on Tuesday, May 14. We appreciate your patience and thank you for your support.

May 10, 20195
Received an upvote
April 10, 201910
Posted an answer
DataLink / JDBC / EXEC

Quantrix support desk can provide you with previous version installers. You can contact them at support@quantrix.com. -Mike

April 9, 20195
Posted an answer
DataLink / JDBC / EXEC

Hi - with Quantrix 19.1.0 we introduced SQL validation to enhance our security of the application. We want to prevent a user from executing malicious SQL that could damage a DB etc. However, we soon realized...

April 9, 20195
Answer was selected as best
March 7, 201910
Posted an answer
DataNAV error when trying to add one DataNAV category into a matrix with another DataNAV category

Hi - I concur that this is a limitation in the DataNAV functionality. DataNAV  does not know what to do when items from different data sources are in the same matrix, so it prevents it from happening....

December 17, 20185
Posted an answer
DataNAV: Please clarify the differences between “Update items” vs “Refresh” vs “Refresh All”

This will be changing a bit with the new iteration of data import in a 2019 release... and we will try to make this more clear in the UI (it is admittedly confusing) but a lot of the concepts will be the...

November 28, 20185
Received an upvote
November 27, 201810
Posted an answer
Any way to automatically update Item Names based on criteria?

Have you checked out Item Generation? (Right click a dimension tile > configure > generate items)

November 26, 20185
Received an upvote
Referencing data from one matrix to another

Hi - not quite following you on the need to link or not to link categories, but regardless you can accomplish a non-linked scenario via the following Select formula. Budget = select(Budget::Month,@Budget::Year:Month,@Year:Month)...

November 5, 201810
Received an upvote
Referencing data from one matrix to another

I think you just need to link the Year and Month dimension in your comparison matrix with the budget and actual matrices. Right click and choose Link Category. Attached is an example and then you can do...

November 5, 201810
Received an upvote
Referencing data from one matrix to another

Without seeing your model this is a bit of a guess but I think this is a good candidate for a SELECT or USING AS function. Take a look at this area of the on-line help to see if this is useful. [url:2yuel6bl]http://www.quantrix.com/help_resources/5.1/webhelp/quantrix.htm#using_the_select_function.htm[/url:2yuel6bl]...

November 5, 201810
Answer was selected as best
November 5, 201810
Received an upvote
Need help re how to insert text in a column using key codes

Hi - I took a quick stab at this. I think you can do what you want with a SELECT statement. See attached. -Mike

November 5, 201810
Received an upvote
Case Function

There is a CASE function in the Quantrix function library that does something very similar... is that what you are looking for?

November 5, 201810
Received an upvote
Data Analysis Question

Hi - here is one approach. You have to write a formula for each year but I think it is reasonable. It uses the USING AS functionality along with an associated lookup table for the 'master companies'.

October 29, 201810
Answer was selected as best
October 29, 201810
Received an upvote
Stuck with formula referencing another Matrix

You might need to link your month dimension? Right click on the month category and choose 'Link Category' and you will get an option to link with the other month category in the model. Once done, the...

October 29, 201810
Posted an answer
Script get model name and username on qloud

Thanks for posting and sorry for delays in answers. Scripts on Qloud can sometimes work differently. The UserName really refers to machine name. On your local computer that is fine but on Qloud the machine...

October 23, 20185
Posted an answer
Script Export Excel current page only

Hi - thanks for posting and sorry for delay in response. I have added this an an enhancement request for our scripting actions.

October 23, 20185
Load More