InLine SQL Query

Hello Ilmar-Jürgen Rammi,

My name is Sharwari Inkane from the Yellowfin Technical Support Team. We have received your support request, and I will be your primary contact on the following ticket:

Ticket Number: #32272
Case Title: InLine SQL Query

Issue Overview:

InLine SQL Query

Allow me some time to look into this. I will get back to you with my findings as soon as possible.

Sincerely,

Sharwari Inkane

Yellowfin Technical Support Engineer

Hello Ilmar-Jürgen Rammi,

To connect an InLine SQL Query to Yellowfin users, you need to ensure that your database contains a table or view that includes user information that can be linked to Yellowfin users. This typically involves having a table with user identifiers that match those used in Yellowfin, such as user IDs or email addresses.

Here's a general approach to creating an InLine SQL Query that connects to Yellowfin users:

1. Identify the User Information: Determine which table in your database contains the user information you need. This table should have a column that can be linked to Yellowfin's user identifiers.
2. Write the SQL Query: Write a SQL query that retrieves the necessary user information. Ensure that the query includes a join or filter that connects the data to Yellowfin's user identifiers.
3. Create the InLine SQL Query in Yellowfin:Go to the Yellowfin interface and navigate to the section where you can create InLine SQL Queries.Enter your SQL query into the query editor.Test the query to ensure it returns the expected results.
4. Use the Query in Reports or Dashboards: Once your InLine SQL Query is set up, you can use it as a data source for reports or dashboards in Yellowfin. This allows you to display user-related data alongside other business metrics.

If your database does not have a direct link to Yellowfin user information, you may need to create a view or a temporary table that includes this information. This could involve joining your existing tables with a user table that contains the necessary identifiers.

Remember, the key to successfully using InLine SQL Queries with Yellowfin users is ensuring that your database schema includes a way to link your data to Yellowfin's user identifiers.

Let me know if it helps or have any additional questions.

Regards,

Sharwari Inkane

Yellowfin Technical Support Engineer

Hello Ilmar-Jürgen Rammi

I wanted to follow up with you regarding the solution I provided in my last email. Did the solution we sent you resolve the issue?

Please let us know if you need additional support on this issue.

Thank you,

Sharwari Inkane

Yellowfin Technical Support

Hi!

Thank you for your answer. It did clarify how InLine works.

Can you tell me if there's a way to enable the access filters for all users by default? I mean that once I enable the access filters on a report level, the new users will see the report's data until it is decided to limit access.

Best wishes,

Jürgen

Hello Ilmar-Jürgen Rammi

Thank you for your response.

Regarding your new question about enabling access filters for all users by default, I have created a separate ticket to address this. You can track the progress and updates for that issue using the following link: [https://community.yellowfinbi.com/ticket/32289]. I will assist you further on this new ticket.

For the Inline SQL query topic, please let me know if you have any additional questions. If everything is clear, kindly confirm, and I will proceed with closing this case.

Looking forward to your response.

Thank you,

Sharwari Inkane

Yellowfin Technical Support

Yes, you can close this ticket.

Thank you!

Hello Ilmar-Jürgen Rammi,

I appreciate the confirmation, and I'm going to close this ticket now. If you have any other issue please contact us again by opening up a new ticket and we will provide additional support.

We value the customer experience and feedback and would like to understand your experience from our recent interaction. Please spare a moment to respond to the quick survey that was sent; we assure you, it won’t take much time to answer!

Your valuable feedback will help us serve you better in the future. Thank you for taking the time.

Thank you,

Sharwari Inkane

Yellowfin Technical Support