RajaKoteru Tracker

Merge two visuals with different measures and export table with formatting colors

RajaKoteru — Wed, 30 Oct 2024 18:47:50 GMT

HI,

I am trying to merge two differnt visuals one with direct data and one with summarized totals data as shown below.

What are my options to merge and export with formatting colors

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

RajaKoteru — Fri, 19 Jul 2024 13:38:43 GMT

This solution didn't work. Not sure If I am missing anything. Can you please provide more details.

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

RajaKoteru — Thu, 18 Jul 2024 13:10:48 GMT

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 ?

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

RajaKoteru — Wed, 17 Jul 2024 22:27:22 GMT

Thank you for the quick response.

What is the fact ?

Here's what I have

CUser = USERPRINCIPALNAME()

I need to pass this Cuser value to my dynamic query as below

select sec_lev_grant from table where upper(user_id) = upper('&CUser& ')

I cannot use import for table...because it has huge data. I have to use dynamic query mode.

Please provide more details on how to pass the USERPRINCIPALNAME() value to the query

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

RajaKoteru — Wed, 17 Jul 2024 20:21:08 GMT

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 do import mode.

For example --

select sec_lev_grant from table where upper(user_id) = upper('user_id@domain.com')

Thanks in advance