It's fairly common to want to display the user name for a custom feel to the user experience. Ideally, you would have a Username attribute built into your schema which ties back to the MicroStrategy user. If you don't, dont worry. There are a few ways you can do this in MicroStrategy I'll share with you today.
First let's take a look at my user setup. Notice my "Login" vs my "Full Name". Depending on which method you select, we'll display one of these fields.
1. Dynamic Text
If you're adding a user name, chances are you're doing it in a document. In a document you can use dynamic text to drop the users name into a text box.
Just add the text box and add in {&User}
Now render the report and see that the User's "Full Name" is displayed.
2. A Metric
This method is very simple. You c GBan create a metric defined as Max(?[User Login]){~}.
This is going to take the user log-in and drop it into a Metric. This is very handy if you want to display the user name in a report and not in a document. This method will display the "Login"
3. FFSQL Report
Similair to the use of the metric above, we're going to create a FFSQL (Free Form SQL) report and leverage the ?[User Login] system prompt. Create a FFSQL report by
select the "Create Report" option in developer an select Freeform Source/SQL report.
The SQL will change slight based on your DB platform. I'm on MS SQL so I input
Select ''
Then I place my cursor in between the single quotes and insert the "User Login" system prompt.
Next right click the lower area and define you attribute as I have below
Click OK and run your report to see your Username appear as an attribute.
Thanks for checking out this blog post. If you found this post helpful please consider donating. Any contribution is appreciated! Just click the PayPal icon at the bottom of this page.