Forum Discussion

RajaKoteru's avatar
RajaKoteru
Frequent Visitor
2 years ago

How to send USERPRINCIPALNAME to dynamic query to return results based on logged in user

Hi, I have a requriement to show data based logged in user. The logged in user (USERPRINCIPALNAME) need to be passed to query as  a parameter user_id to the backend direct query. Data is huge cannot...
Need Help
muhssamy's avatar
muhssamy
Icon for Resolver I rankResolver I
2 years ago

yes. dont import your table. and dont use dynamic query. just create a table contains IDs and use it also in import mode and let the relationship do the filtrations

something like the following image

 

USERPRINCIPALNAME() will filter the dimention that will have a join in your database with the right id 

 

RajaKoteru's avatar
RajaKoteru
Frequent Visitor
2 years ago

Thank you for the reply. Without dynamic query I am confused how it filters the data.

Is fact a table that we get the results from the query and UserDim is the measure  ?