qdirector | Answers

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions

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
1 Vote

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

View Question
1 Vote

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
1 Vote Selected

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
1 Vote Selected

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
1 Vote

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
1 Vote

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
1 Vote

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
1 Vote

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
1 Vote

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

View Question
1 Vote
Load more answers