vpluchet | Reputations

Generic selectors
Exact matches only
Search title only
Search in content
Answers
Questions
Asked a question
Dat Nav / Data Link on multidimension matrix

The Data Link / Data Nav creation window allows to chose "Two Dimensional Matrix Data" as a Data Source. However, there is no option to choose a "Multidimensional matrix" as a Data source. Therefore, how...

November 18, 20182
Posted an answer
Sum formula facing SIZE issue

Dear Rich, your answer was great as usual. This works perfectly. A big thank you.

November 14, 20185
Asked a question
Sum formula facing SIZE issue

In "GWP PCL" matrix of the enclosed model, I have a formula to sum "GWP" data from another matrix (GWP Data Matrix). The formula is GWP = sum(summary(GWP Calculations::GWP)) using LOB Aggregates::Reporting...

November 13, 20182
Posted an answer
Model becomes slow

Dear Rich, I have done what you suggested - removed the Summary Items. This greatly reduced the number of eclipses. Not only has the speed returned to normal, but also the model size has reduced by one...

November 13, 20185
Posted an answer
Model becomes slow

Dear Rich, Many thanks for your answer, these are very helpful tips. And I'll get rid of the annoying summaries indeed. I'll try to think of a better way to input the adjustments as well. Many thanks for...

November 13, 20185
Asked a question
Model becomes slow

I have a model which is not big (the main data table has around 10,000 records) but which is already a bit slow. For instance if I add a row into the "Adjustments GWP Assumptions" matrix and enter some...

November 12, 20182
Posted an answer
Timeline recursion does not skip summaries

Dear Rich, A big thank you, this is very instructive and a clever way to resolve the issue. I agree that summary items could be better configured to avoid such problems. I will try your solution, and I...

November 12, 20185
Asked a question
Timeline recursion does not skip summaries

The enclosed model contains a timeline (Year/Month). In the "Closing UPR Assumption" matrix, I compute the "Calculation" item using a weighted average of the last twelve "Base" items (the weights are in...

November 12, 20182
Received an upvote
November 5, 201810
Answer was selected as best
November 5, 201810
Received an upvote
November 5, 201810
Posted an answer
How to change canvas comments according to scenario

I was able to do this by creating a "Comment" matrix, using the Scenarios as one category and entering different comment items  (Comment 1, Comment 2, or other names) under a Comment Item category. It...

November 3, 20185
Asked a question
How to change canvas comments according to scenario

Dear all, I have several scenarios for a financial simulation. The output of the simulation is shown in a canvas where the desired scenario can be selected. I also have comments in the canvas. Is there...

November 3, 20182
Posted an answer
Summarise data by a criteria which is in another matrix

Great answer, many thanks

October 29, 20185
Asked a question
Summarise data by a criteria which is in another matrix

In the attached simple model, I have a table named Marks which contains marks by student by course. In another table named Demographics, I have the students names and gender. I want to populate a third...

October 29, 20182
Posted an answer
Maintain budget versions

To QuantrixAuthority: thank for your answer, this is helpful.

October 29, 20185
Asked a question
Maintain budget versions

What would you recommend as best practice to maintain different budget versions: through different models through a timeline generic item (Budget, Forecast 1 , Forecast 2, Actual) through a category...

October 5, 20182
Registered
October 5, 201810