Forum Discussion
Filtering by different data sources
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 Yu
Hello 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.
Hi acteno,
Based on my understanding about your first question, the data model contains different users/customers/cases over a certain time. You want to query different results for different cases then present them in the report, right?
If that is a case, you can create multiple queries to retrieve data from one data model, then in Query Editor to modify each query to get expected data for each case.
Regarding the second issue, do you mean when you implement years from 2000 to 2010, actually only 2006 has data, but other years also contain the data? You can open Query Editor then find the column year, filter data only when year equals to 2006.
If issue persists, please share some screenshots to elaborate the issue.
Best regards,
Qiuyun Yu
