Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I noticed that I can't add data from the data manager if my app is published to a stream.The only way is to do it on an unpublished application (for example, duplicate the one that is on the stream).
Is there any way to allow app data to be added to a stream ?
I tried by acting on the security rules as I found a post that said it was possible but without success 😞
Why you need to add data in a published app? i believe is conceptually wrong for several reasons like:
1) a published app is used by your users so what happens if the data you're loading are wrong?
2) you cannot check if the data you're loading fits with your datamodel, so if your new data creates synth keys, circular loops or other inconsistencies in your datamodel.
3) What happens the next time you publish the new version of the app over the published one? your added data will be lost...
I highly raccommend you to make all datamodel changes in the DEV version of your app and create the proper data flow in your ETL that allow you add data when the app is published without break the rules created by Qlik (using additional tables in your warehouse or just using excels files).
Why you need to add data in a published app? i believe is conceptually wrong for several reasons like:
1) a published app is used by your users so what happens if the data you're loading are wrong?
2) you cannot check if the data you're loading fits with your datamodel, so if your new data creates synth keys, circular loops or other inconsistencies in your datamodel.
3) What happens the next time you publish the new version of the app over the published one? your added data will be lost...
I highly raccommend you to make all datamodel changes in the DEV version of your app and create the proper data flow in your ETL that allow you add data when the app is published without break the rules created by Qlik (using additional tables in your warehouse or just using excels files).
@micheledenardi lays out an excellent and well-structured defense of the default behavior of Qlik Sense. This default behavior is such that with default security rules and settings, users can not see or edit the data model for published apps.
This is expected behavior which is dictated by the default security rules
It is possible to edit these rules and create new custom security rules.*
The following article provides an example of rules for such a scenario:
Security Rule Example: How to show data model viewer for published apps
*WARNING: It should be noted that Qlik Technical Support has very little scope in planning, implementing, or debugging custom rules. This information is given for informational purposes but one should take all precautions when implementing custom rules in Qlik Sense.
The article Collection of Specific Rule Scenarios and Customization of Qlik Sense Security rules offers more information on this warning as well as links to examples of custom rules and further reading to better understand the functionality of Security Rules in Qlik Sense