The PDM update goes through fine .. I can see this...
# gooddata-cns
Sheldon Nathan
03/15/2023, 4:09 PMThe PDM update goes through fine .. I can see this in the response data from querying the PDM on the environment. But when I try to create an insight using an LDM object referencing this PDM object - it fails and the error above shows on the GD CN error log
j
Joseph Heun
03/15/2023, 4:15 PMHi Sheldon,
It looks like the LDM and PDM are not correctly synced. You will want to follow the steps here on how to properly update your model.
Could you please take a look at the doc and make sure you have followed the correct procedure, and let us know if you are facing any issues?
s
Sheldon Nathan
03/15/2023, 4:15 PMHi
Sheldon Nathan
03/15/2023, 4:17 PMokay will check that out and let you know how it goes
Sheldon Nathan
03/15/2023, 4:17 PMthanks
đź‘Ť 1
Sheldon Nathan
03/15/2023, 4:21 PMOkay so I have done all these steps .. and I have successfully made large changes to my PDM, LDM etc
Sheldon Nathan
03/15/2023, 4:22 PMthe problem I have is
1. Can joins across LDM objects support the outer join behavior - currently I see an inner join behavior
2. for a PDM object can I set the id and path to be different?
Note I need to make these changes using the API and not from the Designer
j
Joseph Heun
03/15/2023, 4:36 PMI believe CN still only supports outer joins, and I’m not entirely sure if there is some maql workaround yet or not. I will double-check this internally as well as changing the id path for the PDM object.
s
Sheldon Nathan
03/15/2023, 4:37 PMThank you
j
Jakub Sterba
03/15/2023, 4:57 PMSupport of outer joins (“show missing values” option in Analytical Designer and FOR EACH clause in MAQL) has been released in the last GD Cloud and GD CN releases (2.3.0).
s
Sheldon Nathan
03/15/2023, 4:58 PMGreat ... is this automatic or does anything special need to be specified in the API when defining the references?
j
Jakub Sterba
03/15/2023, 4:59 PMNothing special is needed on the level of model. You need to request it by "show missing values" option of attribute used for slicing the metrics or in metric definition using FOR EACH.
s
Sheldon Nathan
03/15/2023, 5:00 PMUmm ... so a metric needs to be defined to support this behavior?
Sheldon Nathan
03/15/2023, 5:00 PMor is it a setting on the AD?
Sheldon Nathan
03/15/2023, 5:01 PMCan this be done via API?
j
Jakub Sterba
03/15/2023, 5:03 PMIt does not require metric. You can do it even in metricless insight using "show missing values" checkbox. It can be done via API as well.
s
Sheldon Nathan
03/15/2023, 5:03 PM@Jakub Sterba could you please point me to the API doc for this?
Sheldon Nathan
03/15/2023, 5:03 PMI plan on upgrading to 2.3 in the next couple of weeks and will be staring the integration tests this week
j
Jakub Sterba
03/15/2023, 5:10 PMREST API documentation of 2.3 describes boolean parameter showAllValues (default is false).
Specifies that the label should be outer-joined.
Jakub Sterba
03/15/2023, 5:13 PMIt is available as property also in REACT SDK
Jakub Sterba
03/15/2023, 5:15 PMYou can find description of the feature and references to documentation in release notes.
s
Sheldon Nathan
03/15/2023, 7:34 PMThank you. I will try this out
Sheldon Nathan
03/15/2023, 7:40 PM@Jakub Sterba @Joseph Heun please note my initial problem with regards to the error message at the start of this trail still remains and I would like to have that resolved.
j
Jakub Sterba
03/15/2023, 7:53 PMCould it be that you defined workspace data filter and this error comes from workspace where value for workspace data filter is not defined?
s
Sheldon Nathan
03/15/2023, 7:55 PMI thought that might be the case so I checked ... and the workspace where this errors does have a data filter defined
Sheldon Nathan
03/15/2023, 7:56 PMactually .. hold that thought.. let me check something and get back to you
j
Jakub Sterba
03/15/2023, 7:57 PMSome value must be set for each child workspace
s
Sheldon Nathan
03/15/2023, 7:57 PMYes that part is in place
Sheldon Nathan
03/15/2023, 8:01 PMDouble checked the filter value has been defined
Sheldon Nathan
03/15/2023, 8:02 PMI think the issue may be with the PDM object - Can you check if the id of a PDM object can be different from the actual table/view name (the table/view name is specified in the path attribute)
j
Jakub Sterba
03/15/2023, 8:05 PMThat could be it. It may be a bug that id cannot be different than path. Let me check if it is fixed already in the latest release.
Jakub Sterba
03/15/2023, 8:29 PMIt really seems to be related to bug “Internal error if table.id does not equal to table.path.last()” which has been solved in the latest release. I think the upgrade to 2.3 will help with this.
s
Sheldon Nathan
03/15/2023, 8:33 PMGreat. Good to know. I can take care of the rest on my side.
Sheldon Nathan
03/15/2023, 8:33 PMThank you so much.
Sheldon Nathan
03/15/2023, 8:34 PMI will test this out on 2.3 in a few days