First of all, I'll mention the suggestion in our documentation that, "Generally, if you configure InterSystems to allow unauthenticated access [i.e. UnknownUser], it is recommended there be unauthenticated access exclusively." That is, trying to manage security for UnknownUser isn't necessarily recommended.
The documentation on granting SQL privileges on specific columns (properties) is here. I don't know enough about your situation to feel confident about whether that is what's going on, though. You can also enable auditing for %System/%SQL/PrivilegeFailure to see if that gives you more information. Feel free to open a WRC issue if you are having trouble with this.
Hi Dmitrij,
Member keys must be unique within the first 113 characters, as documented here. It looks to me like the two strings in your table are the same for the first 117 characters, and I think this is why only one member is being inserted when you build your cube.
If you have long strings in your table that may not be unique within 113 characters, and want to create a member for each one, I wonder about using a hash of the string as the member key, creating a property with the text of the string, and using that property as the member name. However, you should avoid this if it would create an excessively large number of members (or if the member names would be so long that it wouldn't be practical to display them in pivots or dashboards).
Hi Dmitrij,
In IRIS 2022.3 and later versions, we display the name of the data source you chose for the widget as the default value for any Choose Data Source control on the widget. If that data source is a value in the termlist your Choose Data Source control uses, its key from that termlist should be shown.
This is how the Dynamic Dashboard in Samples-BI works. There is a widget that should display a pivot called "Use in Dashboards/For Patients Scorecard.pivot" by default, so the widget's Data Source (under Type & Data Source) is set to "Use in Dashboards/For Patients Scorecard.pivot", like it would be for any widget. To allow users to change data sources, there is a Choose Data Source control. Since "Use in Dashboards/For Patients Scorecard.pivot" appears as a value in the termlist associated with that control, the control displays the associated key from the termlist ("Patients by Diagnosis"). If that value did not appear in the termlist, the control would display the full pivot name ("Use in Dashboards/For Patients Scorecard.pivot"). In either case, the widget defaults to displaying the pivot listed as its Data Source.
If the above isn't working as expected for you, or if you are trying to do something different, please provide some details about how you're trying to use this control. I see the same error message as you if I try to change the control's Default Value, but I don't recommend using that option for Choose Data Source controls (the documentation mentions that Default Value only applies to filter controls).