Hi, We're looking to integrate a dashboard into our proprietary website. We have a single OLAP cube that houses all of our client data, segrated by year. When the clients use our website, they are only allowed to see their information. For example, when company A logs in, they cannot see company B's data. We deal with a lot of protected health information, so it has to be secure. I guess what I'm trying to do is cull the cube for only a single client's information and only display that client's information within the dashboard. Is this even possible? I've seen some small-scale implementations that use multiple versions of the same pbix file, but with over 10000 clients, this isn't remotely possible. Would appreciate any direction anyone could give.
