At the moment, you can do row filtering in a Data Model, by applying an enforced filter. This works fine in simple scenarios. In my case, I have 150 different users who each need to be able to see ...
This would be handy. For the mean time I am doing this via Postman. I have added my postman + an example csv that you can use. Dont forget to set the url and token and define if you are importing users or groups.
Edit; i cant upload anything else except images. so here is the postman code
{
"info": {
"_postman_id": "127906d0-a14a-44b6-876e-5cf7a822bfe7",
"name": "Stap 3 EC Beveiliging Copy",
"schema": "https://schema.getpostman.com/json/collection/v2.1.0/collection.json",
"_exporter_id": "4316343",
"_collection_link": "https://ysisinzicht.postman.co/workspace/Ysis-Inzicht~5666f0d4-674f-41cc-96c2-5b5152f2e46f/collection/4316343-127906d0-a14a-44b6-876e-5cf7a822bfe7?action=share&source=collection_link&creator=4316343"
},
"item": [
{
"name": "https://URL/api/elasticubes/datasecurity",
"request": {
"auth": {
"type": "bearer",
"bearer": [
{
"key": "token",
"value": "TOKEN",
"type": "string"
}
]
},
"method": "POST",
"header": [
{
"key": "accept",
"value": "application/json"
},
{
"key": "Content-Type",
"value": "application/json"
}
],
"body": {
"mode": "raw",
"raw": "[ { \"column\": \"{{column}}\", \"datatype\": \"text\", \"elasticube\": \"{{cube}}\", \"members\": [ {{naam}} ], \"server\": \"localhost\", \"shares\": [ { \"party\": \"{{groupid}}\", \"type\": \"group\" } ], \"table\": \"{{table}}\" }]"
},
"url": {
"raw": "https://URL/api/elasticubes/datasecurity",
"protocol": "https",
"host": [
"URL",
"nl"
],
"path": [
"api",
"elasticubes",
"datasecurity"
]
}
},
"response": []
}
]
}CSV is
cube,naam,groupid,column,table
CUBE,"""SECURITY_VALUE""",USERID/GROUPID,FIELD_NAME,TABLE_NAME