Hello Doug, you may get an answer or help with your question here, but I would suggest if you feel this is a bug, please log the issue with Support. The question will get routed to the right person. I...
View Question
Product Management | Answers
Product Management 72 Rep.
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...
View Question Have you checked out Item Generation? (Right click a dimension tile > configure > generate items)
View Question 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...
View Question Hi - Not sure why I did not recommend this last time around... but since you are using timeline the inter-matrix summaries should just... work. I did two things: 1. Linked the scenario dimension. 2....
View Question 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)...
View Question 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...
View Question 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]...
View 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'.
View Question Took a quick look at this. Is this formula what you are looking to do? IS Item = sum(select(Source Matrix::IS Item,@Source Matrix::IS Item,@IS Item)) skip Sum
View Question