- Smart view for excel how to#
- Smart view for excel full#
- Smart view for excel code#
When creating your sheet, try to keep in mind what would be easier to look at. This way, you can analyze members by scrolling down. Often times, the best way to set up a grid is to have the account dimension down the rows and the year dimension across the columns. When comparing different accounts, it is often easier to put them in the rows as it is easier to compare numbers by scrolling down as opposed to across. In the case that you may want to have varying members, such as the accounts dimension, you have to figure out if you want them on the rows or columns. By doing this, it helps unclutter your spreadsheet and if you need to change that one member, you only need to do it once as opposed to changing it across all the columns or down all the rows. Any time that you want one member to be consistent throughout the entire workbook, it should be put up in your POV. Here are a few ideas to help organize your Smart View spread sheet. Simply thinking about whether a member should be on the rows or columns takes time and can be troublesome.
Under Formatting, select “Use Excel Formatting”.īy selecting this option, all formatting will be retained when retrieving in Smart View.įiguring out the best way to organize your data in Smart View can be difficult and takes time and practice to perfect. The steps to retain excel formatting is as follows: This one is easy to fix, but is asked about all the time. Keep this in mind when changing the values as to not confuse others who will be using your reports.Ī common frustration that people often complain about is that they work long and hard on making their spreadsheet look nice and presentable, and then they retrieve the data in Smart View and all that formatting disappears. Because an intersection has no data does not necessarily mean that its value should be zero. Zero and No Data are completely different from each other. This will make it so formulas calculate however, users must be careful with entering zeros in the place of #NoData/#MissingData. Because of this, many people want to change those values to 0. Often times having a #NoData or #MissingData can interfere with calculations in the sheet. Under Replacement, highlight the #Missing and insert desired value. Follow the steps below to change the values: Many users do not like the look of this and would like to replace these with another value. Whenever an intersection has no data, Smart View will display #NoData or #MissingData. This issue is a common occurrence among Smart View users. Understanding and Dealing with #NoData or #MissingData Smart view for excel how to#
Right click on “Parent” to specify how to highlight the parent members.īy doing this, all parent members will be highlighted to make it easier to figure out which members can be drilled down further. 
Under Cell Styles, expand “Analytic Services”, then “Member Cells”, and then check “Parent”. In the Smart View tab, select “Options”. 
Smart view for excel code#
Follow the steps below to color code parent members: You can color code parent members to identify easily which members can be drilled down. Several common questions come up when dealing with Smart View so the following is a list of tricks and tips to help you make the most of your Smart View experience.Ī common question that arises is figuring out what members can be drilled down. It offers hundreds of options to help pull, analyze, and report data.
Smart view for excel full#
Using Smart View is one of the most important and powerful ways to take full advantage of Essbase. Tips and Tricks to help you make the most of Smart View
0 kommentar(er)
