jlin | Reputations

I would like to add that "Item Names" has its use; however the current implementation is very flawed, in that the generated items loses all grouping structure. I would propose that the Generate Items feature...

Sau, The image of your sample code - how are you getting Quantrix to display the formulas in this way (with dark background)? It's very nice on the eyes!

You have my vote, Sau. Although syntactically I think putting the variable definitions near the front of the formula (after any "In ... " statement, but before the item name whose value is being set)...

If I understand Tahir correctly, he believes it would be easier to maintain a model where a single one matrix presents differently (w/ rows & columns filtered depending on user role) versus creating...

If I understand correctly, Tahir may have in one matrix (or table view) some sensitive information that should only be shown depending on user role. He desires to use a filter expression that filters rows...

Would it be possible to set properties such as width, height, hidden etc. for elements of a Canvas? It doesn't seem like the object model allows any access. What I would like to do is add some Actions...

Thank you Mike. The extra explanation helps!

Is this what you want? A single formula will do it.

What does this error mean? "Category XXXX references a field that is not compatible with the data source defined in matrix YYYYY " I have an XML data source containing multiple objects such as Employees,...

I manually edited the name of a item that was brought over from an XML Data Source via DataNAV, and also changed a value that was brought over via DataNAV. If I right-click on the Category tile and choose...

I'd like to be able to better differentiate between items in a category populated by DataNAV vs ones I manually add/modify, including Summary items. I don't see any way of "locking down" a DataNAV category...

FYI if you have the need to do different offsets simultaneously, I would suggest calculating a single index value (that ignores all summary items). That way can support multiple, differently offset data...

I am in fact already using Item Generation extensively! I end up having an input matrix with category DepartmentsInput and DepartmentsInfo, use Generate Items to populate items for a second Category Departments...

I'd like to keep the Item Names of Category A synced to match the value of a particular Item from Category B. I tried making converting Category A into a Primary Key and I can make it work once, but any...

You can't. You've already grouped A into 2, and B into 1. If you want to group A and B you'd have to remove groups 2 & 1 first.

I think your question about doing Excel-like sensitivity analysis may be addressed by the new Solver feature... I wouldn't know as I haven't used it yet. However, if you set up your scenarios such that...

Oh, and converting and maintaining the Excel file as a CSV is not an option. I would like the Excel file to preserve formatting, multiple sheets, etc.

What vendors/options are there for integrating Excel files as Data Sources to read/push data from Quantrix? The closest JDBC driver solutions I've found still seem overkill; certainly the price is considering...

I logged an IDBS case in 2016 and after 19 months of silence was finally told of a workaround for this bug. It's a hack, but it works. I'm posting it here publicly in case anyone else runs into this problem....