yellowfin screen

Hi Ronnie,

Thanks for reaching out. If your users aren't going to have Dashboards assigned, at least not initially, you can configure Yellowfin to login to a different page instead of to Dashboards.

This can be configured from Profile Settings > Display Preferences:

As you can see, you can choose to login to Timeline or Browse Page instead.

If you want to change these values in bulk, you can link the desired users' IpId's from the IpClass table to the IpPerson value in the PersonConfiguration table and update the corresponding ConfigCode value ENTRYPAGE of DASHBOARD under ConfigData:

Please let me know if you have any questions on this.

Regards,

Mike

Hi Mike,

Thank you for your prompt replay. When I tried to display the record I get the error message below:

select * from PERSONCONFIGURATION where CONFIGDATA= 'DASHBOARD' and IPPERSON = '5';

ORA-00932: inconsistent datatypes: expected - got CLOB

00932. 00000 - "inconsistent datatypes: expected %s got %s"

*Cause:

*Action:

Error at Line: 1 Column: 41

Please see attached file for more details.

Thanks

Hi Ronnie,

Thanks for your reply. I don't quite understand how a simple Select statement would generate an 'inconsistent datatypes' error. Based on Oracle's documentation, the SQL syntax appears to be correct.

Are you able to select other values from the this or other tables? If you select without a where clause or with just one where clause (no 'AND'), does it work? The error message you've provided is generated from Oracle itself (ORA-00932), so I'm not sure how much we can troubleshoot this on our end without actually having a copy of your configuration database on-hand.

Ultimately though, the value you'll want to update the ConfigData 'DASHBOARD' value to is 'BROWSE'.

Something like:

UPDATE PersonConfiguration SET ConfigData = 'BROWSE' WHERE IpPerson = '5';

If you want to do this for individual users, or:

UPDATE PersonConfiguration SET ConfigData = 'BROWSE' WHERE ConfigData = 'DASHBOARD';

If you want to do this globally.

If you try one of these, does this work at least? Or do you still see the 'inconsistent datatypes' message?

Regards,

Mike

Hi Mike,

Thank you for support. I updated the ConfigData column with "BROWSE". I have couple questions:

1. The user asked for: "We'd like it if the user logs in and only sees the reports in the Department Cost folder", please the attached file.

2. My company changed the company standard email address from FirstName_LastName@denso-diam.com to FirstName_LastName@nadenso.com. What is the easy way to change all yellowfin user's email.

Thanks

Ronnie

Hi Ronnie,

1. This should technically be possible via Tight Integration. Specifically, when configuring Single Sign-On Session Options. That said, this is not so straight-forward or simple to achieve, and the setup of this falls outside the scope of standard Support. These points considered, if you're interested in pursuing this further, I'd recommend reaching out to your Account Manager to discuss Consulting options as I'm afraid Support will be unable to assist further regarding this.

2. This should be simple enough to accomplish. In terms of user logins, you would simply replace the EmailRight values in your IpClass table:

UPDATE reportheader SET EmailRight = 'nadenso.com' WHERE EmailRight = 'denso-diam.com';

The other location the email addresses would have to be updated is in the IpContact table, which can be achieved by executing a query such as the following:

UPDATE ipcontact SET EmailAddress = REPLACE (EmailAddress,'@denso-diam.com','@nadenso.com'); 

Just to be safe, I recommend that before running any queries against your Yellowfin Configuration Database, you make sure to have full, up-to-date backups of both your Yellowfin Configuration Database and your Yellowfin Installation folder. This way, if something goes wrong you can revert back to your current state.

Please let me know if you have any questions on either of these.

Regards,

Mike

Hi Mike,

Thank you for your support and updated information. I will update the email in the both tables. Please you can close this ticket.

Thanks

Ronnie A.

Hi Ronnie,

You're welcome! Please don't hesitate to reach out with any other questions or concerns.

Regards,

Mike