Click more>Properties or you can see them in Edit report
100
I want to see the context but not the EPM pane, what should I do?
Uncheck display EPM pane in User Options>Display
100
I want the base level of data but I don't want lines empty or zero lines, what setting should I change?
Change the No Data and Zero Values settings in Sheet Options or report editor
100
EPM keeps trying to recognize everything I type, what should I do?
Turn off Activate Member Recognition
200
I have a lot of changes but I don't want the report to refresh everytime I change the report. What should I do?
Turn on Freeze Data Refresh
200
Where do you create a favorite context?
Context options>context favorites
200
Should you store the environment in the connection?
No, if you uncheck this box the environment will stick.
200
I want to be able to double click a cell to be able to select a member. What formula should I use for that?
EPMSelectMember
200
I only want to show results in excess of $5M, where can I do this?
Filtering tab on the report editor
300
If you are creating a report in Sandbox but want to be able to use it in Production later what should you do?
Check the Do Not Store the Environment in the Connection
300
My columns are not automatically fitting to the size of data in the column. What should I do?
Turn on Auto Fit in the Sheet Options
300
I want to send a report to someone who doesn't have EPM access. What should I do?
Turn on "Offline Mode"
300
What is the EPM formula to find a member property?
EPMMemberProperty
300
I've used the EPMFormattingSheet to establish my formatting but when I refresh nothing happens, what is the first thing I should check?
Check the boxes on the formatting sheet to make sure they are turned on.
400
What are the three ways to create a report? You have to get all three.
Member recognition (just type), drag and drop in navigation pane, New report on EPM tab.
400
If you are running a report and you know data should have changed but the data isn't changing, what should you do?
Clear metadata cache
400
I want to generate the same report for 10 different profit centers. What is an easy way to do this?
Worksheet Generation
400
I only want to show the third level in the hierarchy. How can I do this?
Filter by properties using HLEVEL
400
I want the account name to show up on every row but it is only showing up on some, what setting should I change?
Repeat row headers in Sheet Options or the Report editor.
500
How do you calculate parents in hierarchies?
Sheet options>refresh or report editor options
500
I want to show 2017 YTD Actual in the first column, 2017 YTD Budget in the second column, and 2017 Full Year Budget in the third column, how can I make sure these columns stay this way?
Modify the Olap member formula to a cell that has the member you want.
500
I want a formula to calculate on two cells in a specific spot in my excel sheet, which two options should I turn on?
Activate Local Member Recognition and Use position in axis
500
What is the priority on the formatting sheet?
Bottom to top
500
I want a rolling trend of CAS for the last 12 months, what formula will allow an easy way to dynamically trend time?