tag:blogger.com,1999:blog-2615703102299902978.post8403044094549691367..comments2024-02-03T00:03:10.178-08:00Comments on Glenn Schwartzberg's Essbase Blog: Undocumented Change to Smart View 11.1.2.5GlennShttp://www.blogger.com/profile/08532634180859769798noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-2615703102299902978.post-14410457488012395202015-04-11T22:44:36.244-07:002015-04-11T22:44:36.244-07:00Ahhh Glenn - you're a lifesaver.
Been writing...Ahhh Glenn - you're a lifesaver.<br /><br />Been writing something up which worked perfectly in a previous version. <br /><br />Spent the last few hours thinking I was going insane because something I've got listed as working perfectly 8 months ago no longer works! <br /><br />Anyways - finally went looking and found your note....Refresh selected functions and their dependents fixed my problem.<br /><br />So thankyou very much! <br /><br />Cheers<br />Pete Petehttps://www.blogger.com/profile/06439105832806165572noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-55830579828395817602014-09-02T09:20:05.283-07:002014-09-02T09:20:05.283-07:00thanks GlennS -- "Refresh selected functions ...thanks GlennS -- "Refresh selected functions and their dependents" did the trick!ansky08https://www.blogger.com/profile/01167112053350380168noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-10628478121395058682014-09-01T14:09:57.350-07:002014-09-01T14:09:57.350-07:00Phillip,
I have seen too many implementations wher...Phillip,<br />I have seen too many implementations where a global variable was used but in one application they overrode it for special needs. I agree, managing the variables at the same lever is the best approach, but some functions like in Planning can make that difficult. This at least gives you a way to deal with the variationsGlennShttps://www.blogger.com/profile/08532634180859769798noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-58402749393958265982014-09-01T14:09:56.675-07:002014-09-01T14:09:56.675-07:00Phillip,
I have seen too many implementations wher...Phillip,<br />I have seen too many implementations where a global variable was used but in one application they overrode it for special needs. I agree, managing the variables at the same lever is the best approach, but some functions like in Planning can make that difficult. This at least gives you a way to deal with the variationsGlennShttps://www.blogger.com/profile/08532634180859769798noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-81042759606495320682014-09-01T13:10:51.007-07:002014-09-01T13:10:51.007-07:00Hello Glen,
... The interesting thing is unless ...Hello Glen, <br /><br />... The interesting thing is unless you qualify the application, you will get the global variable... <br /><br />Well, when there is no variable at application and database level (which you call global variable, but is a database variable) will it pick up the application variable?<br /><br />It is a feature, but I wonder how useful it is. When we do implementations, we agree on one level of variables and not more. Just because other clients do not have this feature <br />and it will become too complex to maintain the code with substitution variables with the same name, for different purposes.<br /><br />Regards,<br />PhilipAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-655614932647067052014-08-28T13:51:39.428-07:002014-08-28T13:51:39.428-07:00something you can try, is on the Smart View Option...something you can try, is on the Smart View Options is an option "Refresh selected functions and their dependents" This makes Smart view do two passes to resolve the variable then retreiveGlennShttps://www.blogger.com/profile/08532634180859769798noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-35857397603056976372014-08-28T13:26:57.268-07:002014-08-28T13:26:57.268-07:00I know this post is old-ish, but it just became re...I know this post is old-ish, but it just became relevant to me.<br /><br />Thanks for your insight on how to keep the substitution variable within the SV report upon refreshing.<br /><br />It works great with ad hoc analysis -- say HsGetVariable("&CurMonth") returns "Aug", and the value helps return Aug figures. However, when using a function HsGetValue which references the cell with the HsGetVariable function... I get "#Error Run Formulas Interrupted" upon refreshing. <br /><br />I have tried a couple variations, including trimming the value returned and embedding the HsGetVariable within the HsGetValue formula -- to no avail. Any ideas?<br /><br />I have set up an SR to Oracle since I cannot find the answer to this.ansky08https://www.blogger.com/profile/01167112053350380168noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-61963978634385116132014-03-30T19:46:23.392-07:002014-03-30T19:46:23.392-07:00Hi Glen,
If you use this function and then use Un...Hi Glen,<br /><br />If you use this function and then use Undo/Redo function on the retrieval sheet the formula get replaced by value!.<br /><br />Thanks, Gaurav Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-71226437107962334542014-03-11T15:37:23.115-07:002014-03-11T15:37:23.115-07:00As far as I remember, in the old add-in, we had th...As far as I remember, in the old add-in, we had the same issue. If I wanted to use a variable in a calc script, I had to have it in quotes for the calc and without them for the spreadsheet as it would return quotes and all. If you do wrap it in the replace function, then make sure you go into the smart view options and checkmark refresh selected functions and their dependents on the advanced tabGlennShttps://www.blogger.com/profile/08532634180859769798noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-59898328219454450952014-03-11T15:00:56.754-07:002014-03-11T15:00:56.754-07:00Hey Glenn, cool trick!
Question.. for some reason...Hey Glenn, cool trick!<br /><br />Question.. for some reason, the values of my variables are wrapped in quotes. I think FR likes it that way? <br /><br />They work fine using the static method on the spreadsheet, &CUR_MONTH, but the HSGETVARIABLE function returns the value, quotation marks and all, which isn't recognized, so the dimension is brought in at the top level. <br /><br />I can wrap the function in the REPLACE function, but I was wondering if you ran across this, or had any thoughts..<br />Anonymousnoreply@blogger.com