Forum Discussion
Filtering by different data sources
Dear community,
after having set up a model that imports a time series (on 15min-base over at least one year) for one case I would like to extend that model now.
It would be neccessary to have the data of different users that each have the same time stamp in one model so that in the end it is possible to switch between the users without mixing them up. The core issue is that I don't want to copy the model each time and sest it up for a new user but simply add a new user and then be able to choose each single one seperately to display the development over time.
So my question now is how to implement this in the import or in the filtering/ slicing or both maybe?
Thanks for your help in advance!
6 Replies
Hi acteno,
Currently, I'm not understanding your requirement completely. Do you mean each user accesses to data model can see his own data? Which data source type are you connecting to? If you are connect to SSAS database, you might want to take a look at links:
Implement Dynamic Security by Using Row Filters
If I misunderstand the issue, please clarify the requirement vividly.
Best regards,
Qiuyun YuHello Qiuyun_Yu,
thanks for your reply, maybe I didn't explain clearly enough.
It's not that different users have access to the database but I have data from different users/customers/cases over a certain time that I would like to implement and visualize always in the same way. So far I have always copied the model and made a new one for every case connecting to this specific database. But I would like to know if there is a possibility to have one model, as it always has to meet the same requirements, where I can switch easily between the different datasets displayed.
Another problem is, when in the base model, the years 2000-2010 are implemented but for a certain case I only have 2006 data, I copy the model and change the data source but somehow the rest, where there is no data inscribed in the new dataset, isn't simply left blank but still has the "old" data from the former dataset. Is there maybe a simple tag that I missed to tick?
thanks for the help in advance!
And sorry, I forgot: I am connecting to excel or csv sheets currently but also would start to use databases in future.
