|
Website |
gr8
website jonno, love it |
|
Re:
Website |
hear
hear! what happens now? |
|
Re:
Website |
Thanks
guys, the next task on the project plan is to recruit a few more Hyperion
experts prior to the launch on 15/9.<br /><br />We have a few
moderators lined up as well as a few already registered. Hopefully we can
recruit a few more CHPs before the Go-Live date.<br /><br
/>Thanks again for signing up! |
|
Re:
Website |
Why not
post on network54? Great board. |
|
Re:
Website |
I agree
Aleck, the Network54 sites, especially the Essbase forum have immense
traffic. Yet to see what the search and navigation is like here, but first
impressions are that this is long overdue - especially for people who are
looking to monitor multiple applications.<br /><br />It would be
great to see if we can entice discussion on how people are deploying cross
products (and 3rd party non Hyperion), as well as getting Hyperion to offer
advise and next generation options to assist in deployment decisions.<br
/><br />Noel |
|
Re:
Website |
Thanks
for the feedback NG. My thoughts exactly. The HYPEd team believe in providing
a free and general facility that would help users:<br /><br
/>-seek help<br />-retain knowledge<br />-interact<br
/>-enhance use of Hyperion products<br /><br />It's
still early days yet and the layout/lookf-feel of this forum is by no means
complete. But I guess a line in the sand has been drawn and we'd
sure like to see if we can complement HDN as well as Network54 -
it's not a competition. All three forums are great places to read up
on Hyperion and all have their own unique strengths and weaknesses. <br
/><br />Welcome aboard!<br /><br />Cheers,<br
/>Jon |
|
Re:
Website |
I'd
like to offer my own humble opinion on two things that were suggested on
another forum (regarding this one).<br /><br />1) That it takes
too many clicks to get to a message. This is complete
nonsense. The format of network 54 would simply not be appropriate
here. The ability to quickly narrow your search down to a specific
subset of messages is well defined here, and poorly defined there.
In both cases, you can do a search, but in this forum, you have the ability
to wade through a significant number of categories and track issues of
interest -- without wading through all those that are not of interest to
you.<br /><br />2) That the site is too
"colorful". Again, complete nonsense. A
spreadsheet sitting on any analysts desktop will at various times be more
bright/colorful than this site is. However, I do agree that the
selection of colors for 'solved' threads could use a little
tweaking. Toning it down wouldn't be a bad idea, I
suppose.<br /><br />My question about #2 -- is it possible to
leave the topic text the same and change just the title bar color?
If so, I'd say a slightly darker blue would be good, along with the
"thumbs up", you have enough of a signal to
"highlight" the thread. I don't know if
this is possible, though.<br /><br />The bottom line is that I
like this format much better than HDN and Network54. They all have
their good points, but in terms of thread organization, this one is easier to
navigate [i]in a useful manner[/i].<br /><br />-Doug<br /> |
|
Re:
Website |
I like
the fact that there are other Hyperion products listed. Even though
people say Network54 is for all the Hyperion products, in my opinion,
it's all about Essbase.. |
|
Re:
Website |
Thanks
guys.<br /><br />First things first - I've amended the
'topics solved' background colour to an unobtrusive
lavender(?I'm no graphic designer). Let me know what you think. That
bright green was quite a shocker I must admit (it was the default setting) -
not good for hangovers at all. Will see what I can do with the header and
thumbsup gif.<br /><br />Thanks for the feedback on search and
categorisation. We humbly concur. The criteria we used to determine forum
software, style and all the touchy-feely stuff were:<br />- coverage
for all Hyperion products (recognising that all requests for help are
weighted equally and not biased by number of licenses or age of
product)<br />- search functionality (as much as possible, allow users
to quickly narrow down on product)<br />- cheap to run
(obviously)<br />- easy to maintain/administer<br />- affords a
few bells and whistles like Topics Solved and Applaud/Warn<br /><br
/><br />The bottom line, however, is that all Hyperion forum users
usually do so from work and as such have considerations such as firewalls,
webpatrols and bandwidth. We thought that between the three or four forums
already available for Hyperion, we could add a few more options so that any
Hyperion user anywhere, can still seek help regardless of setup
restrictions.<br /><br />Our thinking was always to co-exist.
It's not about being better or worse, it's really about
whether requests for help are answered and problems are solved.<br
/><br />Love to hear more feedback.<br /><br />Jon |
|
Re:
Website |
The
multiple sections for different Hypeiron products was long overdue. This
looks great!<br /><br />The only comment from my side will be, if
it is possible to disable all the smilies and other formatting but only show
up as text (i.e.) SMILIES...click on that all smilies will pop-up in a new
window and so on. Since many contractors if they want to post and the smilies
make it look like we are chatting, but that might just be @ my place.
Anyways...if it is possible to add this option then that would be an great
add-on....great job folks! :) |
|
Re:
Website |
Thanks
hypess. (btw I've updated your profile - thanks for your
email)<br /><br />Will see what we can do with the forum software
re emoticons. garycris was of the same opinion but we're a little
hamstrung on tweaking this annoying little feature.<br /><br
/>I've re-ordered the categories placing BI before Apps as it
seems the bulk of posts at the moment are in the BI section. Saves you from
having to scroll down [u]although [/u] if you click on the arrowhead next to
the Category header (twice) you can bookmark the resulting URL so it takes
you there straightaway at launch. (how's that for a tip?)<br
/><br />Appreciate all the support and feedback from the guys that
have come over from Network54 to help out. We can only aspire to building a
forum of such content quality.<br /><br />Don't forget
to surf the posts for cries of HELP! |
|
Re:
Website |
This
change is really good as I feel that at any given time at least
two-third's or more number of posts will be essbase centric. Also
IMHO I thing the idea of separate sections for Analyzer, Reports, Visual Explorer,
SQR and other reports based apps is a littkel too congested. If we can
combine the reports forum into one and based on the volume of posts in the
next three months you can decidee whether there is a need for separate forum
or they can stay at one place. I like the idea of separate sections for every
app, but I believe it is a little too congested. Just my 2 cents!<br
/><br />Thanks Admin for the profile change. :) |
|
Re:
Website |
Big day
today....<br /><br />The HYPEd dashboard says:<br />7 new
posts<br />12 new members<br />26 users online today<br
/><br
/>[color=Orange][url]http://hyped.biz/community/index.php?action=stats;expand=200509#200509[/url][/color] |
|
New
section |
Hi<br
/><br />Can I suggest that a new board for scripts or downloads be
made available? |
|
Re: New
section |
I
concur.<br /><br />The existing downloads section
doesn't split out by product/purpose/type. It would be
nice to have a section that allows people to look for, say, MAXL scripts, or
such. There is also a big difference between a download section for
utilities (like the stuff I tend to focus on), and downloads for patches and
the like.<br /> |
|
Re: New
section |
OOps -
sorry Dougware. Missed this post. Happy to re-structure the Downloads
section. As the reigning 'Don of Downloads', you should
have the major say in how you'd like to see it laid out.<br
/><br />Let me know, and if the forum software allows it, then
consider it done!<br /><br />Cheers |
|
Newbie |
I'm
a newbie to Hyperion products having worked more with Oracle Financials. My
introduction was to Essbase which I find a very good product.<br
/><br />I like HDN but find the interface a little unfriendly so I
am looking forward to making this my new Hyperion tech home
;D<br /> |
|
Essbase
vs Cognos |
How does
Essbase stack up against Cognos? (esp with their new reportnet product - has
anyone used it?) |
|
Re:
Essbase vs Cognos |
I've
used contributor (cognos) and i find it a little clunky |
|
Re:
Essbase vs Cognos |
i saw the
demo from cognos (for powerplay and reportnett) - pretty good i think. quite
flexible. commentary is easy to add |
|
Re:
Essbase vs Cognos |
The two
products exist in slightly different spaces within the B.I.
architecture. Cognos does overlap a lot with what Essbase offers,
and so a comparison isn't completely out of the question, but most
of the time, the full needs will determine which one is more
appropriate.<br /><br />For instance, if you use an existing tool
for data warehousing, and want a report tool that can handle multiple layers
within an environment, Cognos is a slightly better fit. On the
other hand, if you have a lot of incoming data from various places, and need
to give analysts write-back capability with less extensive reporting needs,
Essbase is a better fit. When you want "best of
breed" in any one category, Essbase provides this within the
analytical and consolidation stages, but leaves gaps on both ends that have
to be filled.<br /><br />In the end, most companies will find
Essbase to be more adaptible to analytical needs, and cognos more adaptible
for reporting needs. The current market favors Essbase because the
gaps are easier to fill than overcoming the lack of a solid write-back
capability.<br /><br />The question really isn't about
which tool, but what the company is trying to use it for (where's
the pain at?). Knowing this, you can target the tool to the need,
and then deal with the problem as a whole instead of as a selection of
elements.<br /><br />Political issues can also weigh more heavily
than technical choices. Taking the "single supplier"
approach has merit, leaving Cognos a bit short in comparison. On
the other hand, if you are a true blue "Microsoft shop",
Cognos may be easier to slap into existing applications. So no
matter how you look at it, the answer isn't a slam dunk one or the
other.<br /><br />However: with 2/3rds of the top 100 U.S.
companies using Essbase, and a much smaller number using Cognos, you have to
consider Essbase ahead on the popularity poll. :)<br /> |
|
Re:
Essbase vs Cognos |
Did you
guys read the article in the news box (top-right of screen) - Hyperion
Essbase named as top ten technology innovation of the decade? |
|
Re:
Essbase vs Cognos |
How about
pricing ? <br /><br />I mean generally speaking !<br
/><br /> |
|
Cancelled
queries |
We've
just installed Essbase at work having migraetd from another tool - so we are
all newbies. If a user closes the excel spreadsheet after kicking off a big
query, will essbase know to cancel the query request? |
|
Re:
Cancelled queries |
afraid
not - the query will keep on running in the background even after Excel has
been closed. If the query is a big one you might want to kill the request at
the server end.<br /><br />hope it helps. |
|
Re:
Cancelled queries |
A quick
add-on to dummyhalf's post. Essbase is a client-server
configuration. Users initiate from the client but the work is done
on the server. So if a user kicks off a query/report, calc script,
or something like that, they can turn off their machine and go home while the
process runs. If you want to kill the request, you need to do it from
App Manager or EAS (server side)<br /><br />Regards,<br
/><br /> |
|
Re:
Cancelled queries |
In order
to prevent queries from running forever, there are configuration settings in
the Essbase.cfg file - one of them is QRYGOVEXECTIME - it allows
you to set a maximum query duration. You can also kill queries
using EAS or MaxL, if one is running past a certain time.<br /><br
/>Hope That Helps.<br /><br />Jade |
|
Re:
Cancelled queries |
Thanks
everyone I will pass on all your comments to my team. |
|
Error msg |
"Analytic
Services timed out while trying to perform an operation"<br
/><br />this error happens every second or third day and is not
consistent<br /><br />HELP! ??? |
|
Re: Error
msg |
This one
could be a number of things:<br />- network issues<br />-
installation/configuration<br />- bad data<br /><br />Have
you any more information? Was there a recent software/hardware upgrade? etc? |
|
Re: Error
msg |
It seems
to occur on one particular workstation albeit in a random pattern. PC is
running the SOE without any strange additional software that I can see.<br
/><br />We can probably rule out data corruption as other workstations
can access the reports/data.<br /><br />Thanks for the tip re
network issue - never occurred to me. Will run some tests in this
regard.<br /><br />THANKS! |
|
Re: Error
msg |
Have a
look at this link:<br
/>[url]http://essbase.com/techdocs/essbase/essbase_71/Docs/errmsgs/erhelp.htm[/url]<br
/><br />It might be your NETDELAY and NETRETRYCOUNT settings, but
the article has a few other suggestions. |
|
Re: Error
msg |
thanks
dummyhalf |
|
ETL
functionality in Essbase? |
our
company got taken over recently and in the resulting integration, essbase was
picked as the reporting tool-of-choice. it currently sources its data from
our largish sales datamart via our existing (shonky)proprietary reporting
tool. does essbase have any ETL functionality that we might be able to use
and so bypass our in house tool? |
|
Re: ETL
functionality in Essbase? |
Well,
load rules have limited ETL capability, but Essbase is not an ETL
tool. They can do character replaces, change case, do basic
sorting, but that is about it. Depending on what kind of data manipulation
you are needing, you might have to look at using a staging database or some
other ETL products like Informatica, etc.<br /><br />Most ETL
processes can be handled using SQL and perhaps even other scripting languages
like Perl, but some of the ETL products out there make it a lot easier.<br
/><br />Regards,<br />Jade |
|
Re: ETL
functionality in Essbase? |
There are
a couple of options. <br />Essbase uses load rules to take
text files from any source and manipulate them to be loaded into your
cube.<br />There is an SQL interface that lets you query SQL databases
and load the results directly into your cube.<br />Hyperion offers a
data integration connector for SAP, but this requires you use Essbase
Integration Services as well, so that starts to get into a really large initiative.<br
/>Then there is Hyperion Application Link (HAL) an add-on product that
uses adapters to link data from multiple sources to Essbase.<br
/>Lastly, there are third party solutions such as UpStream that will do
this for you. UpStream happens to be an excellent product.<br
/>Your best bet is to discuss with your sales rep or a qualified
consultant to determine what best fits your needs.<br /><br
/>Hope that helps<br /><br /> |
|
Re: ETL
functionality in Essbase? |
Thanks
guys - that's a great help. I apologise JCole, for not being able to
Accept both replies(!)<br /><br />We have a guy on the team that
is keen on Informatica given his background with it but I think Architecture
might dictate we keep everything 'integrated' ie. minimise
vendors and customisations. But I will also investigate using PERL/SQL. But
thanks for that.<br /><br />Garycris - thanks for the tip on HAL.
this might end up being the most politically correct choice if it's
not too hard to implement.<br /><br />.....many more questions to
come.......<br /> |
|
Essbase
Helper |
[b]E[/b]ssbase
[b]H[/b]elper ([b]EH[/b]) is a supplemental add-in for
Hyperion€™s Essbase add-in for Excel. Its primary function is to
enhance Essbase connectivity by managing connections transparently (while
navigating around your workbooks). <br /><br />Templates
with multiple retrievals are made "safer" and easier to use
because [b]EH[/b] will ensure that you never erroneously perform an operation
against the wrong database, such as when a previous connection times out at
the server and another current connection is substituted without your
knowledge. <br /><br />Besides managing the connectivity
to the appropriate database, [b]EH[/b] manages multiple template areas within
a single tab, and ensures that each area be dealt with without having to
manually select the range of cells to act against. In addition, each
area can be flagged as read-only, and also remembers its own individual
Essbase settings.<br /><br />Additional features include the
ability to automatically locate the current member when you open the member
selection dialog (a mild but common pain when making selection changes), and
the ability to disable Essbase menu items that represent inappropriate
operations (ie, the lock/send functions when the active area is defined as
read-only).<br /><br />[b]EH[/b] was designed for the
user€™s convenience, and can be fully operated via a simple
toolbar, the Essbase menu, and (in the fully registered version)
programmatically via a fully documented VBA object model. The key benefits of
this add-in are in the simplicity it offers to the user, reducing time,
errors, and maintenance effort.<br /><br />[b]NOTE: [/b] The
current version has a cosmetic bug in the installer, which causes the
documentation file icon to launch the configuration tool instead. An
updated version will be forthcoming soon.<br /><br />-Doug<br
/> |
|
Re:
Essbase Helper |
Great app
DougWare! |
|
Re:
Essbase Helper |
I have
had this app for a little while now (from Hyperion forum) and I think
it's very good. Love your work. |
|
Re:
Essbase Helper |
Thanks
guys, feel free to let me know what you think about the others. I
take constructive criticism well, so don't hold back.
:)<br /><br />There *are* a couple of fixes needed in HE, but
mostly cosmetic (like errant notices that an area overlaps when it
doesn't). I'm also tempted to roll Zoomer into HE
entirely, since Zoomer is such an simple item. Alas, my evenings
and weekends are already too busy for making many changes on these tools
(mostly writing game add-ins in small).<br /><br />-Doug<br
/> |
|
Essbase
Zoomer |
Essbase
Zoomer is a simple add-in that augments the Essbase addin for Excel.
It expands the Zoom menu to allow you to choose the level you are zooming, as
well as changing zoom-related toggles -- without going in and out of the
Essbase options dialog.<br /><br />For serious ad-hoc operations,
Zoomer will allow you to navigate without wearing your finger out (via
constant double clicking), making it faster as well as easier.<br
/><br />-Doug.<br /> |
|
DougB's
Outline InfoTool |
This is a
simple workbook which makes it easy to extract outline information.
No magic, just easy to use convenience.<br /><br />-Doug<br
/> |
|
Re:
DougB's Outline InfoTool |
I tried
this utility but kept getting outline errors. Is there a different
instruction sheet available? |
|
Re:
DougB's Outline InfoTool |
I'm
pretty sure this utility won't work with V7.x outlines (saved via
EAS, at least).<br /><br />I don't have access to the V7
api yet, but when I do, I'll upload a new version for V7 (I
don't know if any new functionality will be added -- it all depends
on what changes were made in the API).<br /><br />Sorry -- I was
really looking forward to V7, but it's certainly not being kind to
me. ::) |
|
Security
Workbook |
This is a
relatively simple workbook with code to automate retrieving and updating
Essbase security information. It's very good for documenting
the current security state, and even at realligning users and groups.<br
/><br />[color=Red]Caution[/color]: Use at your own risk. I
say this not because it's a risky tool, but because it can be
mis-used too easily.<br /><br />-Doug<br /> |
|
Re:
Security Workbook |
It has
come to my attention that one of the references to the version above may
cause it to not work well on some versions of Office. The version
attached here should remove that issue (please let me know if
otherwise).<br /><br />-Doug<br /> |
|
Re:
Security Workbook |
You've
been a busy boy dougware!<br /><br />Great output. |
|
Re:
Security Workbook |
<br
/><br />We got error while using this vba application --
'esbapin.dll can not be found'. esbapin file is
found under hyperion\essbase\bin folder. Wondering if this can be
fixed.<br /><br />Thanks a lot. |
|
Re:
Security Workbook |
sounds more
like a local problem than something Doug has done. <br /><br
/>Check that the X:\hyperion\essbase\bin directory is in your path ... and
that system variable ARBORPATH is set ... <br /><br /> |
|
Essbase
and Adobe compatibility |
Has
anyone experienced any compatibility issues between the Excel add-in and
Adobe add-in? One of my users complains of mysterious machine locking and the
only difference I could find in the PC image was Adobe. I have not been able
to replicate on another machine and it does not happen
'on-demand'.<br /><br />Thanks in advance. |
|
Re:
Essbase and Adobe compatibility |
I've
run the Essbase addin v6.5 through v7.1.2 with Adobe Acrobat 5 and 6 and
haven't had any problem.<br /><br />I can't say
it is not responsible for the problem you are having, but I figured I would
mention it hasn't been a problem for me.<br /><br />Best
of luck trying to resolve.<br /> |
|
Re:
Essbase and Adobe compatibility |
We had
users who could not view large pdf docs off the web using adobe.
They were getting the reports from Hyperion Reports, but the problem turned
out to be a modification to the windows registry on every machine in the
corporation that limited the bandwidth usage of each machine.
<br />This resulted in the PDF not displaying on the user's
machine as desired. It may "look" like a computer
lock up situation , but the user could do other things just fine,
it's just the PDF never displayed.<br />The fix of course was
to remove the windows registry change from their computer so they could view
larger PDF documents via internet explorer.<br />Otherwise, our users
have used Adobe and Hyperion for years without any conflicts. |
|
Re:
Essbase and Adobe compatibility |
Thanks
very much for your replies. I will definitely try the registry suggestion. |
|
Introduction
to Hyperion: Article |
Introduction
to Hyperion <br /><br />* What is
"Hyperion"?<br /><br />Hyperion(r) is the
global leader in Business Performance Management<br />Software.
More than 9,000 customers €“ including 91 of the Fortune
100<br />€“ rely on Hyperion software to translate strategies
into plans,<br />monitor execution and provide insight to improve
financial and<br />Operational performance. Hyperion combines the most
complete set of<br />Interoperable applications with the leading
Business Intelligence<br />platform to support and create Business
Performance Management<br />Solutions. A network of more than 600
partners provides the company's<br />innovative and
specialized solutions and services.<br /><br />Named one of the
FORTUNE 100 Best Companies to Work For 2004, Hyperion<br />employs
approximately 2,500 people in 20 countries. Distributors<br />represent
Hyperion in an additional 25 countries. Headquartered in<br />Santa
Clara, California, Hyperion generated annual revenues of $622<br />million
for the 12 months that ended June 30, 2004. Hyperion is<br
/>traded under the NASDAQ symbol HYSL.<br /><br />For more
information, please visit www.hyperion.com,<br
/>www.hyperion.com/contactus or call 800 286 8000 (U.S. only).<br
/><br />Please visit: http://www.hyperion.com/company/overview/<br
/><br />* What is BPM?<br /><br />Business Performance
Management is one of the fastest growing and most<br />strategic
categories of enterprise software today.<br /><br />A category of
technologies and practices that enables organizations to<br />translate
strategies into plans, monitor execution and provide insight<br />to
improve financial and operational performance.<br /><br />* What
Is Business Intelligence?<br /><br />Business intelligence is a
category of software that enables companies<br />to access, analyze and
share information to understand how their<br />business is performing.
Business intelligence provides individuals<br />with access to historic
information from a wide variety of sources and<br />tools for analysis
and statistical predictions. The result is improved<br />decision
making, leading to better operational performance.<br /><br
/>__Please visit:
http://www.hyperion.com/products/bpm_suite/glossary.cfm<br /><br
/>________________________________________<br /><br />*
Business Info: Hyperion Solutions Corp. (HYSL)<br /><br />1. CBS
MarketWatch (HYSL)<br /><br
/>http://www.marketwatch.com/tools/quotes/quotes.asp?symb=HYSL%20&siteid=mktw&dist=mktwqn&cbsReferrer=www.answers.com<br
/><br />2. CNBC MSN Money (HYSL)<br /><br
/>http://moneycentral.msn.com/scripts/webquote.dll?ipage=qd&Symbol=HYSL<br
/><br />3. CNN Money (HYSL)<br /><br
/>http://money.cnn.com/quote/quote.html?shownav=true&symb=HYSL<br
/><br />4. Yahoo (HYSL): Quotes Info<br /><br />http://finance.yahoo.com/q?s=HYSL&d=v1<br
/><br />5. Hyperion Jobs Average Salary & Contractor Rates
<br /> <br
/>http://www.itjobswatch.co.uk/skills_and_rates/hyperion.do<br
/><br />___________________________________________<br
/><br /><br />* Hyperion News:<br /><br />1.
Business Directory<br /><br
/>http://www.business.com/directory/computers_and_software/software_applications/enterprise_resource_planning_erp/hyperion_solutions_corporation<br
/><br />2. Google Latest News<br /><br />http://news.google.com/news?q=Hyperion+Solutions+Corp.&btnG=Search+News&hl=en&edition=us&ie=UTF-8&oe=UTF-8<br
/><br />3. Market Watch<br /><br
/>http://aolpf5.marketwatch.com/tools/quotes/profile.asp?<br
/><br />_____________________________________<br /><br
/><br />* Hyperion Products:<br /><br />A.HYPERION BI
PLATFORM<br /><br />1. Hyperion Analyzer<br
/>http://dev.hyperion.com/products/analyzer/<br /><br />2.
Hyperion Application Builder<br
/>http://dev.hyperion.com/products/application_builder/<br /><br
/>3. Hyperion Application Link<br
/>http://dev.hyperion.com/products/application_link/<br /><br
/>4. Hyperion Essbase<br
/>http://dev.hyperion.com/products/essbase_analytic_services/<br
/><br />5. Hyperion Master Data Management Server<br
/>http://dev.hyperion.com/products/mdm/<br /><br />6. Hyperion
Metrics Builder<br
/>http://dev.hyperion.com/products/metrics_builder/<br /><br
/>7. Hyperion Objects<br
/>http://dev.hyperion.com/products/objects/<br /><br />8.
Hyperion Performance Suite Intelligence, SQR<br
/>http://dev.hyperion.com/products/performance_suite/<br /><br
/>9. Hyperion Reports<br />
http://dev.hyperion.com/products/reports/<br /><br />10. Hyperion
HUB<br />http://dev.hyperion.com/products/hub/<br /><br
/>B.HYPERION APPLICATIONS<br /><br />1. Hyperion Pillar<br
/>http://www.hyperion.com/products/applications/planning_budgeting_forecasting/pillar/<br
/><br />2.Hyperion Planning<br
/>http://dev.hyperion.com/products/planning<br /><br />3.
Hyperion Financial Management<br />http://dev.hyperion.com/products/financial_management/<br
/><br />4. Hyperion Enterprise<br
/>http://www.hyperion.com/products/applications/consolidation_reporting/enterprise/<br
/><br />5. Hyperion Business Modeling<br />http://dev.hyperion.com/products/business_modeling/<br
/><br />6. Hyperion Business Rules<br
/>http://dev.hyperion.com/products/business_rules/<br /><br
/>7. Hyperion Performance Scorecard<br
/>http://dev.hyperion.com/products/performance_scorecard<br /><br
/>8. Hyperion Strategic Finance<br />http://dev.hyperion.com/products/strategic_finance<br
/>_________________________________________<br /><br /><br
/><br />Thanks to:<br /><br />My Family members<br
/><br />Jon HYPEd administrator <br /><br />Kimberley
Bermender<br />Sr. Manager, Marketing<br />Hyperion Solutions<br
/><br />John Kopcke<br />CTO Hyperion Solutions<br
/><br />Adam Souza <br />HDN Hyperion Solutions<br
/><br /><br />Note: "Portions provided by Hyperion
Solutions Corporation are<br />Copyright 1996 to 2005, and are used
with permission of Hyperion.<br />Hyperion, the Hyperion
"H" logo, and Hyperion product names are<br
/>Trademarks of Hyperion. The views expressed in other than
Hyperion<br />Provided materials are not necessarily the views of Hyperion."
<br /><br />About me:<br /><br />I€™ve
Bachelor€™s Degree in BS (Computer Science).<br /><br
/>I've Experience with Hyperion Products Essbase Planning
Analyzer HAL Reports HFM etc.<br /><br />I€™m
Hyperion Tech Author.<br /><br />Hobbies:<br /><br
/>Writing Hyperion Tech Articles Yoga Writing Stories Politics
Loving NewEngland Patriots Cartoonist.<br /><br
/><br /> |
|
Download
Hyperion Technical Documentation |
Hyperion
provides technical documentation for a number of their products through their
developer's website. Click on the following link to browse
the different products and download installation guides, administrator
guides, technical references, etc.<br /><br
/>[u][url]http://dev.hyperion.com/resource_library/technical_documentation/[/url][/u]<br
/><br /><br />If you don't find what you are looking
for there, post a request and if we have it, we'll forward it to
you.<br /><br /><br />Regards, |
|
Problem
attaching files/downloading attachments |
Hi
All,<br /><br />dougware and garcris was kind enough to drop me
an email saying that some user groups on the forum did not have permission to
view/attach files. I have since found the setting at fault and rectified.
Please let me know if there are any other teething problems - great to flush
out before official launch!<br /><br />Thanks guys!<br
/><br />Jon |
|
Re:
Problem attaching files/downloading attachments |
Hi
there<br />Yesterday I had no problems downloading utilities, but I am
having a particular problem downloading Essbase Zoomer today. I log in as
normal, and just before clicking on the download file I can see my login name
at the top of the screen, so I know that |I am successfully logged in. As
soon as I click on the download file, I get taken to a screen where it asks
me to log in again. <br /><br />Regards<br /><br
/>matthu |
|
Topic
solved : the mysterious green color |
Query re
the mysterious green background on certain posts. 'Topic solved'
is functionality that is available on this forum (most boards other than
general discussions etc). If you start a new topic in a tech board, you have
the option to nominate whether or not a reply has helped fix the problem
described (signified by a tick image on your original topic that only the
topic starter can see). Once topic has been deemed 'solved'
the poster with the most relevant reply will have that post highlighted in
green and the big thumbs up icon will show at the board index level.<br
/><br />thanks for the query garycris - i see you have a thumbs
against your posts already. well done and thanks for helping out! |
|
Essbase
as a datasource |
Hi,<br
/><br />Our reporting setup is DBs = Sybase + mainframe, ETL =
Informatica, BI = Business Objects. We have been asked to extend our
reoprting framework to include another part of the business that uses
Essbase.<br /><br />I was wondering if we can use Essbase as a
datasource.<br /><br />thanks |
|
Re:
Essbase as a datasource |
Is this
what you had in mind? |
|
Re:
Essbase as a datasource |
Perfect!<br
/><br />thanks |
|
Apologies
for site downtime |
The
webhost had to reboot the server.<br /><br />Apologies for the
inconvenience caused. |
|
Downloads
enable/disable |
Sorry
dougware,<br /><br />I had the master
'attachments' setting set to
"disable".<br /><br />Please try again.<br
/><br />Apologies for the runaround. We'll get this site
running right eventually!!!!<br /><br />Jon |
|
Hyperion
Essbase Auto-Processor (HEAP) |
Background:
<br /><br />One of the departments here runs 3 calc scripts in
succession for each organization that updates data, but needs to define
substitution variables that are specific to each run. The need is
known up front, but varies in a way that makes it difficult to
'bake' the business logic into an independent
process. As a result, they have to perform as many as 160 seperate
manual steps (set variables, run calcs, repeat type stuff). This
process was not just manually exhaustive, it was error prone and time
intensive (sometimes spanning 16 hours of effort or more). To top
this off, they needed to run this cycle multiple times each month!<br
/><br />HEAP was designed to automate this long sequence of
steps. It was not meant to be a full automation tool, just a client
utility to make variable and alias dependent calc scripts easier to
manage. Although this tool was developed rapidly (less than 10
hours, including the instructions and demonstration), it proved to be
invaluable to the department mentioned above, saving a significant amount of
time as well as effort.<br /><br />Will this benefit your
organization? Possibly, but it's probably more likely to
be a good example of how a rapidly developed tool can benefit your own
specific needs. Even though I spent less than a day in coding,
it's very well designed and commented, so if you're just
getting your feet wet into Essbase automation, it's also a good
start.<br /><br />Then again, you may find a good use for it as
it is. :)<br /><br />-Doug<br /> |
|
Re:
Hyperion Essbase Auto-Processor (HEAP) |
Thanks -
it's a great case study in scripting an automation function. |
|
Best
practice on cube development |
We're
getting our first few development requests from our users and are looking at
building a few cubes. I was wondering if there are any best practice
guidelines on:<br />[list]<br />[li]size of cubes[/li]<br
/>[li]number of dimensions[/li]<br />[li]number of
members[/li]<br />[li]any other performance considerations[/li]<br
/>[/list] |
|
Re: Best
practice on cube development |
Hi
There,<br /><br />That is quite a big question to
answer. We were there about 9-10months ago and there's
still plenty to learn. Is it possible for you to go on a course do
you have any manuals?<br /><br />If not go to the Help dropdown
and select on the Administrator Guide, this should get you started.<br
/><br />As Confucius said....."Every journey starts with a
few small steps!"<br /><br />Good luck<br /><br
/>Mark |
|
Re: Best
practice on cube development |
Ahh, the
perennial question ... one closely related to how long is a piece of string
€ and the lack of an answer is precisely what keeps many of us
employed. <br /><br />The motherhood replies are along the lines
of <br />[list]<br />[li]As small as you can get away
with[/li]<br />[li]As few as possible[/li]<br
/>[li]Ditto[/li]<br />[li]Yes, plenty[/li]<br />[/list]<br
/>respectively.<br /><br />I often find that a large part of
my job is simply to reduce the number of dimensions from what the users
initially believe is necessary. To some extent this need has been lessened
since attribute dimensions came along, but it still basically holds
true.<br /><br />The measurable elements we know improve
performance are:<br />[list]<br />[li]block sizes between 32k and
64k (max 128k) bytes[/li]<br />[li]€œhour glass€
dimension order from largest dense to smallest dense, smallest sparse to
largest sparse, then the flat sparse dimension like scenario, version, etc,
and finally the attribute dimensions[/li]<br />[li]Dynamic calc within
blocks and for all non level 0 members of dense dimensions[/li]<br
/>[li]As few as practicable cross dimensional calculations[/li]<br
/>[/list]<br />There are many more hints and clues but
you€™d be better served to ask more specific questions<br
/><br />But, it really does depend upon your businesses
requirements. Then the bigger task of performance tuning really is an art
€ and something for another time€<br /><br />It
you insist on some hard numbers (and no science) then ...<br
/>[list]<br />[li]keep the fully populated cube size below
100Mb[/li]<br />[li]"real" dimension to 4-6,
"flat" dimensions to 1-3, as many attribute as you
want[/li]<br />[li]accounts dimension to up to 500 pysical
members[/li]<br />[li]most other ("real") dimensions
to less that 100 members[/li]<br />[/list]<br />But I've
also had 50Gb cubes with 12 dimensions and 500,000 members in one of them!
You do what is necessary.<br /><br />And as mentioned elsewhere
... read the manuals because some of the content is actually quite good. And
consider other training or involving experienced help ... a little spent now
may save a lot in the future. Good luck. :)<br /><br
/>(There's a term for what I'm calling
"flat" dimensions - can't think of what it
is.)<br /> |
|
Re: Best
practice on cube development |
Good
stuff - it took me a long time to understand why a lot of those points are
important.<br /><br />One excellent resource I found early on was
IBM's Redbook on DB2 OLAP (DB2 OLAP is the IBM-branded version of
Essbase) at
[url]http://www.redbooks.ibm.com/abstracts/sg246138.html?Open[/url].
It covers a lot of the points Chris raised, plus it has some moderately
interesting examples and case studies.<br /><br />BTW, Chris: I
think the term you're looking for for "flat"
dimensions is "non-aggregating" -- that's what
it's called in the training anyway :) |
|
Re: Best
practice on cube development |
Granted,
this is just one caveat of an almost infinite list, but I found this
particular one to be often over looked, so I thought I'd use it to
make a point.<br /><br />An alternative view on the dynamic calc
statements above may apply in several situations (balancing disk size/calc
requirements along with retrieval, for one). Instead of (or in
addition to) making all dense dimension roll-ups D-C, you can focus on the
smallest dimensions (both sparse and dense). Typical (if there is
such a thing) calc requirements in large dense dimensions, coupled with typical
smallest sparse dimension layout, often makes it advantageous in terms of
both calc time and disk space. Then, depending on the largest dense
dimension, you might benefit some by keeping it stored. <br
/><br />To understand why this is so, you only need to picture a
relatively "ideal", but also somewhat typical, case:<br
/> - Dense Dimension 1: 900 Level 0, 90 Upper Level
members<br /> - Other dense dimensions<br />
- Sparse Dimension 1: 30 Level 0, 10 Upper Level members<br /><br
/>The increase in block size (discarding compression) for making the
switch is at most 10%, while the overall decrease in page file size (again,
discarding compression) is very nearly proportional (or about 25%) to the
reduction. The increase in page size also has much less impact on
calc time compared to the sparse reduction, making a similar reduction in
calc time (not 25%, but a fairly good proportion of it). On top of
this, the larger dimensions (dense especially) tend to have more complex
requirements and calculations tied to them (in particular to the upper level
members, or D-C candidates), in my experience, anyway.<br /><br
/>To summarize, there are no hard and fast rules, and I agree with
everything said so far -- the caveat above is only one of a very large number
of things learned through hard found experience, which is one good reason why
forums on Essbase (in particular) are so popular.<br /><br />Just
one side note, then I promise to shut up. I once had a database
that was optimized in such a way that optimum performance was obtained with a
layout that did [b]not[/b] follow the "hourglass" layout,
and to top it off, it had a block size well over 1 Meg. All
attempts to reduce the block size or reshape the cube caused a significant
reduction in performance. Don't read this as a violation
of the "optimum" block size guideline, only that once
again, there are really no hard and fast rules for all situations.
In the case of block size recommendations, however, the exceptions are very
rare indeed -- but they do exist.<br /> |
|
Excel
performance enhancement tips |
We have
been handed this task of optimising the performance of an Excel/Essbase
workbook that was built by a power-user from the finance dept (who has since
left - sound familiar?) and it's a beast. Multiple worksheets,
charts, links, links to links, macros, and calculations.<br /><br
/>Short of rebuilding it fom scratch, are there any performance enhancement
tips? (We run Excel2003) |
|
Re: Excel
performance enhancement tips |
HDN has
an article on optimising calculations:<br /><br
/>http://dev.hyperion.com/resource_library/tips_faqs/client_and_server_calculations/essbase_optimize.cfm |
|
Re: Excel
performance enhancement tips |
I have
always found charts reduce performance. If there was any way to quarantine
the presentation layer type stuff then it allows you to segment the core
processes. |
|
Planning/Essbase
on Unix/Solaris |
Does
anyone have Essbase running on Unix/Solaris?<br />We have managed to
get Essbase installed and running, but not successfully been able to create
applications. This will be the production environment for Essbase and
Planning databases.<br />Cameron suggested it could be a permissions
issue, but so far nothing has been proven despite multiple cheks.<br
/>TIA<br /> ??? |
|
Re:
Planning/Essbase on Unix/Solaris |
Its
working.<br />We needed to add a pile of variables, which unfortunately
were not requested!<br /><br />This was added over what had
defaulted:<br />ODBCINI=$HYPERION_HOME/common/ODBC/Merant/4.2/odbc.ini
<br />export ODBCINI <br />ESS_JVM_OPTION1=-Xusealtsigs <br
/>export ESS_JVM_OPTION1 <br />ESS_CSS_JVM_OPTION1=-Xusealtsigs
<br />export ESS_CSS_JVM_OPTION1 |
|
Re:
Planning/Essbase on Unix/Solaris |
Care to
share? It's an unusual configuration |
|
Re:
Planning/Essbase on Unix/Solaris |
Have you
checked the extra environment variables listed in $ARBORPATH/hyperionenv.doc
have been set, and that they point to the right locations? Has
$ARBORPATH/bin been added to the PATH variable for the user that runs the
ESSBASE executable?<br /><br />(ODBC is a whole other adventure,
but I don't think that ODBCINI value looks right -- you're
supposed to write your own odbc.ini to include the data sources you want to
have available to Essbase, and the supplied one is just an example.
It shouldn't stop the applications from starting though - you just
wont get any data sources listed in the rules file editor after choosing
"Open SQL".) |
|
Excel
Right Click Cell Menu |
please
find attached an xla (in the zip) that adds a right click cell menu to
excel.<br /><br />needs standard essbase add in and you need to
turn of right click in essbase/options.<br /><br />this is a cut
down version of a working xla I have which does far too much (specific to
clients) to post it all here ... but this is one of the more useful bits. If
there are problems please let me know.<br /><br />should work on
any V5 or later version of essbase.<br /><br />Chris |
|
Re: Excel
Right Click Cell Menu |
Thanks
for sharing. This should really help navigate Excel with Essbase. :D |
|
Re: Excel
Right Click Cell Menu |
It works
great but I do not see a big advantage in comparisment with the Essbase
toolbar button. Takes as many clicks as it does with the plug-in you made and
has almost the same options. I rather have a small toolbar at the bottom of
my excel workbook with some recognisable buttons. |
|
Re: Excel
Right Click Cell Menu |
Mate,
you're missing the point (and I'm trying not to take this
personally) <br /><br />1) If you can do the variety of drill
options in as many clicks be my guest; <br /><br />2)
I'm a big user of the right mouse button and, at least till v7, the
essbase addin wanted hold of the mouse too much for my liking<br
/><br />3) The code is open - modify it to be whatever you want it
to be - like I said this is cut down from the original. It could be used to
create a toolbar like you suggest rather than a menu - the code ain't
that different.<br /><br />Use, Change, Experiment and if you get
stuck or need help ... ask. :) |
|
Re: Excel
Right Click Cell Menu |
Crist,<br
/>this right menu is interesting option. Is it posible to have both
functionality - your right menu and Hyperion functionality?<br /><br
/>I would like to have your option on right mouse click, but for example
pressing Ctrl+right click it would enable Hyperion functionality - pivoting
and drill up.<br /><br />So my question: is it posible to have
both options?<br /><br />Thanks,<br />Grofaty |
|
Re: Excel
Right Click Cell Menu |
I
don't think so, no.<br /><br />The code is not capturing
the right click itself so much as changing the menu Excel dispays when it
captures a right click in a cell.<br /><br />And I'm not
sure if the right click action also passes a control key value, but I think
it would be vastly more difficult than what is here. <br /><br
/>But my code is not protected ... so if you solve it I'm sure
others would be interested.<br /><br /> ;) <br /> |
|
Outline
Comparison Tool |
This
creates an Excel workbook that shows detail changes between two
outlines. The outlines may be stored anywhere (locally or on any
server) to be compared, and it does a very thorough job of listing
changes. <br /><br />This is a
"somewhat" matured utility -- I would still like to add the
ability to skip specific checks (like comparing formulas, storage attributes,
etc.), and add the one "missing piece" to the comparison
(it only compares the default alias table, not the others). But I
could probably use some feedback before investing any time on this
tool.<br /><br />-Doug<br /> |
|
Re:
Outline Comparison Tool |
Seems to
have a problem with Attribute dimensions:<br /><br />A1234567
"Changed """" Attribute:<br
/>Old Value: ""Function F""<br
/>New Value: ""Company
C"""<br /><br />A1234567
"Changed """" Attribute:<br
/>Old Value: ""Region R""<br
/>New Value: ""Company
C"""<br /><br />A1234567
"Changed """" Attribute:<br
/>Old Value: ""Area A""<br />New
Value: ""Company C"""<br
/><br />A1234567 "Changed """"
Attribute:<br />Old Value: ""No
Line""<br />New Value: ""Company
C"""<br /><br />Each of these are
different Attribute dimensions (Function, Region, Area, Line, Company)
associated with the Organization dimension in my outline. |
|
Re:
Outline Comparison Tool |
I'll
check this one out tonight -- obviously it's missing the attribute
dimension name (in the empty quotes), so it's comparing each
attribute to the same one. I probably did something to it last
night when I tried to make it work with all alias tables (and got too tired
to finish, so I ended up commenting a lot of it out). <br
/><br />Anyway, thanks for the heads up.<br /> |
|
Re:
Outline Comparison Tool |
Thanks
for the quick response. Looks very nice and has already answered a question I
had on a particular database today.<br /><br />Do you make your
source available also? Not trying to compete with you, just trying to learn
more about api coding. No biggie if not, just checking. |
|
Re:
Outline Comparison Tool |
For a lot
of my code, I allow people to use it for their own purposes. This
isn't to prevent them from modifying it to their needs, but to keep
warring versions from existing through derivative releases. In other
words, don't let me catch blame for changes made by others, or let
others take credit from the original work done by me. Simply put: for
personal use only, and sharing is limited to your organization.<br
/><br />Some of my code I protect somewhat more. The outline
comparison "core" is one of these, as there is a whole lot
of effort that goes into some of the obscure aspects (for instance, recognizing
situations were a member was renamed by matching the alias up). It
looks simple in english, but the actual logic is anything but.<br
/><br />If you are looking for a simple comparison, you could easily
modify the code in the Outline Info Tool to do this. It's not
what I refer to as a "signature tool", so the code is open
(although the version available here is slightly dummied up for that purpose,
it has what you need to create an OtlComp "light").<br
/><br />I created another tool similar to this (OtlSync), which
replicates hierarchy changes from one outline to another. It uses
coded UDA's to allow exceptions for every imaginable
situation. This tool isn't quite ready for exposure to the
public yet, but I may upload it sometime down the road.<br /><br
/>Yet another "signature tool" is actually a built in
utility menu that operates like a DBA "swiss army knife" --
and it contains almost all of the stuff I've uploaded here, and
more. I'd like to make this available, but it needs a lot of
redevelopment for this to happen. Still, I tend to let people I trust
use it. Some of it's functions:<br /> -
Display Server/App statistics<br /> - Display Server
loading<br /> - Edit server substitution variables<br
/> - Display access statistics (from log file, broken down
and categorized)<br /> - Display calc statistics (similar
to above, different details/focus)<br /> - Display
database statistics (this is a summary of database settings)<br
/> - Display optimum calc cache size (simple calc from
outline)<br /> - Compare outlines (same as this
tool)<br /> - Create security dump (similar/more complete
than the security workbook)<br /> - Restore security dump
(uses output from above)<br /> ... and some misc. toggles
and such<br /><br />So although I wouldn't give you the
full source code to [color=Blue]otlcomp[/color], there are a lot of tools
I've done over the past 10 years that I don't mind people
getting the code for -- assuming you promise that it's for your own
use.<br /> |
|
Re:
Outline Comparison Tool |
Fully
understand. I have not pulled down the Outline Info tool yet, so did not know
code was visible. I am not so much looking for the internals of the comparison
logic; more interested in seeing examples of good Essbase api coding. I have
done a little myself (for example wrapped Essmaxl.dll for Python as I
don't care for Perl), and have seen some of the stuff from
Solutions, but always nice to learn from the work of others who have gone
deeper. |
|
Re:
Outline Comparison Tool |
I've
tried to replicate a situation similar to what you've reported, and
couldn't (it worked as expected on multiple attributes
defined).<br /><br />Is it possible this was a one time glitch
(some possible error that didn't get trapped, perhaps)?<br
/><br />Also, did you use outlines from client, server, or one of
each?<br /><br />Finally, which version are you using? (I
tested this on 5.1 and 6.2 so far).<br /><br />Thanks
again,<br /><br />-Doug<br />PS: I've confirmed
the code in the outline info tool is not locked. |
|
Re:
Outline Comparison Tool |
Server
outlines, Essbase 6.5 Patch 6 on Windows 2000. All of the Attribute
dimensions are Text attributes. They are the only Attribute dims in the
database and all are associated with the Organization dimensions. Seems to be
repeatable. |
|
Re:
Outline Comparison Tool |
Would it
be possible for you to send the outlines to me for
debugging/testing? <br /><br />My (anti-spam mangled)
email address is [color=Blue]dbliss (at) wide open west (dot)
com[/color].<br /><br />Just do the obvious -- remove the spaces
and replace the (at) and (dot).<br /> |
|
Re:
Outline Comparison Tool |
Doug,<br
/><br />Would it be possible to get some of those tools for use here
at my organization. I am not a consultant, just a squirrel trying to get a
nut.<br /><br /> :-*<br /><br />Thanks<br
/><br />Sal |
|
Re:
Outline Comparison Tool |
I
don't want to make this sound like a big deal -- but I'm
reluctant to send it to anyone I don't really know.
I've seen people get in trouble when their company finds out they
have "unsupported software" installed, and depending on the
company and software, it can become an issue. Most of these
utilities are well beneath the radar for all but the most uptight IT policies,
but the utility workbook by it's very nature is a bit more of a
problem.<br /><br />If you feel this isn't an issue for
you, send me an email (address is in another response above), let me know
where you plan on using it, what your role is (dba, analyst, developer...?),
and I'll send you a copy.<br /><br />Like I said,
it's not a big deal, just a little extra caution on this particular
tool.<br /> |
|
Re:
Outline Comparison Tool |
Hey
Doug,<br /><br />Does this utility work on v7.1.2
outlines? Does the ESSLANG setting matter?<br /><br
/>I'm having trouble getting to work trying to compare two client
based outlines. I run the exe, I input the path for the outlines,
click OK and nothing happens.<br /><br />Thanks, |
|
Re:
Outline Comparison Tool |
Thanks
for the heads up.<br /><br />I can't be positive that
it's not a version issue. I know that there are
differences in the OTL structure that cause problems with downward
compatibility, but my tests were done against outlines that were saved with a
V6.2 client against a V7 server (our clients can't migrate until all
servers are migrated).<br /><br />Since I'm stuck using
a V6 client API for the time being, I don't know when I'll
get the chance to migrate any of my utilities to V7. And, with EAS
available, I figured the benefit the tool provides is significantly reduced,
so I didn't pay much attention to the need to upgrade it.<br
/><br />Nonetheless, I'd like to discuss this with you in
more detail some time, I'll send you a note (although I'd
recommend you not make your email address quite so public, as spambots have
been known to scan this site).<br /> |
|
Re:
Outline Comparison Tool |
Not sure
if this the problem, but rumor has it that a lot of API programs are breaking
when moving to 7. I am still happily cranking along in 6.5.6 so cannot
confirm. |
|
Re:
Outline Comparison Tool |
[quote
author=garycris link=topic=27.msg136#msg136 date=1126189022]<br />Hey
Doug,<br /><br />Does this utility work on v7.1.2
outlines? Does the ESSLANG setting matter?<br /><br
/>I'm having trouble getting to work trying to compare two client
based outlines. I run the exe, I input the path for the outlines,
click OK and nothing happens.<br /><br />Thanks,<br
/>[/quote]<br /><br />I was thinking I had the same thing here
but it just took a minute or 5 to finish what it was doing. Now I have a
beautifull overview of my changes. The attributes are a mess, thats a shame,
but the rest I can check verry easily now. :) |
|
Linking
Spreadsheets in different Reports |
I have
one problem, maybe it is simple to solve:<br /><br />How can one
link all(!) dimensions of two spreadsheets in different reports?<br />I
want to give over all member selections of a spreadsheet in one report
to<br />a spreadsheet in another report.<br /><br
/>Environment: Hyperion Analyzer 7.2.1.1.03053<br /><br
/>Best regards and thanks in advance!<br />Michael |
|
Re:
Linking Spreadsheets in different Reports |
Not
positive on this one, but here's my best guess:<br /><br
/>Create a separate frame with the controls to do the member selections,
and link each of the existing reports' selections to those controls.
Changing one should then change all, no matter where it's changed --
in theory. If I'm way off on this one, forgive me, I
haven't worked with Analyzer in a long time (I'm more of an
API/utility kind of guy).<br /> |
|
Re:
Linking Spreadsheets in different Reports |
This does
also not work, objects of different reports are independent
:(.<br />I also spoke with someone from Hyperion, it is not possible to
pass the<br />dimension selections of one whole spreadsheet (rows,
columns, filters, pages)<br />over to another spreadsheet in a
different report. This is already an <br />enhancement request.<br
/><br />Thank you for your help, especially for the very quick
response! :D<br /><br />Kind regards<br
/>Michael<br /> |
|
Error 429
- ActiveX component can't create object |
Hello,<br
/><br />after successfully configuring Hyperion Business Rules
(available in EAS), I get the Error Message "Error 429 - ActiveX
component can't create object" when I try to open the
business rules graphical designer.<br /><br />Please help me
out!<br /><br />Best regards and thanks in advance!<br
/>Michael |
|
Re: Error
429 - ActiveX component can't create object |
This is
an indication that you are misssing a component that is expected.<br
/><br />So either the install didn't quite go to plan (not
unusual), or some common (Microsoft, most likely) component is expected to be
present.<br /><br />Try reinstalling. I assume you rebooted after
the install?<br /><br />Sorry, can't be more help than
that...<br /><br />Chris |
|
Re: Error
429 - ActiveX component can't create object |
Since
I'm not familiar with HBR, I can't help on the specifics
for installing/configuring, but I can confirm that error 429 is a very common
automation error associated with a missing or misconfigured ocx/dll
somewhere. Is it possible you did the install without full admin
rights?<br /><br />There are other reasons why an ActiveX
component would fail to be created, and manual fixes for ocx/dll issues, but
it's probably better to uninstall/re-install HBR (ensuring admin
rights, etc.).<br /> |
|
Re: Error
429 - ActiveX component can't create object |
Thank you
both for the quick help. :)<br /><br />I will reinstall
HBR this weekend on my<br />local server image and report on
installation.<br /><br />Kind regards<br />Michael |
|
Re: Error
429 - ActiveX component can't create object |
[quote
author=michaelmasa link=topic=29.msg68#msg68 date=1124967123]<br
/>Hello,<br /><br />after successfully configuring Hyperion
Business Rules (available in EAS), I get the Error Message "Error
429 - ActiveX component can't create object" when I try to
open the business rules graphical designer.<br /><br />Please
help me out!<br /><br />Best regards and thanks in advance!<br
/>Michael <br />[/quote]<br /><br /><br />Make
sure you have the Essbase Runtime client installed... You need it
to use HBR.<br /><br />Eric |
|
Re: Error
429 - ActiveX component can't create object |
We had
the same problem. Tried to reinstall and it worked
;D<br /><br /> |
|
Re: Error
429 - ActiveX component can't create object |
Make sure
you have the MSJVM (it comes with the Planning install) installed.
Reboot and then reinstall Business Rules. This should fix it.. |
|
Word Wrap |
Have a
long alias name as a column - is there a way to wrap the column name?
Reports is trying to put it as one string across, need to it to wrap based on
the size of the column.<br /><br />Any help is appreciated |
|
Re: Word
Wrap |
Hi
There,<br /><br />Just wondering which version your running
with? We're using Ver7 and it seems to wrap
automatically. Just tested it, can't see any setting to
switch in on/off.<br /><br />In the HTML view our column headers
do not wrap, but they do in the PDF view. The Row headers
wrap.<br /><br />Bit confusing why there's a difference
between the HTML & PDf views.<br /><br />Not too sure
whether this has helped, but if you find anything let us know - ta.<br
/><br />Mark |
|
Re: Word
Wrap |
Thanks!
We're on 7.0.1. In PDF, it cuts the name to the length of
the column. In HTML no wrapping but it autofits to the
name. <br /><br />Weird... If I find out
anything, I'll let you know.. |
|
Use of
@SUBSTRING |
I've
had an "interesting" >:( experience with the use of
@SUBSTRING function in a member formula.<br /><br />Essbase
7.1.3<br />9 dimensions, only two valid for this demonstration<br
/><br />For the purposes of this item the entity dimension may be
considered of fixed levels, and repetitive in nature.<br />Basically it
is made up of Branches at Gen6/Lev1 and Plants at Gen7/Lev0, and of
conveniently named members where various characters mean something, it looks
like the following:<br /><br />....<br />|-2201 <br
/> |-220101<br /> |-220102<br /> |-220122<br
/> |-2201I <br />|-2204 <br /> |-220401<br />
|-220410<br /> |-220423<br /> |-2204I <br
/><br />Note that each branch (the 4 character members) has an input
child member.<br /><br />Okay ... here's the fun I had
... there is an account (Tonnes) that exists in the input member of each branch,
and needs to be referenced from the plants members (i.e. from 220101, ... ,
220423 above). I created a member formula on a dynamic calc account that went
like:<br /><br />IF( @ISGEN( "Entity", 7 )
)<br /> "Input Tonnes" = "Tonnes"->@MEMBER(@CONCATENATE(@SUBSTRING(@NAME(@CURRMBR("Entity")),
0, 3 ), "I" ) );<br />ENDIF;<br /><br
/>In member 220101 this should translate to <br />
"Input Tonnes" =
"Tonnes"->2201I<br />In member 2201I this
should translate to <br /> "Input Tonnes" =
"Tonnes"->2201I (it is [i]not[/i] an issue that this
is self referential)<br />In member 220423 this should translate to
<br /> "Input Tonnes" =
"Tonnes"->2204I<br />and so all is well in the
world ...<br /><br />IT DIDN'T. ???<br
/><br />Working through this I was able to isolate the @SUBSTRING as
the culprit. Has anyone else struck issues with this function? <br
/><br />[I was able to achieve my result by using the following:
;)<br /> "Input Tonnes" =
"Tonnes"->@MEMBER(@CONCATENATE(@NAME(@ANCEST("Entity",6)
), "I" ) );<br />but somehow I don't
consider it quite as elegant a solution]<br /><br /><br /> |
|
Re: Use
of @SUBSTRING |
I believe
the issue may lie with your "end position" parameter
(3). It should be "4".<br /><br />The
docs state this in a somewhat confusing manner, as it says "The
first position past the last character to be included in the
substring", so if you want chars 0-3, you put in 4.<br
/><br />As is, you were getting results like
"220I" instead of "2204I".<br
/><br />Hope this helps.<br />-Doug<br /> |
|
Re: Use
of @SUBSTRING |
[quote
author=DougWare link=topic=31.msg83#msg83 date=1125024309]<br />As is,
you were getting results like "220I" instead of
"2204I".<br />[/quote]<br /><br />Of
course -- I'm working with Chris and just came across the same point
about the third argument, but we couldn't figure out why that
wasn't causing the calculation to abort. Your reply made
it click: in this database both "220I" and
"2204I" happen to be valid member names, so there was no
error message reported.<br /><br />The example in the 7.1.3 docs
therefore has an error. It shows this:<br /><br
/>[code]@SUBSTRING ("200-21",0,2)
"200"[/code]<br /><br />But should read:<br
/><br />[code]@SUBSTRING ("200-21",0,2)
"20"[/code]<br /> |
|
Re: Use
of @SUBSTRING |
Thanks.
It works now. <br /><br />Guess painful experience should have
told me the documented samples were wrong ... but one does live in hope!
<br /><br /> ;)<br /><br
/>"Normally" Essbase spits the dummy if you reference a
member that doesn't exist which is why I was fooled into thinking I
was right! And in [b]this[/b] structure member "220I"
[i]does [/i] exist! Which I stupidly neglected to consider... |
|
Re: Use
of @SUBSTRING |
I've
submitted it as a documentation bug to Hyperion support. |
|
Re: Use
of @SUBSTRING |
Topic
solved? Chris, you should be able to see a 'tick' symbol -
which you can allocate to dougware's post.<br /><br
/>Cheers |
|
Re: Use
of @SUBSTRING |
I've
learned to pretty much ignore document samples for such reasons -- like many
examples, it was more confusing than helpful.<br /><br />The
other aspect of this is [i]why[/i] do they use such a strange parameter in
the first place. Every programming language I know of would use
either a length or an inclusive end position (usually the former).
It almost seems like they go out of their way to add confusion.<br
/><br />Gotta take the bad with the good I suppose.<br /> |
|
Re: Use
of @SUBSTRING |
For what
it's worth, Java's String.substring() function has the same
strange arguments, which is probably the only reason why I didn't
immediately think the documentation contained a typo. |
|
Spam bots |
Just a
quick note to warn all users re posting email addresses and having your email
addresses in your signature: there have been a couple of nasty spam bots that
have trawled through this forum (from what I can tell from the server log).
These things harvest email addresses for the purposes of spamming and other
undesirable practices. Whilst you are free to do so, you may wish to
reconsider email disclosure.<br /><br />Cheers |
|
Workspace
Availability |
Has
anyone been able to resolve this:<br />Workspaces marked as private are
available to the user who saves them.<br />However, this is case
sensitive. ie if logged on as joe, any workspace is visible, but, if logging
on as JOE (a valid account and accepted by HFM), the Workspace is denied to
the user.<br />However, if linked to by Favorites, they are visible
under any combination. ie, joe; JOE; Joe; etc....<br /><br
/>Useful to know for any user calling re missing Workspaces. We are on
v4.0.1sp2, but the same exists in v3.5 as well |
|
Re:
Workspace Availability |
We have
had to train our users to use all lower case. Why you
ask? We have implemented single-sign-on from HFM to
reports. And reports is case sensitive, so if they don't
want to log in again, they have to use all lower case. All the
id's are created lower case in both HFM and Reports.<br
/><br />This doesn't solve the defect but it might be a
workaround. |
|
Re:
Workspace Availability |
Thanks
Aleck, Yes, we did the same, but users being users, and unintentionally, they
use variations. Not something we can control, and also has the impact as you
mention with Reports.<br />I will post any response I get from Support. |
|
RSS feed |
Hi,<br
/><br />Firstly congratulation for the forum, wishing it a long
life.<br />Concerning the feature that could be implemented is an RSS
feed for each technology and utilities/freewares.<br /><br />Best
regards,<br /><br />SR - PCF |
|
Re: RSS
feed |
I'm
not sure if this has been advertised, but this forum software does happen to
provide RSS feeds:<br /><br />For example:<br
/>[url]http://hyped.biz/community/index.php?action=.xml;type=rss[/url]<br
/><br />To check just one board, like the Essbase board, check the
number that appears in the URL when you enter that board, for example:<br
/>[url]http://hyped.biz/community/index.php?board=19;action=.xml;type=rss[/url]<br
/><br />Sorry if I'm preempting anyone - I was playing with
various different forums a while back and most work that way :) |
|
Re: RSS
feed |
Great
stuff! |
|
Re: RSS
feed |
Unfortunately
it looks like this has stopped working - there's now only one entry
in the feed:<br /><br />[code]Re: Clustering question<br
/>http://hyped.biz/community/index.php?topic=163.msg532#msg532[/code]<br
/><br />Any idea why? Could it be because of the new
requirement to log on to view forums? |
|
Re: RSS
feed |
[quote
author=Ben White link=topic=34.msg553#msg553 date=1136964038]<br />Any
idea why? Could it be because of the new requirement to log on to
view forums?<br />[/quote]<br /><br />Answering my own
question :) I did some digging and yep, that's
it. If you use Live Bookmarks in Firefox it works (as long as
you're logged on to HYPEd.biz so that Firefox's logon
cookie gets used), and if your RSS reader can use cookies it still works
too.<br /> |
|
Re: RSS
feed |
Sorry Ben
- I think you're right. My little bit of digging also came to the
same conclusion. Will see if they have a mod that might fix it up for
us.<br /><br />Cheers (and HNY!)<br />Jon |
|
Re: RSS
feed |
(HNY to
you too!)<br /><br />Might be hard to fix though -- if
you're requiring a logon to view posts, then providing a RSS feed
anonymously would be a bit of a security hole.<br /><br />Any
reason why logons are required now, btw? |
|
Best
Practice €“ Updating between Environments in Planning |
Here's
the Scenario:<br />Planning Application that has a Dev and Test environment
on one server and one Essbase server, and a Prod environment on another
server with a separate Essbase server.<br /><br />So what is the
best practice in updating Planning and Essbase between Dev to Test, Test to
Prod (not to mention the occasional Prod to Dev)?<br /><br />The
somewhat clunky method of backing up (relational) database and restoring over
new environment, "refreshing" Essbase, and modifying
planning security tables is, well, it's kind of unprofessional.<br
/><br />Anyone got anything better?<br /> |
|
Re: Best
Practice €“ Updating between Environments in Planning |
Chris:<br
/><br />In the "clunky" method, are you performing
a true Migration of the Essbase database from within EAS? <br
/><br />Assuming the domain name and users are the same for both
servers, the Migration of the Essbase App and the restore of RDBMS is
actually pretty straightforward.<br /><br />If you are moving
between Domains, its a much different story. In this case, I have used Remote
Authentication Module to assist in moving apps between our servers and our
clients servers. Since RAM allows you to search LDAP for 2 domains,
you can have user chris@ourdomain.com and user
chris@clientsdomain.com both setup in Essbase/Planning Security.
This allows you to log on from both domains and/or move the app between
domains (using migration in EAS). |
|
HFM
Clustering and Connections |
HFM with
two servers one cluster. Have noticed that when we open an app, can
see where it starts the HSVdat.exe on both servers, can see the connections
into the repository, but when we log off, those HSVdat's do not go
away. However, we have another HFM server, no clustering, when we
open an app, can see where it starts the HSVdat.exe, can see the connections
into the repository, when we log off, those HSVdat's do go away and
so do the connections. <br /><br />Is anyone else
seeing anything similar? |
|
Re: HFM
Clustering and Connections |
Aleck,<br
/> The first time i have to
open the App is to register the cluster (Server Name) and then it shows the
App. The first time you open the App it asks to save it a folder or
workspace.... i made a new folder under c:/hyperion/hfm/folder name. I have
not come across such a problem..... about the cluster as you have mentioned.
<br /><br /><br />Thanks,<br />Hypercube |
|
User
Alias tables |
Currently
it is not possible for users to dynamically change the display of aliases or
member names in webforms.<br /><br />Currently it is [b]not [/b]
possible for users to dynamically change the display of aliases or member
names in webforms.<br /><br />Also, is it possible for an
Administrator in Planning to apply different aliases for the same dimensions
on a form by form basis. ie. 2 forms, both have same dimensions, but the
administrator can set a different alias in each form?<br /><br
/>This is on Planning v4.0.1<br /><br />TIA |
|
Re: User
Alias tables |
If I
understand the question correctly, the answer is no. Aliases are
set under user preferences. The admin can designate which alias table
is the application default (not necessarily the default alias table) Then
users can go into preferences and choose to use the application default or
another alias table. Either way this is set at a high level and
cannot be modified on a per form basis.<br /><br />HTH |
|
Atlanata
Users Group Meeting |
The next
Atlanta HUG will be at Mirant - 1155 Perimeter Center West, Atlanta Georgia
30338 |
|
Re:
Atlanata Users Group Meeting |
I am
interested to hear people's experiences with user groups. I think
they are an excellent idea but have never attended myself.<br /><br
/>Are they of any benefit? |
|
Re:
Atlanata Users Group Meeting |
I think
so. We have a "no Hyperion fluff rule" which
works out well. Also, it's a great way to network. |
|
Re:
Atlanata Users Group Meeting |
Up here
in Michigan, HUG-MI (catchy name, no?) does tend to lean towards the fluff a
bit, but this is easily overlooked when you consider the [i]networking[/i]
and [i]staying current on new products[/i] aspects.<br /> |
|
Re:
Atlanata Users Group Meeting |
Aleck,<br
/> Please let me know when this
meeting will be in Atlanta. You didn't mention the date ?<br
/><br />Thanks,<br />Hypercube |
|
Re:
Atlanata Users Group Meeting |
It's
Wednesday, November 16th from 12-4, outside of Atlanta in the Mirant office
building. The address is 1155 Perimeter Center West, Atlanta GA
30338.<br /><br />HTH! |
|
NEW
DATE: Atlanata Users Group Meeting |
The
Atlanta user group meeting has been moved to December 14th. Same
place different date! |
|
Deleted
report still visible in view pane |
Hello,<br
/><br />again one problem which sound to be solved simply:<br
/><br />I have deleted one Analyzer report, but it is still
visible<br />in the view pane. How can I remove it from there?<br
/>"Delete" doesn't work.<br /><br
/>Thank for help in advance!<br /><br />Best regards <br
/>Michael |
|
Project
Avalanche |
Anyone
got any gossip on Hyperion's Project Avalanche and likely release
dates? |
|
Re:
Project Avalanche |
The beta
is supposed to start this week. We're participating in
it. Will keep you in the loop as more info becomes available. |
|
Re:
Project Avalanche |
Any news
would be great - there's been much hype (no pun intended) at our
work for a while around this new single platform approach. |
|
Re:
Project Avalanche |
That's
the old name! it is now being marketed as 'System 9', the
initial release is due for the end of September (the 4.1 release) -
I'll try to get an exact date. onceptually, the direction is right,
and this is aligning the BI tools and App suite, by beginning the process of
reducing the number of moving parts, single point of access, unified install,
security module etc...<br /><br />There is a lot of marketing
started, don't be surprised if your accoutt manager calls:) and the
Solutions conventions will be doing demo's etc. The first being
Barcelona 6 - 8 November.<br /><br />It is going to be an
interesting upgrade for those of us already on the treadmill!! |
|
Re:
Project Avalanche |
We had a
brief into to system 9, and have a demo/sales pitch coming, but I
wasn't sure it was the same thing (never heard of it as
"Avalance" before).<br /><br />My understanding
is that it's more of a marketing package than a technical
enhancement. Obviously, changes were made to bring the components
into a single framework, and that by itself is worthy of interest.
Beyond this, I would only HOPE that they haven't tried to make too
many changes to the underlying technologies themselves.<br /><br
/> |
|
Re:
Project Avalanche |
The BI
market is certainly heating up. I was given a demo on the beta for SQL Server
2005 - which is tipped for release in Nov. Very impressive. They have
certainly moved towards, not only integrating the ETL/DW/BI functions, but
also wrapped in up in a BI development studio - so it's like having
one IDE to do it all. All this prepackaged with SQL server.<br /><br
/>It will be interesting to see how Hyperion, COGNOS and BO (as the
heavyweights) respond. |
|
System 9 |
System 9
will combine Hypeiron Reports, Analyzer and PM into one reporting
solution. Hyperion also introduced in Hyperion Shared Services (HSS
- which is the old HUB) user provisioning. The concept is you
register all your products with HSS and all your users are maintained in
HSS. So, for reporting - System 9, you would pick your users out of
HSS. Nice feature. Also, you can have multiple grids with
different data sources in the same report. <br /><br
/>Spoke with our sales rep yesterday - there is going to be a
"migration cost" associated with it but was not able to
give me a quote. Also, this is considered a new product and will be
priced accordingly. |
|
Lock
Manager errors |
I have a
user that reports the following error:<br />"1014028
Transaction transactionHandle is waiting for transaction
transactionHandle"<br /><br />I searched HDN:<br
/><br />[i]"Possible Problems<br />Essbase cannot
complete the transaction because the current transaction is waiting for a deadlocked
transaction. <br /><br />Possible Solutions<br /><br
/>Make sure that two users are not performing calculations on the same
blocks at the same time. <br />If this error happens frequently, have
spreadsheet users clear the Update Mode check box in the Mode tab of the
Essbase Options dialog box. See the Essbase Spreadsheet Add-in
User's Guide for more information."[/i]<br /><br
/><br />I have cleared the check box as suggested and re-tested when
there were no other users but no luck.<br /><br />I was wondering
if anyone had experienced anything similar OR have any suggestions.<br
/><br />Thank you!<br /> |
|
Re: Lock
Manager errors |
Might be
a silly question but did you check the database locks before re-testing,
Essbase may have not released the lock when you tried again.<br
/><br />Regards<br />David |
|
Re: Lock
Manager errors |
The
obvious (which hasn't been explicitly said yet): To resolve the
deadlock, abort any stalled calculation processes. Then you can
recalc (one at a time, please).<br /><br />The less obvious: If
users are running calcs against the database, it's usually a good
idea to ensure that these calcs do not overlap (in terms of at least one
sparse dimension). This will ensure they don't go into
deadlock. When this isn't feasible, you might try setting
up a server side process that they can queue the calcs against, or set up
some kind of calc schedule instead of letting them run them at any
time. In the long run, the effort needed to do this is likely to be
recovered in troubleshooting/repair time and database availability.
If the app isn't mission critical, then present the data owner with
the options and let them live with their decision.<br /> |
|
Analysis
Tools Manager |
Hi
all,<br /><br />I have a typical problem with Analyzer 7.2.
<br /><br />Whenever i click on Analysis Tools Manager it hangs
up and never comes back up. Did any one have this kind of
problem.<br /><br />I know 7.2 latest version is with lot of bugs
but, is thre any particular reason causing that?<br /><br />Any
suggestions in this regard will be a great help<br /><br />Thanks
in advance :( |
|
Calling
Report Script using MAXL |
Hi
There,<br /><br />Just created what appears to be some simple
MAXL code to run a Report Script and export to a file. It all runs
successfully, but I can't find the export file. Bit
frustrating! Anyway here's the code:<br /><br
/> [color=Blue]login
'hypeadmin' 'hyp3admin' on
'stacshyperep01';<br /><br />
alter application 'ManAcs' load database
'MAv10';<br /> export
database 'ManAcs'.'MAv10' using server
report_file "Act04" to data_file
"c:\\MYFILE.txt";<br /><br />
logout;[/color]<br /><br />Thanks in advance<br
/><br />Mark<br /><br />PS I like this site |
|
Re:
Calling Report Script using MAXL |
Not sure
if this is the situation you are in, but this might help. When you
run MaxL scripts, it runs from the perspective of the Essbase server, not the
client you are working from. So in your case, if you are running
this script from a client machine and looking for the export on the C: root
of the client machine, the export is not going to be there.
Instead, login to the Essbase server and look for the export file off the C:
root of the server.<br /><br />Hope that helps. |
|
Re:
Calling Report Script using MAXL |
Hi
Gary,<br /><br />Sorry about the slow reply, done some digging
and still couldn't find the file - frustrating. I think this
is because I don't have write access to the server, which is strange
because some of the other EAS functionality lets me write to it.<br
/><br />Tried pointing the extract to another location using some of
the syntax in the examples, but still no joy. When I get back to work
with a clear head I'll keep it another go. On holiday at the
moment - this Essbase thing - strangely addictive!<br /><br
/>Thanks<br /><br />Mark |
|
Re:
Calling Report Script using MAXL |
Are you
getting output messages scrolling up the screen at all?<br /><br
/>When you use the export statement with a report script using essmsh.exe
or the API, the filename you specify is on the local machine (as opposed to
calling it without a report script, where the file ends up relative to the
server's essbase\app directory), so you [i]should[/i] find the
output in your c:\ directory, assuming there are no strange file permissions
problems.<br /><br />On the other hand, if you're
running it on Essbase Admin Services, EAS temporarily saves the output of the
report on the server somewhere (somewhere like eas\server\client) before
copying it to where you specified in the MaxL statement.
I've had problems in the past when for some reason EAS
hasn't had permission to write to that temporary directory, but from
memory it did at least give a useful error message. |
|
Re:
Calling Report Script using MAXL |
Hi
Ben,<br /><br />Yep, I get the success messages scroll at the
bottom. I'll check the rest of your suggestions when I get
back next week. It'll give somewhere else too look and
fingers X'd I might find the missing file.<br /><br
/>Ta<br /><br />Mark |
|
Re:
Calling Report Script using MAXL |
Hi
Ben,<br /><br />Finally got round to your suggestion and ran it
using ESSMSH and the file exported to where I expected - great!<br
/><br />Just wondering, how did you manage to change permissions in
EAS so that the MAXL script can be run from the Server?<br /><br />Many
Thanks<br /><br />Mark |
|
Re:
Calling Report Script using MAXL |
In my
case it was trying to create a temporary directory on the server (as
eas\server\client\temp or some-such), but it wasn't able to write to
the parent directory. I created the temp directory as an
administrator on the box itself and everything started working.
There was a reasonable error message in the EAS console at least, however. |
|
Essbase
Log Reconciler |
PLEASE
SEE BELOW FOR VERSION 1.6<br /><br />[u]Essbase Log
Reconciler[/u] is a compiled PERL script which reconciles or reformats
selected Essbase logs. <br />My objective was to generate a clean log
file in order to open it in a spreadsheet for filtering or to insert it in a
relational DB for further analysis.<br /><br />By Essbase logs I
understand any Essbase log format, such as classic Essbase logs (v.5 to v.7)
or advanced Essbase logs (~^*&: delimiters as defined by DELIMITEDMSG
in Essbase.cfg).<br /><br />[u]How to use:[/u]<br />1. Copy
and unzip to any directory<br />2. Execute EssLR_v1.exe<br />3.
Drag & drop Essbase .log file to reconcile or manually input Essbase
.log full path (ie. x:\...\app\demo.log) and then [ENTER]<br />4.
Output is generated in EssLR_v1.exe current directory<br /><br
/>[u]Performances:[/u]<br />On my laptop it takes less than 7 seconds
for a 20 MB log file.<br /><br />[u]Note/Disclaimer:[/u] <br
/>Even if stable and tested, use at your own risk!<br />You will be
solely responsible for any damage to your computer system or loss of data
that results from the download or use of the following script.<br
/><br />If feedbacks, requests, comments or questions please feel
free to reply!<br /><br />PLEASE SEE BELOW FOR VERSION 1.6<br
/><br />Sébastien Roux<br
/>_______________________________<br />Partake Consulting
France<br />49, avenue Hoche <br />75008 Paris - France<br
/>E-mail: |
|
Re:
Essbase Log Reconciler |
Thanks
for contributing -- the more the merrier! :)<br /><br
/>Does it do anything besides convert the format?<br /> |
|
Re:
Essbase Log Reconciler |
Not at
the moment! I wanted something really quick when you have to audit/analyse
logs bigger than 100 mb.<br /><br />2 points I'm
thinking in:<br />- generate stats about the selected log<br />-
insert data directly in a specific DB<br /><br />However do not
hesitate to give ideas!<br /><br />Regards,<br /><br
/>Sroux |
|
Re:
Essbase Log Reconciler |
Excellent
Utility! Very useful!<br /><br />Thanks for
posting.<br /><br /><br /> |
|
Essbase
Log Reconciler 1.6 |
Dear
all,<br /><br />Here's a new release of Essbase Logs
Reconciler a.k.a EssLR (please refer to the first post for further
description).<br /><br />The script is coming back with
improvements and some few minor fixes.<br /><br />Release
notes:<br />-------------------<br /><br />version 1.6 -
20/11/2005<br /><br />- Corrected - filtering mechanism when a
description only appears in log files<br />- Added - Replacing
multi-space by single space<br />- Added - Deleting tab<br />-
Added - Deleting eol tab/space<br />- Added - Message type/category
column, as specified in Hyperion Essbase error messages <br
/>documentation with the following categories:<br />
<br /> Error code Message type/category<br />
---------------------------------------------<br /> 1003000 to 1003040
Data Load<br /> 1006002 to 1006051 Data Cache<br /> 1008001 to
1008152 System Call<br /> 1012000 to 1012750 Calculation<br />
1052001 to 1054030 Agent<br /> 1014004 to 1014043 Lock Manager<br
/> 1019002 to 1019054 Database Objects<br /> 1040002 to 1042025
Network<br /> 1120000 to 1120002 Grid API<br /> 1130203 to
1130613 Miscellaneous<br /> else Other<br /><br />Usage:
EssLr_v1.6.exe switch inputfile outputfile<br /> -h specify headers<br /> -n specify no headers<br />No more drag
and drop!! Please refer to ReadMe.txt for further explanations.<br
/><br />And remember even if stable and tested, use at your own
risk!<br />You will be solely responsible for any damage to your
computer system or loss of data that results from the download or use of the
following script.<br /><br />If feedbacks, requests, comments or
questions please feel free to reply!<br />I am looking for a way to
obuscate pl script source in order to post EssLR.pl for Unix - thanks for
helping me!<br /><br />For information, I'm using the current
script (.pl) on my customer's Unix AIX environment, once the logs
are reconciled (really quick) I load them in Oracle with sqlldr command and I
analyze them in a web frontend (dynaSight).<br /><br />Sébastien
Roux<br />_______________________________<br />Partake Consulting
France<br />49, avenue Hoche<br />75008 Paris - France<br
/>E-mail: |
|
Metro NY
- Hyperion User Group Meeting |
The next
meeting for the Metro NY HUG is on September 15, 2005.<br /><br />Please
visit [url=http://www.metronyhug.com]www.metronyhug.com[/url] and register
for the meeting if you are interested in attending.<br /><br
/><br />Best Regards, |
|
http
spreasdheet addin / deployment services |
We have a
full http environment - ie, no users able to connect to the server domain, as
all connection is intranet. This has us snookered in direct access to the
Essbase Sreadsheet Add-in.<br /><br />I am informed that Hyperion
Deployment Services with Essbase Spreadsheet Service is the way out of
it.<br /><br />Anyone got any experience with this?<br
/><br />Noel |
|
Re: http
spreasdheet addin / deployment services |
I used it
in test environment, never in production. It works pretty
nicely. Basically it's the same as the regular addin,
except it allows you to connect to a server via http.<br /><br
/>Another option is Analyzer, which is web based... |
|
Essbase
Integration Services |
hi
friends,<br /><br />We are implementing EIS and i am very
clueless where to begin with. we have all the required softwares installed.
can anybody please suggest me where to begin ?? i have gone through the PDFs
for EIS. but am still a little confused. <br /><br />Simply
Stupid. |
|
Re:
Essbase Integration Services |
I have
the same problem with you ,and i am going through the demos . |
|
Re:
Essbase Integration Services |
Sorry I
can't help much on this, but did want to point out that Hyperion has
a three day course specifically for EIS.<br /><br
/>Here's the course description if you are interested.<br
/><br />Abstract: <br />This course uses Hyperion
Essbase version 7.0. All course exercises and demonstrations use the Essbase
Administration Services interface. In this course you learn to convert
relational data into multidimensional data by using Essbase Integration
Services. You also learn the principal techniques for data denormalization
and for the creation of online analytic processing (OLAP) models. You create
fact tables and complete OLAP models from an existing relational store. The
course describes the creation of multidimensional database outlines and data
loading by using Essbase Integration Services. You also learn to enable
hybrid analysis reporting functionality. Upon completion of the course, you
should be able to explain the relationship between data warehouses and OLAP
systems and be ready to implement techniques that leverage data warehouse and
data mart investments into an OLAP solution. The course provides extensive
exercises to reinforce the covered topics. <br /> <br />HTH |
|
Re:
Essbase Integration Services |
i just
read help information,practice with demos |
|
Formatted
Excel Export |
Hello
there,<br /><br />three problems, dealing with the excel export
of spreadsheets:<br /><br />- I have defined various formats in a
spreadsheet (bold, percentage sign, etc.) <br /> But when I
choose the formatted Excel export, the Analyzer exports the data<br
/> like it is stored in the database. I know that a complete
formatted export is<br /> possible! Do I have to change some
settings elsewhere?<br /><br />- We have users in Germany and in
USA. The export for the users in USA works<br /> fine, they
get the data like it is stored in the database. But the german Users<br
/> have to switch the decimal separator and the separator for
the thousands in<br /> the Excel options although the
Analyzer is the german version. How can I avoid this?<br /><br
/>- When I define formatting settings e.g. for the measures when I
establish the <br /> database connection, no formatted export
is possible! What could be the cause<br /> for this?<br
/><br />Thanks for help in advance!<br /><br
/>Michael<br /> |
|
Shooting
in the dark (Network Connection dropping Issue) |
Network
Error [10061]: Unable To Connect To [MHC007M:1423]. The client
timed out waiting to connect to the Essbase Agent using TCP/IP.
Check your network connections. Also please make sure that Server and Port
values are correct<br /><br />sts = 1042006 CalcObject = CalcAll<br
/><br />Command Failed. Return Status = 1042006<br /><br
/><br /><br /><br /><br />Essbase 7.1.3, Windows
2000 server.<br /><br />Esscmd scheduled script. Reset
db, reload db, recalc db. During the calc it looses its TCP/IP
connection. For less than a minute. Than it is fine
again.<br /><br />Every couple of weeks this seems to
happen. However always almost at exactly the same time (1:00
am).<br /><br />Then the problem goes away for a couple of
weeks. Only to magically return when I become complacent.<br
/><br />Since it seems to be happening on such a regular basis, I
assumed that it was related to the network/box/hardware or some IT scheduled
process. However my IT department states that there is nothing going on from
their side.<br /><br />This is currently the only app on this
particular essbase box. A
planning app.<br /><br />Could it be related to the size of the
log file. I have noticed that the log file on my planning app grows
rapidly in size. When this
problem occurs I have been clearing my log file for the app (soley because I
have on those occasions noticed the size of it.) Could the large
size of the file (130 meg +) be causing the delay in
communication?<br /><br />Any other ideas. <br /><br
/>I think I understand that the Esscmd Client communicates with the
Essbase Server Agent via TCP/IP even though they are both on the same
box. (the esscmd is being run from the same box that the Essbase
server is running on.) That
it is this communication that is becoming messed up for some reason. |
|
Re:
Shooting in the dark (Network Connection dropping Issue) |
I
don't think that the problem is related to the log file; I had the
same problem in an application after a long incbuilddim and i solved the
problem stopping the application after the data load and restarting before to
run calculation.<br /><br />Stefano |
|
Re:
Shooting in the dark (Network Connection dropping Issue) |
This
problem is tricky because it can be caused by multiple factors all acting at
the same time.<br /><br />Check these..<br /><br />Is
Hyperthreading enabled on the server? If so, try disabling it in BIOS
and see if the problem goes away.<br /><br />Also, compare the
dimensions in the Essbase Outline to the Dimensions in the Planning
Dimensions Editor to ensure that 1) the dimensions are in the same
order and 2) that the members in the dimensions are in the same order.
The order of dimensions and/or members has been known to change
during a refresh.<br /><br />Assuming that they are OK, be sure
that the Outlines for all PlanTypes are each correctly optimized (must
optimize from within planning, not Essbase), and that your Index Cache,
Data/DataFile Caches are correctly optimized<br /><br />Finally,
you may want to play around with NETDELAY and NETRETRYCOUNT, although they
usually dont make that much of a difference.<br /><br />Hope that
helps.<br /><br />C. Logan<br />InterTech Solutions<br
/>clogan@intertech-solutions.com |
|
Programmatically
creating reports from Essbase cubes -- need options |
I need to
automatically create a set of reports from data stored in essbase cubes. I
have manually created those reports using the Excel plugin. I would
like to automate the reports. I have a couple of questions and am
also looking for options/suggestions. <br /><br />My
questions:<br /><br />1. Can saved queries/reports created from
the plug-in be called programmatically from visual basic or do I need to use
the standard visual basic functions?<br />2. Can an ODBC connection be
created for an essbase cube?<br />3. Are their any inexpensive access
tools that interface with essbase that could be used to create simple
reports?<br /><br /><br /><br /><br /> |
|
Re:
Programmatically creating reports from Essbase cubes -- need options |
From your
note I gather that an off the shelf solution isn't an
option? As there are several available, the decision to
"roll your own" solution comes with consequences.
However, rather than point out the obvious, I'll assume
you've already explored those options and have decided on what can
be done in house.<br /><br />I'll also assume you are
triggering the process directly and can monitor it, so you don't
need special treatment for exceptions. What you are then left with
is the automation of the retrievals.<br /><br />In a word -
K.I.S.S. should apply. Keep it Stupidly Simple (or something
similar ;)). Design the reports independently of the automation,
and create the macros that open the workbooks, do the retrieves, publish the
results, and save/close the workbooks. This way, you will be able
to expand it with less coding and can isolate the impact of code changes from
the templates (which may be handed off to key users for designing,
etc...).<br /><br />Use meta-data in your code workbook that can
easily be updated. For instance, use a tab with columns for the
workbook, server, app, db, (user, password*), worksheet, and range to
retrieve. Treat each entry as an independent request for simplicity
(the overhead associated with opening, connecting, retrieving, disconnecting
and closing each one are minor compared to the benefit of keeping it
simple). *hiding or encrypting the password from casual observance
is easy enough. Leaving a cell blank should indicate the previous
entry (row or column) applies, etc...<br /><br />In fact, I
considered adding this type of processing to H.E.A.P. in the past, but
decided against it at the time (for simplicity, as it wasn't needed
by the user). However, I've already got most of these
functions in other utilities (defined retrieves, create and republish HTML
objects, mostly). I could probably add this to HEAP in a couple
weekends (depends on when I start, though). I already planned on
providing connectivity metadata to it (so it isn't tied to a single
app/db or get timed out waiting for a start time). Yeah, HEAP 2.0
sounds like a plan -- but as it probably won't be finished for a
while, I'll wish you luck on your version, and encourage you to post
it to the downloads section for the rest of us when you complete it.<br
/><br />HTH<br /> |
|
Re:
Programmatically creating reports from Essbase cubes -- need options |
I am
currently attempting to automate Excel using the .NET objects. However, the Hyperion
Objects are poorly written and even more poorly documented. The ExcelGrid11()
class simply crashes and does not populate.<br /><br />If anyone
could get that class to work, you could automate the entire process from a
.NET app. Using Excel alone to automate report generation may be the only
method of automation at this time. |
|
Re:
Programmatically creating reports from Essbase cubes -- need options |
By the
way, just in case anyone can actually use the object class, in theory it
should work like this:<br /><br /><br />GridExcel11 essGrid
= new GridExcel11();<br /><br />essGrid.Workbook = excelWorkbook;
//predefined Excel workbook<br /><br />EssbaseOperation.Grid =
essGrid; //uses established
EssbaseOp class<br /> <br />this.EssConnect(); //custom func that
connects<br /><br />EssbaseOperation.Retrieve();<br
/><br /><br /> |
|
Re:
Programmatically creating reports from Essbase cubes -- need options |
I
remember that using the Query designer in excel add-in saves the definition
in a report file that can be re-used. I haven't had the need to use
something like this so I do not know how it would help you in this case but
just wanted to throw it out.... |
|
UK User
Group |
The next
meeting for the [b][glow=blue,2,300]UK HUG [/glow] [/b]is on September 26,
2005.<br />For more details please contact the chair person. Details
on: http://www.hyperion.com/uk/usergroup.cfm |
|
Bitmap
Mode message |
The
following message appears in the application log:<br />[Tue Sep 13
12:34:32 2005]Local/Europe/Main/jrector/Info(1012682)<br />Multiple
bitmap mode calculator cache memory usage attempted to cross limit of [4]
bitmaps. To ignore limit, do not set MultipleBitmapMemCheck to TRUE in
essbase.cfg.<br /><br />In the Essbase.cfg file, I have set
MultipleBitmapMemCheck = TRUE <br /><br />What causes this
message?<br />Is there anything that can be done to eliminate it(db
setting, outline change, etc)?<br />Does it affect calc or retrievel
performance? <br /><br />Regards,<br />Tom M.<br
/>tmonahan@hotmail.com<br />Essbase 6.5.4<br /> |
|
Re:
Bitmap Mode message |
Simply
put, your calc cache setting allows for 4 bitmaps to be retained in the
cache, and you need more than this. This can happen either because
you added new shares (which can increase the number of bitmaps needed), or
you added enough members to increase the size of each bitmap and thus
decreased the number that can fit. <br /><br />This
situation only affects calcs, but because it may be possible to run multiple
calcs in parrallel, being too aggressive on your calc cache setting can be
risky (it can reduce performance significantly if you push the limit too
far).<br /><br />Option 1: Remove the settings as indicated in
the message. The additional bitmaps will be allocated from heap
memory.<br /><br />Option 2: Increase the calc cache so more
bitmaps will fit (see comments above).<br /><br />Option 3:
Decrease the number of bitmaps needed (this is only realistic if the
additional shares are caused from implied shares in the outline, generating
more than 3 virtual parents for a single member).<br /><br
/>HTH.<br /> |
|
Re:
Bitmap Mode message |
Thanks
for the input. I'll start looking in detail at some of the
options.<br /><br />One thing that we have been noticing, is alot
of dropped connections since this particular application went live and the
Bitmap message started appearing:<br />Network error: The client or
server timed out waiting to receive data using TCP/IP. Check
network connections. Increase the NetRetryCount and/or NetDelay
values in the ESSBASE.CFG file. Update this file on both client and
server. Restart the client and try again.<br /><br />Is
it related? |
|
Re:
Bitmap Mode message |
It's
all relative, to one degree or another.<br /><br />It may be that
your server is reacting slower now due to maxing out on either memory or CPU
availability. If so, the dropped connections may be attributed to
your settings. I doubt it though.<br /><br
/>What's more likely is that your network is experiencing a
higher percentage of packet collisions, due to higher traffic than
before. The availability of the new database might have brought new
users accessing it? Or it could be something totally unrelated
(well, a few additional degrees of separation, perhaps).<br /><br
/>For instance, we recently migrated to Windows XP in our
department. Along with this migration somebody got the great idea
to map everyones "My Documents" folder to SAN storage,
instead of on the local hard drive. The merits of this idea are an
issue for another discussion entirely, so I'll continue.
For several weeks after the upgrade, you could at any time of the day press a
key or click a mouse, and take the next 30 seconds as a break hoping your
system didn't actually lock up this time. Eventually, they
figured out the settings necessary to make this less painful from a
type/click perspective. However -- we are definitely experiencing a
significant impact on our network timeouts -- they used to happen once or
twice a day, now it's a lot more more of a coin toss for some user
groups, and our customers (I'm in a support group) are taking it out
on us. The increase in network traffic has obviously been
significant, and our Essbase servers are not even on the same network segment
as the SAN that is responsible for the bulk of it.<br /><br
/>Bottom line: the network error is an indication that a key message
between the client and server was dropped, and it happens all the time for
one reason or another. Usually, retries deal with this adequately
enough, but not always. If your network bandwidth is saturated
enough, you could retry till the cows come home, but at some point in time,
you need to beef up the infrastructure to really deal with the issue.<br
/><br />Here's an interesting irony -- this morning I got
an email requesting that although I already gave a technical explanation
(similar to this one) to one user group concerning our inability to address
our own "network error" issue directly; he's
requesting that we "revisit the issue" here, and
I'm not quite sure how to respond to him yet! (No, I
don't plan on telling them to take it up with the network
infrastructure group... at least not impolitely).<br /><br />Back
to the "Bitmap Mode" message aspect -- it's
generally a good idea to set MultipleBitmapMemCheck = True, but not doing so
is not quite as evil as some people might suggest (I saw the post on
HDN). Allocating memory from the heap isn't risky apart
from the possibility that it becomes paged to disk when your server runs low
on memory. It won't cause issues beyond performance when
this happens, unless there truly is a bug that I'm unaware of. |
|
How to
configure default POV for all users |
Hi!<br
/>We have a situation where we need to hide on of the currency members
from users in Hyperion reports because it only confuses them.<br
/><br />Is there a way to adjust this for all user instead of just
letting all user change their user pov?<br /><br />Can this be
done in a way in the database by altering data in the tables?<br
/><br />Thanks for any advice,<br />Erik N |
|
Re: How
to configure default POV for all users |
Can you
change you report format? Are those members set up as rows or
columns? |
|
Re: How
to configure default POV for all users |
Can't
think of anything that woud do what you are looking to do at a database
level. I think Analyzer would do something like that, but not
reports.<br /><br />What you can do is use a grid point of view
in your reports. Place Currency in the Grid point of view, select
the currency you want and then hide the grid point of view. Users
won't even know the dimension is there and the report will always
run on the currency you want without anyone having the ability to change
it. The only set back is it needs to be on a report by report
basis.<br /><br />HTH. |
|
Re: How
to configure default POV for all users |
Hi!<br
/>Thanks you all - think I got the answers I was afraid of.<br
/><br />The problem in this case is that the currency dimension
contains three members, Local, SEK and USD. Local and SEK are always the same
in this Planning APP so we just want to remove the SEK from (since it has to
be calculated) the POV but still have the possibility to choose USD and
Local. The grid point of view is unfortunately not an option both layout wise
and in terms of configuration.<br /><br />BUT - an answer I would
like to get is how the User POV are stored in the SQL server? Knowing this
this could be centrally administrated for all users just changing data in the
SQL server database.<br /><br />Erik |
|
Re: How
to configure default POV for all users |
Could you
insert a prompt for Currency and limit the choices list to just Local and
USD? It's a little annoying because they get a screen to set
their POV and then another for the prompt but it would limit their
selections.<br />Good luck!!<br />Jen |
|
Solutions
2005, Hyperion International Conference |
Solutions
2005, Hyperion International Conference<br />6-8 November, 2005<br
/>Palau de Congressos de Catalunya<br />Barcelona, Spain<br
/><br />For more information, go to [glow=black,2,300]www.sol2005intl.com[/glow] |
|
Re:
Solutions 2005, Hyperion International Conference |
Ditto for
the pacrim region<br /><br />ANZ Solutions 2005<br />13 -14
October, 2005<br />Sheraton On The Park<br />Sydney,
Australia<br /><br />For more information, go to
www.hyperion.com/au/solutions2005.cfm<br /><br />Anyone going to
this one? |
|
Re:
Solutions 2005, Hyperion International Conference |
I went, I
drank and more importantly I remembered!!!(well some of it) |
|
Solutions
2005, Hyperion International Conference |
Yes, that
seems to be the common theme.<br />The feedback forms have been sent,
and I am sure there will be a very positive tone. System 9 very much the main
theme, and a lot more depth to the breakouts than last year. |
|
Planning
Spreadsheet User Guide |
Does
anyone have a Spreadsheet user's guide in soft copy? |
|
Re:
Planning Spreadsheet User Guide |
Do you
need the Planning addin doc (pre version 4.0)<br />The Smartview doc
(version 4.0+, Smartview replaced the Planning addin)<br />Or do you
need the Essbase spreadsheet addin doc?<br /><br />I have the
Essbase and the Smartview, can probably dig up the old Planning doc from
version 3.5.1. Let me know along with your email and I will forward
to you.<br /><br />Regards,<br /> |
|
Re:
Planning Spreadsheet User Guide |
I have
the Essbase add-in already. What I dont have is the 3.5* or the smartview. If
you can email that that would be great.<br /><br />Thanks<br
/><br />[email]Sal_Rapacciuolo@liz.com[/email] |
|
How to / can I |
Is it
possible to have a report with a combox where I select a month<br />and
a graph linked to the combox but instead of seeing the selected month in the
graph I would see its children (the corresponding days).<br /><br
/> |
|
Re:
How to / can I |
The
answer is yes. When you connect your combo box to your data source,
the Select Members box opens. Click 'Add' and the
Months Browser will open showing your Time Dimension in the left
pane. Select the months you want by clicking on the check box next
to the member name. The member will now appear in the right
pane. Right click the member in the right pane and select
"Also Select Children". Repeat this for each
month. Click Ok. In the Select Members box, be sure the
"Dynamic" option is NOT selected. Click ok and go
to report view. Be sure your months dimension is either a row or
column dimension. When you select the member in the combo box, the
member will be returned along with it's children. If you
do not want to see the member and only the children. Use the
Show/Hide functionality.<br /><br />HTH |
|
Re:
How to / can I |
Thank you
for your detailed answer.<br /><br />Does it mean I will have to
update the combo box manually every time I have a new month in my
outline?<br /> :( |
|
Re:
How to / can I |
Using
this solution, yes you would have to update anytime you added a new
member. You could consider using substitution variables.
Build the combo box to work off the subvar and then change the subvar when
you add the new member to the outline. Not sure if that's
much better, but it's an option. Best bet would be to add
2 years or so to the outline upfront, define the combo boxes and then not
worry about it for two years. Things will probably change by then
anyway!<br /><br />Best of luck. |
|
Make
dependent |
Hi,<br
/><br />Lately I'm "playing" with
Analyzer 7.2.1, didn't touch it since 6.X.<br />I'm
trying to implement the "make dependent" functionality with
2 subscription objects (comboboxes), and nothing happens in the 2nd combo
when selecting a member in my first combo. I followed the help doc procedure
but nothing happens...<br /><br />Help would be
appreciated.<br /><br />Best regards,<br /><br
/>SRoux<br /><br />Win2000 SP4, SQLServer 2000 sp4, Analyzer
7.2.1, Tomcat 4.3.1, Java Client |
|
Re: Make
dependent |
Hi,
<br /><br />when you create the 2nd combo box and the
"Select Data Source" dialog comes up, you select
"Make dependent". You then get a list of all available
reporting components and you can select the objects <br />from which
your box should be dependent from.<br /><br />Hope this
helps!<br /><br />Michael |
|
Re: Make
dependent |
Thanks
but Indeed this is what I did, did you check if your result was ok? Because
mine is empty! i'll try again just in case... and post a prtscr in
case it still dead!<br /><br />regards,<br /><br />SR |
|
Re: Make
dependent |
I tried
it out and it works! Maybe you choose level 0 members in the first box?<br
/>Don't know how I can help you :(<br /><br />Best
regards<br />Michael |
|
Re: Make
dependent |
Hey!
Thanks for insisting, Finally I made it works rebooting a few times my tomcat
application server and re-creating the combos and dependence link...<br
/>I'll be a bad boy on this one, but do you know if is it
possible to set/configure the zoom behavior (which is currently an
@CHILDREN()) or is it another BORN DEAD stupid function applicable on one out
of 1000 cases..? <br /><br />regards,<br /><br />SR |
|
Re: Make
dependent |
Yes it is
such a function..it could be enhanced by Hyperion. Try and play around with
the "Also Select Subset" option together with
"Dynamic" and then link two boxes, maybe with this it is
possible to realize what you want! I can not try it out, because I now go on
holiday for the next week :) <br /><br />See you
later!<br />Michael |
|
Re: Make
dependent |
Thanks
for the info I'll make the try and keep you aware, <br />and
have a nice holiday by the way ;)<br /><br
/>Regards,<br /><br />Sebastien Roux<br />_______________________________<br
/>Partake Consulting France<br />49, avenue Hoche <br />75008
Paris - France<br />E-mail: |
|
ANZ
Solutions 2005 - Sydney, Australia |
ANZ
Solutions 2005<br />13 -14 October, 2005<br />Sheraton On The
Park<br />Sydney, Australia<br /><br />For more
information, go to
[url=http://www.hyperion.com/au/solutions2005.cfm]www.hyperion.com/au/solutions2005.cfm[/url]<br
/> |
|
Re: ANZ
Solutions 2005 - Sydney, Australia |
So
where's the HYPEd.biz after-party going to be? ;D |
|
Re: ANZ
Solutions 2005 - Sydney, Australia |
not a bad
idea at all..... |
|
Outline
Migration from 6.5 to 7.1 |
HI
All-<br /><br />I am relatively new to Hyperion,<br
/><br />Is it possible to migrate outlines from 6.5 to 7.1?<br
/>If Yes,what all needs to be migrated?<br />How do we go about
doing it?<br /><br />Please help.<br /><br />thanks
in advance,<br />venkat |
|
Re:
Outline Migration from 6.5 to 7.1 |
Taken
literally to "migrate outlines" you just save them to a V7
server ... <br /><br />But ... I think your question is about
[i]far[/i] more than the outline files so you'll have to elaborate
to get more specific answers.<br /><br /> |
|
Re:
Outline Migration from 6.5 to 7.1 |
Chris,<br
/>Thanks for the reply .To eloborate my question:<br /><br
/>1.Are there any implications in migrating outlines from 6.x to 7.x? (I
mean will outline get affected ? Like the formula's,property ot
storage type etc)<br /><br />2.When we migrate will all the files
also be migrated ? (Like the ..RUL,.SEC,.REP,.CSC...ETC)<br /><br
/>THANKS in advance.<br /><br />jeeva |
|
Re:
Outline Migration from 6.5 to 7.1 |
Depends
entirely on how you do the migration. |
|
Using the
@RANGE function with a multidimensional range |
Here's
hoping someone here can put me out of my misery. :)<br
/><br />I need to generate a multi-dimensional range of members to
pass to another function (actually a custom-defined function). The
@RANGE function can generate a one-dimensional range like so:<br
/><br />[code]@RANGE("Available Machine hours",
@CHILDREN(@CURRMBR("Entities")))[/code]<br /><br
/>The documentation for this function suggests that instead of a single
member-set function (like @CHILDREN) as the second argument, you can use a
"list of [...] range functions", which sounds a lot like
what I want to generate, like this:<br /><br
/>[code]@RANGE("Available Machine hours",
@CHILDREN(@CURRMBR("Entities")),
@CURRMBRRANGE("Time Periods", LEV, 0, -3, 0))[/code]<br
/><br />This validates, but during execution the following error
occurs:<br /><br />[code]Error executing formula for [Product
Volume] (line 27): invalid range[/code]<br /><br />If I use SET
MSG DETAIL, I can see that it occurs as soon as Essbase encounters a member
of the Entities dimension that actually has children (ie, where the @CHILDREN
function doesn't return an empty list).<br /><br />Has
anyone else used two (or more) range functions in the @RANGE function successfully? |
|
Re: Using
the @RANGE function with a multidimensional range |
Have you
tried nesting the @RANGEs ... [u]IF[/u] that makes sense ... I can confirm it
validates but I've not had time to test if it works!
:-[<br /><br />Concur that the help files does seem to be saying
what you've interpreted it as ... the "help" files
strike again!<br /><br /> ;) |
|
Re: Using
the @RANGE function with a multidimensional range |
Thanks
boss :)<br /><br />I've tried nesting like this:<br
/><br />[code]@RANGE(@RANGE("Available Machine
hours", @CHILDREN(@CURRMBR("Entities"))),
@CURRMBRRANGE("Time Periods", LEV, 0, -3, 0))[/code]<br
/><br />But @RANGE expects a single member as its first argument, so
the outer @RANGE function fails at runtime too. What I really need
is something like this:<br /><br
/>[code]@RANGE("Available Machine hours",
@XRANGE(...))[/code]<br /><br />which isn't really a
solution anyway (@XRANGE expects hard-coded arguments that point to the
"corners" of the range, not range functions like @CHILDREN
and @CURRMBRRANGE). Plus, @XRANGE can only be used in a small
collection of functions like @SUMRANGE, etc., but not @RANGE.<br
/><br />I reckon @RANGE can only deal with a set of members from a
single dimension as its second argument, which may be built up from several range
functions, but not if they return members from multiple dimensions.
I'd love to be wrong, though. |
|
VALIDATION
ERROR MESSAGE: MEASURES NOT DEFINED. |
Hi
All-<br /><br />I am using EIS to build the Outline,but when I
try to save the Metaoutline I get an Error message as <br />MEASURES
NOT DEFINED.(I also get a message as you can still save the Outline but
cannot do a member or a data load)<br /><br />I have these
dimensions in my Metaoutline:<br />Measure : Accounts - Dense<br
/>Period:Time - Dense<br />Scenario - Dense<br />Company -
Sparse<br />Type - Sparse<br /><br />Please help to
overcome this error.<br /><br />thanks in advance.<br
/><br />Jeeva |
|
Planning
New App Setup |
Hi
All :),<br /><br />
I
need to know the best practice to create a Planning App. For example, i need
to know that do we build the outline in Essbase and then transfer it to
Planning through HAL? or is there is another way to do too. Please let me
know what is the way to create the App from the beginning.<br /><br
/><br />Thanks,<br />Hypercube |
|
Re:
Planning New App Setup |
The scope
of your question is too grand for a user forum to effectively
address. Your best bet is to contact a qualified consulting firm,
or take a class with Hyperion to learn moe about Planning.<br /><br
/>Hyperion training can be found at http://www.hyperion.com/services/education_services/<br
/><br />If you need a consultant, please feel free to contact my
company www.pgww.com.<br /><br /><br />Best Regards, |
|
HAB - any
takers? |
Does
anyone have any HAB implementation stories? It seems to have a lot
of potential as something like Alphablox for developing web-based interfaces
that talk to OLAP and RDBMS data sources. At least in my own
experience, a lot of Planning work seems to be getting very close to the
point where the pain of supporting custom interfaces is less than the pain of
shoehorning certain types of complex applications into the standard Planning
framework.<br /><br />But it doesn't seem to be getting
much love. Anyone know if it's worth a look? |
|
Re: HAB -
any takers? |
Ben - I
have experience with HAB since version 2.0 (current version is 7.1X - they
skipped some release numbers).<br /><br />From my experience, if
you need to go down the custom route to deliver the full requirements of an
application, HAB is a solution. It is an unconstrained development
environment using Java and J2EE technologies. It has some similar
functionality as AlphaBlox but also has a different approach towards
application development. AB development was typically done using
DHTML technologies, although you could develop applications directly with
Java. The downside of developing applications with Java and AB is
that if the underlying classes change (which they did a lot), your code would
not compiled when you upgrade.<br /><br />With HAB, they address
this by providing a framework towards Java development within HAB.
That framework is the Web Application Architecture (WAA) that sits on top of
the Analytic Data Model (ADM) API. Within WAA, HAB provides a set
of tag libraries with reusable objects (Grids, Charts, Drop Downs,
etc). The key is that Hyperion provides the entire WAA source code.
This provides a good approach to properly extend their platform to build your
own reusable tag libraries. If you don't like the Grid
that HAB comes with, you can build your own set of features on top of the
ones that already exist. You need to do this with Java, which
depending on the capabilities of your development team, may or may not be
easy.<br /><br />I have been involved with probably 10 different
applications built with HAB. They have mostly been either custom
dashboard applications or "commentary" based applications
that could not be done with packaged tools like Analyzer or Planning.<br
/><br />Hopefully that helps. |
|
Re: HAB -
any takers? |
Thanks -
that sounds pretty encouraging. We do quite a bit of work with AB
using DHTML interfaces, so it sounds like it could actually be a better
solution than AB for that sort of development. About the HAB
framework: I understood it used JSPs, JavaBeans, etc to render its interface
in HTML in pretty much the same way as AB, so are you saying that its tag
libraries add an [i]extra[/i] level of abstraction?<br /><br />I
think I might just need to dive in and try building something myself, but I
think it looks architecturally very good indeed. Any comments about
speed/stability/scalability? |
|
Re: Copy
cell text [Q solved] |
The only
way to make this work is to edit data in the SQL server<br />One will
have to map the dimension members in HSP_CELL_NOTE with the objects in
HSP_OBJECT and then change the related columen in HSP_CELL_NOTE.<br
/><br />This works fine but remember to restart the web server
service since it probably caches the cell text notes in the form (something I
had a problem with).<br /><br />BR,<br />Erik |
|
Copy cell
text |
<br
/> Hi! <br />We have to move data from one account to another in our
planning application. Since this application has been live for a while the
users have been using cell text to store information to the different
planners. <br /><br />Does anybody have a clue how I move these
cell text to the new accounts? <br /><br />Thanks, <br
/>Erik |
|
Optimize
Hyperion Reports |
Hello
all,<br /><br />We have some reports which are generated using
dynamic data from Essbase. Different users can see different amount of data
according to their access levels. all of this works very fine.<br
/><br />these reports are accesed through the DMZ which accesses our
server in the firewall. Now these reports are taking looooooooong time to be
generated. It seems that the communication with essbase is there for short
time only but it takes a long time to format/paint the report. Can anyone
guide me , how can we reduce this time ?<br />All suggestions are
welcome. |
|
Re:
Optimize Hyperion Reports |
There's
not a lot you can do to speed up the generation of the report, but I've
seen really impressive increases in network performance across WANs when
using Reports (and Planning, and any of the other web-based products) by
turning on compression in the web application server.<br /><br
/>For Tomcat, edit the server.xml file in
\Hyperion\HyperionReports\HRWeb\conf, and add
[b]compression="on"[/b] to the Connector tag. For
example:<br /><br />[code] <Connector
className="org.apache.catalina.connector.http.HttpConnector"<br
/>
port="8200" minProcessors="50"
maxProcessors="200"<br />
enableLookups="true"
redirectPort="8443"<br />
acceptCount="500" debug="0"
connectionTimeout="600000"<br />
compression="on"
/>[/code]<br /><br />Then restart Tomcat. For
Planning or Analyzer, just find the server.xml file and do the same.<br
/><br />This option was added fairly recently to Tomcat --
I'm pretty sure the first version was 4.1.20. Reports 7.x
and Planning 3.5+ are bundled with 4.1.30, which definitely works.<br
/><br />For Websphere, you'll need to get your friendly
Websphere admin to install IBM HTTP Server 2.x and install the Apache
compression plugin. I've not tried to enable compression
for the other app servers, but it should be possible.<br /><br
/>For anyone using Tomcat, give this a go! |
|
Re:
Optimize Hyperion Reports |
Thanks
Ben,<br /><br />Your information does helps. We are using
websphere express 5.1. I have tried bumping up the memory to the JVM machine
but its not helping.<br />The same reports takes like 10 seconds on my
dev box which is inside the network but from the DMZ the reports are taking
like minute and half.. <br /><br />any clues , for what can be
done specifically for the websphere??? |
|
Re:
Optimize Hyperion Reports |
The hard
bit is making Websphere serve its pages through IBM HTTP Server 2.0, and
specifically making it work with the separate Websphere instance that Reports
and Planning create. That part is best left to the Websphere admins or
IBM support -- we needed some help from IBM to get it working. But
you'll know it's been done when you can log onto Reports by
browsing to http://server/hr (which is served by IHS) as well as
http://server:8200/hr (which comes straight from Websphere).<br
/><br />Here's a tech note from IBM:<br />[url]http://www-1.ibm.com/support/docview.wss?id=swg21178424[/url]<br
/><br />The instructions for setting up IHS 2.0 with Websphere are
here:<br
/>[url]http://www-1.ibm.com/support/docview.wss?uid=swg21115062[/url]<br
/><br />The instructions for the compression module, which is part
of the Apache webserver project (which IBM HTTP Server is based on) is
here:<br /><br
/>[url]http://httpd.apache.org/docs-2.0/mod/mod_deflate.html[/url]<br
/><br />Good luck -- it was well worth it in our case: server in
Perth, Western Australia and users in a mining town in New Zealand! |
|
Re:
Import Float Data via Rule from Oracle |
New? Yes
... but not in the way you're asking. It's new in that in
this environment - where there have been no changes to Hyperion or Oracle
executables for ages - it just started failing last week. DBA swears the
table has not changed (and I don't have the tools here to disprove
that). Basically I am at a loss as to why it has "suddenly"
started failing; and that's why I put it out there to see if anyone
else has issues with float data types... |
|
Import
Float Data via Rule from Oracle |
Had an
interesting problem today. <br /><br />Situation: Essbase 7.1.2
and Oracle 9.2 and simple odbc connected oracle rule file - all dimensions in
the table and a data column and real dumb sql statement (select * from table
- no brain surgery here!). <br /><br />Anyway long story short
the *data* column was defined as a float in the source table - all others
being varchar2(30) ... and the import failed.<br /><br />Changed
the sql to a field list and to_char( DataColumn ) and ... it worked!
???<br /><br />Should I have known this? Is there a problem
importing from floats in Oracle, should this just be a numeric field? <br
/><br />Thanks... |
|
Re:
Import Float Data via Rule from Oracle |
Is this a
new problem? Was wondering if it was since we've seen some
funkiness going from 8.1.7 to 9.2..<br /><br />Sorry that
wasn't much help.. :( |
|
Running
Calc in Analyzer |
Hi
All<br /><br />Bit of a problem with running a calc script
through Analyzer. When running a Calc I'm intermittently
getting an error message saying: "Calculation Script.....could not
be processed."<br /><br />I have changed the
MAX_PROPERTY_VALUE_LENGTH in adm.properties from 4 to 20. I have also
split the Calc Script but am still getting the same error message.<br
/><br />It's driving me potty ???<br /><br
/>Hope someone can help.<br /><br />Thanks in advance<br
/><br />Mark |
|
Re:
Running Calc in Analyzer |
Update:<br
/><br />We have changed our substitution variables so
they're specific to the database (known problem) - didn't
work,<br />also removed all Substitution variables - still
didn't work :'(<br /><br />The clouds are
gathering! |
|
Re:
Running Calc in Analyzer |
Hi
There,<br /><br />Finally found what was cuasing the
problem...<br /><br />It was a clash between what the Filter was
restricting and what the Calc Script contained. We had used a dummy
member to load "days in month" which wasn't
included in the Filter. ;D x5<br /><br />Hope this helps<br
/><br />Laters<br /><br />Mark |
|
Re:
Running Calc in Analyzer |
Hi
Mark,<br /><br />Thanks for updating - don't forget to
click on the 'tick' image, this marks the topic as
'solved' and helps others search. In this case you might
want to just tick your last post.<br /><br />Cheers,<br
/>jon |
|
Essbase
7.2 |
Does
anyone know when Essbase 7.2 will be available? Is it part of 'System
9'? |
|
Hyperion
e-learning courses |
Has
anyone done the e-learning courses via the Hyperion website? There
aren't that many but I would like some feedback before I sign
up.<br />Thanks! |
|
Re:
Hyperion e-learning courses |
HCG is
reasonably priced and doesn't suck (this is about as close to a
glowing recommendation as I give). We've used them in the
past without regret (no, I'm not affiliated with them in any
way). As for the ones from Hyperion, we thought they were just a
little over priced (relative to the alternatives, that is).<br /><br
/>Here's HCG's link:<br
/>http://www.harbinger-group.com/index.shtml<br /> |
|
License
Server 7.1.2 |
Hi
All-<br /><br />I am trying to install Essbase 7.1.2 on UNIX.My
question is how would you install the License Server?<br />How would
you Stop and Start the License Server?<br /><br />Please help me
out.<br /><br />Thanks in advance.<br /><br />Jeeva. |
|
Opportunities
in Detroit area |
If you
are looking for work as an Essbase developer or DBA, I may have some year to
year contract work for you in the Detroit area. Full details are
not yet available, but we are generally looking for people with solid
communications and support skills with at least 1 year of V6+ Essbase
experience in a Unix environment.<br /><br />Send contact
information (don't need full resume yet) to:<br />dbliss (at)
wideopenwest (dotcom)<br /> |
|
Comparing
substitution variable string |
Hi!<br
/>We are using Hyperion Planning and the admin can then lock
input months from the user.<br />In order for our calc scripts to work
we have assigned substitution variables which we use to find out what months
are closed and which are not.<br /><br />So in my example the
admin of Planning has locked to forecast scenario up until July.<br
/>My Substitution variable (&CurrMonth) is then set to Aug.<br
/><br />In my script I want to do different things depending on the
value of the substitution variable i.e.<br /><br />if(
&CurrMonth=="Jan")<br />
DO SOMETHING<br />ELSEIF(&CurrMonth ==
"Feb")<br /> Do something
else<br />etc<br />etc<br />etc<br /><br
/>However I cannot get this to work. I have tried using the @Name function
but the compiler does not like that at all.<br /><br />So any
suggestion on how to compare strings?<br /><br />Thanks,<br
/>Erik<br /> |
|
Re:
Comparing substitution variable string |
Just a
thought, but -- did you check on whether the substitution variable contains
quotes as part of the member name? If so, you'll need to
'escape' the quotes on the comparison values, as they are
now, they do *not* contain embedded quotes on the comparison.
I'm not sure how you would escape them, but something like
'"Jan"' or
"/"Jan/"" would be what I'd
suspect is needed if your variable contains a quoted member.<br /> |
|
Re:
Comparing substitution variable string |
You may
need to think a bit about the calculation logic, because this isn't
necessarily the most elegant expression, but here's a
suggestion:<br /><br />[code]<br />IF
(@ISMBR("Jan") AND @ISMBR(&CurrMonth))<br
/> something<br />ELSEIF
(@ISMBR("Feb") AND @ISMBR(&CurrMonth))<br
/> something else<br />...<br
/>[/code]<br /><br />or...<br /><br />[code]<br
/>Jan (<br /> IF
(@ISMBR(&CurrMonth))<br />
something<br /> ENDIF<br
/>);<br />Feb (<br /> IF
(@ISMBR(&CurrMonth))<br />
something<br /> ENDIF<br
/>);<br />...<br />[/code]<br /><br />With a bit
of manipulation you might be able to express the same outcome with logic like
this though:<br /><br />[code]<br />IF
(@ISMBR(@LSIBLINGS(&CurrMonth)))<br />
something<br />ELSEIF (@ISMBR(&CurrMonth))<br />
something else<br />ELSEIF (@ISMBR(@RSIBLINGS(&CurrMonth)))<br
/> something else again<br />ENDIF<br
/>[/code]<br /><br /> |
|
Re:
Comparing substitution variable string |
Thanks
for your suggestions!<br />We solved it the easy way - instead of using
text in our sub variable we just replaced it with 1 for Jan etc etc<br
/><br />We could then easily compare<br />
if(&CurrMonth ==1 ) /*January*/<br />
'do stuff<br />elseif(&CurrMonth==2)
/*Feb*)<br />
'etc etc<br
/><br />Thanks though!<br /><br />bR,<br />Erik |
|
Re:
Comparing substitution variable string |
Nice one
- I've got something similar in something I'm working on
now, but using a dynamic calc member to return the "month
number" for use in IF statements like yours, which is actually
pretty nifty. |
|
Variation
of calc times |
Hi!<br
/>Sorry for the random question:<br />We have been tuning our calc
scripts in our development environment (4gb mem, 4 CPU) with great
results.<br /><br />We then moved the same calc scripts to our
productions environment where the essbase setup is identical (block size,
caches etc etc) to th dev environment. We have double the memory and 8
CPUs.<br /><br />Even if there are many things saying that calc
times may not improve just because of the increased power, they certainly
should not get any worse, which is exactly what they have done. We are losing
about 10-15 seconds per script (which all are run on save in Hyperion
Planning) in the production environment.<br /><br />Hyperion
Planning that we use is located on a different machine together with the application
server (TOmcat in dev, BEA Weblogic in prod).<br /><br />Any
clues to where I might start looking would be of great help.<br
/><br />Thanks,<br />Erik |
|
Re:
Variation of calc times |
Could be
too late but you need to confirm if it [b]is[/b] the Essbase calculation
itself that's taking longer or the total process from (I assume)
running business rules from a planning web form.<br /><br
/>Ensure the same data, same number of blocks etc, is in dev and prod and
run the business rules as calc scripts (easy to make the code change) ...
then you'll know if it's Essbase (unlikely) or other items
in the network ... like where the relational db us located, Weblogic vs.
Tomcat, etc...<br /><br />Sorry to be so late in replying .... |
|
Analyzer
7.2.1 as a Windows service with Tomcat. |
Does
anyone have a batch script that will set up Analyzer to run as a Windows
Service?<br /><br />Analyzer v721, using default Tomcat
installation.<br />Windows 2K server.<br /><br
/>I've seen this for v6x but it looks like the app directory has
changed.<br /><br />TIA |
|
Re:
Analyzer 7.2.1 as a Windows service with Tomcat. |
You can
find an example of such a batch file for Analyzer 7.2 in the Hyperion code
libary:<br /><br
/>http://dev.hyperion.com/download/code_library/<br /><br />I
never tried it out. If you use it, please write me your experiences with it
:)<br /><br />I have also another code example which someone from
Hyperion sent me. I also haven't<br />worked with it, I can
send it to you if you want.<br /><br />Hope this is of use for you!<br
/>Michael |
|
Re:
Analyzer 7.2.1 as a Windows service with Tomcat. |
A user on
Nerwork54 posted a working solution.
http://www.network54.com/Forum/message-58296-1128536069-Tomcat+Service+Script<br
/><br />Thanks |
|
Hyperion
Articles |
HyperionTech
Articles: http://dev.hyperion.com/resource_library/articles/ |
|
Hyperion
Tips and FAQs |
Hyperion
Tech Tips and FAQs: http://dev.hyperion.com/resource_library/tips_faqs/ |
|
Hyperion White Papers |
Hyperion
White Papers :http://dev.hyperion.com/resource_library/white_papers/ |
|
Hyperion
Essbase Optimization Techniques |
Hyperion
Essbase Optimization Techniques:<br
/>http://dev.hyperion.com/resource_library/articles/optimization_techniques.cfm
<br /> |
|
Hyperion
Essbase Tuning And Optimization |
Hyperion
Essbase Tuning And Optimization:<br
/>http://dev.hyperion.com/resource_library/articles/tuning_and_optimization.cfm |
|
Hyperion
Code Library |
Hyperion
Code Library: http://dev.hyperion.com/download/code_library/ |
|
Hyperion Sample Applications |
Hyperion
Sample Applications : [url]http://dev.hyperion.com/download/sample_applications/[/url]
|
|
Hyperion Utilities |
Hyperion
Utilities :[url=http://dev.hyperion.com/download/utilities/]
http://dev.hyperion.com/download/utilities/[/url] |
|
A Quick Tour of Hyperion Essbase |
A Quick Tour of Hyperion Essbase
:[url]http://dev.hyperion.com/webcasts_demos/demo/quicktour/[/url] |
|
Report
from Essbase |
Hi<br
/>I am working on a complex report where i need to retrieve level0,
level1,level2 of Entity on rows for every record processed. Say, for a
structure like Country->US->NAmerica->Drinks->Coke
entity, should be retrieved as<br />2005 jan Actual Baseline NAmerica
Drinks Coke 300<br />2005 feb Actual Baseline NAmerica Drinks Coke
200 and so on across other dimensions<br /><br
/>Currently i have acheieved this through HAL, where i use
"extract data" fn for lev0 and pass it to "extract
std dimension fn" to retrieve its parents(lev1 and lev2) and append
it to the output record. As this requirement occurs during close of every
planning phase, the bulk of data is huge , which almost seems not worth to do
in Excel and i find lot of memory errors in HAL, advised to increase Java
size by Hyperion Support, which was of no use.<br /><br />Can
anyone suggest how better can these kind of report be executed.<br /><br
/>thanks,<br />Mohan |
|
Re:
Report from Essbase |
This may
not be that elegant, but it's just a thought. What if you
used the outline extractor to pull out your metadata and keep it on a
worksheet in your Excel file. On another worksheet, run your
report, and then use a VLOOKUP to bring over the metadata members you
need.<br /><br />HTH |
|
Re:
Report from Essbase |
How about
exporting all the data in column format, then importing that into Access to
handle your retrieval? Not sure how large your db is but
I'm betting this probably would not work for a large export file.
:-\ <br /><br /> |
|
Re:
Report from Essbase |
Along
with the other "not so elegant" answers...<br
/><br />How about importing the member/parent/parent2 in as an alias
with a character delimiting them?, then you can just replace the delimiters
with a tab char. Ugly, yes, but as long as your member names
aren't too long you should be able to pull it off.<br /> |
|
Re:
Report from Essbase |
Hi,<br
/> I had just the same thought, working on alternative where in i would
create a table for entity inOracle with level members across columns through
Outline Extractor. Later import all data into the another table. Finally
Query linking both tables. But my concern is , if i do this way then i can
develop a custom Planning application in Oracle, why do i require essbase.
The HAL Extract which i triggered yesterday eve , is still fetching
records....<br /><br />But one issue with the HAL i am working on
, is it read/writes the file for every record fetched from Essbase , This is
one big issue for getting delayed, but i have no other options to maintain a
small quantum of data across files, so HAL wouldnt error out of memory
issues.<br /><br />About creating alias, the application is in
Phase 2 development and i am just maintaining the application , and feel the
development guys would never like to change alias table or create a new alias
table.<br /><br /><br /><br /> |
|
Re:
Report from Essbase |
Depending
on the version of HAL & Planning you may experience problems related
to Java (heap size, etc.) that are only fixed with newer versions of Planning/HAL
(3.51 and above for Planning and 7.x for HAL).<br /><br />In any
event, if you're just trying to extract your data, you could try
writing a report script in EAS or App Mgr (you can create using Query Builder
in Essbase Excel add-in) then run that to extract your data, but you may
experience similar slowdowns (for different reasons).<br /><br
/>A better way is to write a calculation script to export your data using
MDX as the calc engine is much faster than the report engine.<br
/><br />On a side note, I don't want to second guess your
application but your entity dimension seems to be mixing apples and oranges
-- i.e. Region information and product information
(Country->US->NAmerica->Drinks->Coke entity ) --
perhaps these should be two separate dimensions?? <br
/><br />I hope this gives you something to work with. |
|
Automate
Excel exports |
Hi!<br
/>Is there a way to automate an export to excel from reports? Since
Reports graph possibilities are so horrible our users want to use Excel for
graph building purposes.<br /><br />Any alternatives?<br
/><br />Thanks,<br />Erik |
|
Re:
Automate Excel exports |
Nope.
Would be nice though! Have you put that in as an enhancement
request? |
|
Re:
Automate Excel exports |
Possible
end-around (I'm not that familiar with reports, so this is only a
hypothetical approach).<br /><br />a) Send the report details to
any valid data source (i.e. a text file would work with the text ds).<br
/>b) Set the Excel workbook up to use an external query to get the data
and present the graphs.<br />c) You could also use an Auto_Open macro
to read the data & publish web views off the workbook.<br
/><br />Not exactly client/server oriented (more client automation
oriented), but sometimes "down and dirty" is what works
best. For longer term (okay, IT maintainable) solutions,
you'll end up laying down some serious bucks, so lay the options out
and choose your poison. :)<br /> |
|
Re:
Automate Excel exports |
Please
excuse me if I am missing the point here as I am also not a very experienced
Reports user. However, the reports produced must be referencing a
data source, be it Planning, Financial Management, Essbase etc.<br
/><br />Could you not export the data from this application to Excel
and create the graph this way?<br /> |
|
How to
register an essbase authenticated analyzer user |
Our
analyzer user (version 7.2.1.1) are authenticated through essbase.<br
/><br />I do not figure out how I can register an essbase
authenticated user directly through the administration java client. Today
such a user has to log on first into analyzer, then he will will show up in
the analyzer administration client where I can assign him a security
group.<br /><br />Help is very appreciated. |
|
Include
Essbase as a domain |
Essbase
users can directly login to the Essbase domain via Analyzer if you include
Essbase as a domain in the<br />SECURITY CONFIG of the Analyzer:<br
/><br />Open <br /><br
/>\Hyperion\Analyzer721\conf\Analyzer.properties<br /><br
/>then under the section SECURITY CONFIG take<br /><br
/>#UseDefaultSecurityProvider=ESSBASE <br /><br />and remove
the comment!! If you want the Essbase domain to be considered first, you have
to change the order of the SecurityProviders.<br /><br />Hope
this helps! Please write me if it works!<br /><br />Michael |
|
Re: How
to register an essbase authenticated analyzer user |
Thank you
for your reply, but it isn't what I meant (I have already done what
you have written).<br /><br />My question was: How can I register
a new analyzer user in the analyzer administrationtool, that is authenticated
through essbase.<br /><br />The problem is when an essbase user
logs in the first time into analyzer, he will become automatically member of
a group everyone. But effectively he should be also be member of another
group in order to see what he should see. So I would like to first register
him in the analyzer administration tool in order to make him immediately a
group member. |
|
Re: How
to register an essbase authenticated analyzer user |
You
should be able to specify a single group that users will be automatically
added to -- I believe this is specified in a properties file and/or the
Administration Client -- I'll check my copy on Monday if
there's no response here :) I tend to have users added to a group
called "Essbase Users".<br /><br
/>There's a similar mechanism for externally authenticated users
(as in CSS rather than Essbase authentication) that's
configured in the Administration Client -- Analyzer checks for group
membership in LDAP/ActiveDirectory/NTLM and assigns them to some other group
in Analyzer. |
|
Re: How
to register an essbase authenticated analyzer user |
Yes it is
correct that you can specify a single group that is automatically added to an
essbase user when he first log in to Analyzer.<br /><br />In our
situation, as we do not want every essbase user to see anything, we attribute
the group everyone to the essbase user, where the group everyone basically
has no rights at all.<br /><br />But still my original query is
not answered enough. How can I register an essbase authenticated user before
he once logs into analyzer in order to attribute him a group with which he
sees something.<br /><br />Any help still appreciated. |
|
Re: How
to register an essbase authenticated analyzer user |
I
remember running up against this and thinking "this isn't
good", but then got caught up in other stuff on the project and
forgot about it.<br /><br />What you need to do is create the
user as a locally authenticated user (Analyzer domain).<br />Assign
them to the correct group.<br />Now when they login for the first time
using the XAUTH Domain, Analyzer is going to prompt them and they need to
specify they are a pre-existing user and login with the their external
authenticated password. Analyzer will convert them to an externally
authenticated user and they will be in the correct security group.<br
/><br />One thing I noticed is this whole process is very
buggy. One thing I had to do to get it to work was have the user log
in once to Analyzer as the local user (Analyzer Domain), then log out and log
back in using the XAUTH domain. It seems if they didn't
login the first time to the Analyzer domain, it didn't recognize
them. Probably some directories are created the first time a user
logs in and they are needed for this process to work.<br /><br
/>It's painful and not the way it should be, but you can get it
to work. Hopefully the new System 9 will handle this better!<br
/><br />Best of luck.<br /> |
|
Printing
in Analyzer 7.2 |
Hi,<br
/><br />I know Analyzer is not for printing. But, we have a
requirement we have to have all the reports done in Analyzer.<br
/><br />Is there anyway we can print the entire report instead of
screenshot. In analyzer we can print only the grid that appers on screen. Is
there anyway we can print the entire report without losing the logos and
stuff.<br /><br />Even if we can export to word or pdf or any
means that should be good. But we need the entire report.<br /><br
/>If anyone has achieved this please let us know how to do that.<br
/><br />any help in this regard will be greatful.<br /><br
/>TIA<br />Hyperion49<br /> |
|
Re:
Printing in Analyzer 7.2 |
Have you
had any luck with this ..... I have a similar problem in that I
need to print Landscape reports in Intelligence/Performance Suite.
Once a report is taken to PDF I can't seem to do anything with it
? <br /><br />Hope you've found a solution that
you can share |
|
Memory
issues |
Hi
,<br /> I get memory errors when i try to work on more than 2
MB of data (retrieving through lists). Do anyone get similar errors. Is there
a workout for it.<br /><br />Thanks,<br /> Mohan |
|
Re:
Memory issues |
What is
your error? This might help:<br />Increase the java memory
settings in the Vignette Business Integration Studio:<br />1. Open the
design time environment and go to Tools- Options-
JVM<br />2. At the bottom of this box there is a line that state
" Runtime Debugging JVM" the "The
command that the debugger will use to start a JVM" <br
/>3. In this line alter the statement so the JRE can allocate more than
256m of RAM to run this process <br />For example: C:\Program
Files\JavaSoft\JRE\1.3.0_05\bin\javaw.exe -Xmx512M -Xms512M -cp
"${VBIS_DT_CLASSPATH}" <br /><br /> |
|
Spell
check |
Maybe you
should add Essbase to the spell check database? :P |
|
Dutch
language settings problem |
When the
forum language is set to Dutch, a lot of the the images do not load properly.
The text is all verry smooth translated! ;) |
|
Thijxx -
Mexx Europe International |
:) Hello all,<br /><br />The
last few months I have been working with Pillar, Essbase and Planning as a
member of the Financial Systems Control team of Mexx Europe International
located in Voorschoten (The Netherlands). I'm starting with the
Hyperion Bootcamp training on Essbase this week and I'm looking
forward to learn more about the software!<br />As I am new to this kind
of software and my main task is to maintain the Essbase environment, this
forum will be very usefull to me.<br />The 'Compare
Outlines' tool allready saved me LOTS of work :D<br
/><br />Best regards,<br /><br />- |
|
Essbase
Administration Service 7.1.3.0 build 96 - User Comment |
Hi
all,<br /><br />I'm using the Essbase Administration
Service 7.1.3.0 build 96 or EAS for a few months now and I think
it's full of bugs.<br />Almost daily I encounter new odd
problems like I had today. <br /><br />I copied a parent
including a member from one outline to another and then I added an
association. After a few minutes I found out that I gave the wrong
association to the parent and I removed it. But when I pressed OK it was
still there :-\<br />Now I have a parent that has an association
I cannot delete >:(<br />Deleting the parent seems to be
the only solution, too bad that doesn't work either. <br />The
funny thing is that I can add associations to members and also remove
them.<br /><br />EAS is giving so much different problems on a
regular basis that I save my work after each adjustment, thats the only
solutions I can come up with.<br />Another problem is the resources it
uses, every step takes ages, and no, I'm not behind a 33MHz 486
DX2 :P<br /><br />Does this sound familiar to
people? ???<br /><br />Best regards,<br /><br
/>Thijxx<br /><br /><br />EDIT:<br />Forgot to
mention I also have strange lines trough the text looking like striketrough
but then only for a random amount of characters. Its gone when I scroll,
maybe a performance issue? |
|
ASO
Formula |
I have
the member formula in BSO, i want to convert into ASO member formula.<br
/><br /><br />IF(@ISIDESC ("U.S.") OR
@ISIDESC ("Mexico") OR @ISIDESC ("International"))
<br /> "MY Not Relevant"->"Package
Not Relevant"->"US
Market"->"Product Not
Relevant"->"Option not Relevant"->"Input
Total Retail Selling Days";<br />ELSEIF(@ISIDESC
("Canada")) <br /> "MY Not
Relevant"->"Package Not
Relevant"->"Canadian
Market"->"Product Not
Relevant"->"Option not
Relevant"->"Input Total Retail Selling
Days";<br />ELSEIF(@ISMBR (Markets))<br />
(("MY Not Relevant"->"Package Not
Relevant"->"US
Market"->"Product Not
Relevant"->"Option not Relevant"->"Input
Total Retail Selling Days") * 3 + <br /> "MY Not
Relevant"->"Package Not
Relevant"->"Canadian
Market"->"Product Not
Relevant"->"Option not
Relevant"->"Input Total Retail Selling
Days")/4;<br />ENDIF<br /><br />Thanks<br
/>sri |
|
Re: ASO
Formula |
You can
use an IIF in MDX, but there is no direct ISDESC equivalent and you have to
use tuples in place of the cross dimensional operator:<br /><br
/>IIF (<br /> (IsAncestor([Region].CurrentMember, [U.S.]) OR IsAncestor([Region].CurrentMember,
[Mexico]) OR IsAncestor([Region].CurrentMember, [International]), <br
/> ([MY Not Relevant], [Package Not Relevant], [US
Market"],[Product Not Relevant], [Option not Relevant], [Input Total
Retail Selling Days]), <br /> IIF(IsAncestor ([Region].CurrentMember,
[Canada]), <br /> ..tuple for Canada.., <br /> IIF
([Region].CurrentMember IS [Markets], <br /> ... tuple for Markets
...<br /> ... else ...<br /> )<br /> )<br />)<br
/><br />Now, I did not test or validate this since I don't
know what the outline looks like, but hopefully it gives you the gist of
it.<br /><br />Regards,<br />Jade<br /> |
|
Re: ASO
Formula |
I would
probably use CASE instead of IIF as you have a bunch of ELSEIF statements in
your BSO formula. Also a handy way to check
"ISDESC" is to do the following:<br /><br
/>[code]<br />IsValid(<br />
Intersect( <br />
{[Region].CurrentMember},
{Descendants([US]) } <br />
) <br
/>
)<br />[/code]<br /><br />Basically, that tests to see if
the current member intersects with the Desc. of US. If so it will
return True to an IF test or a CASE statement. Note the "{
}" as the Intersect function requires a SET definition which is
setup with the { }. |
|
Application
Manager vs. EAS |
Hello,<br
/><br />does anyone have a document in which the Application Manager
is compared to the EAS? Which features<br />are new in EAS and, most
important, I need the advantages of the EAS.<br /><br />Thanks
for help in advance!<br /><br />Michael |
|
Re:
Application Manager vs. EAS |
Essentially,
Application Manager is going away and Analysis Services will be the new
standard. I know many folks aren't used to EAS yet, but It
is probably a good idea to start getting used to it. From
Hyperion's site, here's their answer:<br /><br
/>Essbase Administration Services compared to Application Manager<br
/> <br />Administration Services is the new cross-platform framework
for managing and maintaining Hyperion Essbase. Administration Services
provides a single point of access for viewing, managing, and maintaining
Analytic Servers, applications, and databases. This new product incorporates
the functionality of Application Manager, provides other new administrative
features, and includes Essbase administration tools, such as MaxL.<br
/><br />Starting with release 7.0 of Hyperion Essbase, Application
Manager will no longer be upgraded to include new features. Administration
Services Release 7.0 is now the standard tool to manage the Essbase
environment.<br /> <br />And a link to get you started...<br
/><br />http://dev.hyperion.com/products/administration_services/<br
/><br /> |
|
Re:
Application Manager vs. EAS |
I've
been using EAS for a few months now and after some initial culture shock
I've found it is usable, albeit far from perfect.<br /><br
/>The old App Mgr had been around for sooo long one just got used to the
same defects release after release after release after release ... well you
get the picture. ;)<br /><br />Anyway, I suspect that EAS
will also continue to have it's own set of ongoing "features"
for years and years and ...<br /><br />The editors, for example,
are a case of two steps forward one back. Colour highlighting is good, the
editors themselves are crap - highlight colours screwed, a few have text
finds most don't, replace features lacking, fonts suck, tabs
don't work post the second in Rule Editor, and many more, text
wrapping is frustrating. But you can finally use long file names, in places,
but not spaces. <br /><br />The right click context menus are good.
But the screen sizing is poor (should be able to float them) and consistency
is notable for the fact that it appears to have been misplaced during
development. For all that it's better than App Mgr.<br
/><br />Generally I'd say it is an improvement though far
from the quality or content of what it [b]should[/b] be! :(<br /><br
/> |
|
Re:
Application Manager vs. EAS |
Thank you
both for help and the link!
:)<br /><br />Next week I have to introduce people to the
EAS and tell them why it is better to use it<br />instead of the App
Manager. I know most advantages, but I was looking for some kind of<br
/>summary of them. But your comments are also very useful!<br
/><br />Thanks again!<br /><br />Michael<br
/><br /><br />
|
|
Re:
Application Manager vs. EAS |
I've
found it really flakey (v7.1.0) too. Often slow, unstable, consumes an
ever-increasing amount of memory and has a lot of glitching in the display of
formulae, outlines etc.<br /><br />I also found that the EAS
service on the server would hang every now and then, which is a pain as we
would have to wait for technical support to restart it. We had to keep
Application Manager on one machine so that if the EAS service stopped at a
critical moment we'd still be able to get in.<br /><br
/>One really nice 'pro' is that it seems to read only
the members you 'need' in an Outline Editor only, rather
than - as App Manager appears to do - loading the entire structure in client
memory. So you can open and save very large outlines in seconds,
rather than minutes (if it all, on low-spec machines).<br /><br
/>I understand later versions are more stable though, and given that new
features are / will not be supported in AM - notably ASO at present, unless
anyone knows otherwise - it seems the only choice for new installations.
The 'cons', in my opinion, are all to do with the
implementation rather the functionality itself. |
|
Installation
of Administration console on a network drive |
Hello,<br
/><br />is it possible to install the administration console on a
network drive so that it is not required to install it <br />on all
locale machines? If so, what are the advantages and disadvantages?<br
/><br />Thank you for help!<br /><br />Michael |
|
Re:
Installation of Administration console on a network drive |
I've
installed it locally on a desktop and on a server where the admins would
connect to the server (whether directly on App server or Terminal Services
Server). The latter is probably the easiest so you don't
have to load on several desktops -- in addition, I'd assume the
server would be on the same sub-net as the Essbase server (or close to it)
and as such might give you a faster connection/response time. |
|
Re:
Installation of Administration console on a network drive |
If you
mean <br /><br />"can I install it to a network drive
then run it from a PC connected to that network drive but not the one I
installed from" <br /><br />try it. I'd like to
know the answer. If this work I can see no real issues outside of a slight
increase in startup time and the usual (unlikely) network failure
risks.<br /><br />I've used on Citrix and locally ...
prefer it locally. Using Terminal Services is little different, experience
wise, than doing it locally but you need enough TS licences...<br /> |
|
Re:
Installation of Administration console on a network drive |
Yes I
mean exactly that! We will install EAS on a network drive. Everybody who
needs to use can start it from there. I will keep you updated if it really
works!<br /><br />Thanks<br /><br />Michael |
|
Essbase
Server being replaced - 2 less CPUs |
One of
our Windows Essbase servers is being replaced. Currently, we have 4 CPU on
the box and I am being told that the new server will only have 2
"modern" CPUs that are much faster than the 4 old
CPUs. I still feel 4 CPUs are better that 2, no matter faster they
are.<br />There are 4 application running on this box.<br />Any
thoughts, feedback.<br /><br />Tom<br />Essbase 6.5.4 |
|
Re:
Essbase Server being replaced - 2 less CPUs |
[b]More =
Better[/b] ;D<br /><br />Fundamental rule of computers! <br
/><br />The answer is "it depends". It depends
upon your concurrency (particularly of calculation), disk, memory,
application and database design, functions / calcs / rules, sparcity, number
of users, method of access, usage patterns, network, the number you first
thought of and your bosses starsign.<br /><br />I've
generally found - and this is really, really simplified - that Essbase
Calculations love CPU cycles.<br /><br />But the old
"suck it and see" approach is best. <br /><br
/>I do have one serious suggestion - ask "them" (IT /
procurement / whomever) to purchase the 2CPU server as a 4CPU chassis with
only 2CPUs - that way an upgrade, if necessary, is far cheaper. And the
initial purchase not much more than a full 2CPU chassis. <br /><br />Win
this argument and you're close to getting the extra 2CPUs
anyway ;)<br /><br />Get more RAM whilst
you're at it ... and faster disk (if it's internal) ... |
|
Re:
Essbase Server being replaced - 2 less CPUs |
... and
don't forget that gigabit ethernet connection with built in SAN and
n-way segment multiplexing...<br /><br />(sorry couldn't
resist) ;D<br /> |
|
Label
Only in EIS |
Hi
guys,<br /><br />I have a basic question regarding label only
members in EIS.<br /><br />If i have a label only member in
Essbase and I choose the same member in my report it brings in the first
child member values. I know that part.<br /><br />But, my EIS
developer says that we cant have label only members in EIS as it wont work
the same way. I do not know much about EIS.<br /><br
/>All i want to know is can i have Label Only members in EIS build cubes
or not? <br /><br />If possible how can i do that?<br
/><br />If it is not possible can someone please tell me what are
the situations we cant do?<br /><br />Any help will be
appreciated.<br /><br />TIA<br />Hyperion49 |
|
Links on
newhome.asp |
Hi!<br
/>Using the 3.5 version of HFM and I am wondering if it is possible to
place a link to a document on the Links section of the default start page
(i.e newhome.asp)? If so it is possible to restrict this link to one
application on the server or will all applications have access to this
link?<br /><br />Thanks,<br />Erik |
|
Re: Links
on newhome.asp |
Sure it
is possible. Just create the link in the required position. Remember to back
up the original file and then copy/amend existing links s required. We did this
for including links to such items as corporate intranet, training etc<br
/><br />This is an all app page, so unless you get creative and
create a newhomeapp1; newhomeapp2 etc, which means amending other
asp's as well, then thats your lot. To do the multi page option is
risky in limitations for future upgrades!<br /><br />Remember, if
you have designs on upgrading to v4, the concept of homepage is obsolete. But
thats a seperate thread discussion re accessing external links. |
|
Re: Links
on newhome.asp |
You will
need to insert the link in the Sub PrintLinksTable () section of
Home.asp. As far as I am aware you can link to documents or web
addresses.<br /><br />Any links you insert will display for all
applications. |
|
User
Group |
to see
itinerary, go to [url=http://www.nchug.net]www.nchug.net [/url] <br
/><br />for directions and location in Charlotte, NC |
|
Shared
Member in ASO |
All
-<br /><br />I am migrating outlines from 6.5(BSO) to 7.1.2
(ASO).When I migrate I am unable to migrate shared members from BSO to ASO
even after assigning the DIMENSION as Multiple Hierarchies Enabled.<br
/><br />For Ex:<br /><br />DIM 1 (Multiple Hierarchy
Enabled).....<br /> Member 1 (Dynamic Hierarchy)<br
/>
Child
1<br />
Child 2<br />
Child 3<br />
Child4<br
/> Member 2 (Stored Hierarchy)<br
/>
Child
3 (Shrared Member)<br />
Child 4(Shared Member)<br /><br
/>I get an Error message as ASO does not support Shared Members but I have
read that if you enable a dimension as Multiple Hierarchy Enabled you can
assing members of a Stored hierarchy as shared members.<br />Please
help with any inputs.<br />Thanks in advance.<br /><br
/>Jeeva<br />
|
|
Re:
Shared Member in ASO |
Jeeva
-<br /><br />The first hierarchy under a Multiple Hierarchy
dimension must be Stored. You could switch the order of Member 1
and Member 2 and move the Shared Member designation from Child 3 and Child 4
in Member 2 to those members in Member 1. (Shared members must
always come below the first instance of that member.<br /><br />-
Joe |
|
Re:
Shared Member in ASO |
I was
able to resolve this doing these: <br />In BSO outline, temporarily
rename your shared members - just so the ASO outline Conversion wizard can
work. <br /><br />Once converted, change Dimension
(DIM1) to Dynamic Hierarchy. Restore shared members to original names. <br
/> |
|
Recursion
Limit |
Hi,<br
/><br />Whenever i try to run my report in Analyzer i get the
following error and the report wont open.<br /><br
/>[b]Error(1200494) Error Executing formula for [Loss Ratio]: Recursion
limit [31] reached.[/b]<br /><br />This is an ASO Cube and i am
not familiar with ASO. <br /><br />Is there anyway we
can fix this?<br /><br />Thanks<br />Hyperion49 |
|
Re:
Recursion Limit |
What's
the formula? <br /><br />I suspect simply finding a flag to
increase the recursion limit not the answer.<br /><br /> ;) |
|
Re:
Recursion Limit |
Hi
chris,<br /><br />Thanks for the reply the formula is pretty
simple. <br /><br />[b]Loss Ratio = (Incurred Losses.current
member of accident year)/(Earned Premium. current member of Accident
Year)[/b]<br /><br />Is there anyway we can fix thsi recursion
limit in ASO Cubes.<br /><br />Thanks<br />Hyperio49 |
|
Re:
Recursion Limit |
There is
a new Essbase.cfg setting that determines this. You can set <br
/>[code]<br />CALCLIMITFORMULARECURSION FALSE<br
/>[/code]<br /><br />In the config file. However, be
careful. The limit of 31 recursions is there to prevent calcs from
running away and crashing the server. Test, test, test to make sure
that multiple users retrieving that formula don't crash the server. |
|
Analyzer
server installation error:[1033] native: 2001 Essbase Error; nested exc |
???<br /><br />it is really a
hard work to deal with the installation of <br />ibm olap server
analyzer analysis services (hyperion analyzer 7.0.1.8) .<br /><br
/>i have read the article at
http://businessintelligence.ittoolbox.com/groups/groups.asp?v=hyperion-l&i=277513<br
/><br />it is about a problem of installing hyperion analyzer.<br
/><br />I am now having the same problem and I trie the methods
above but it doesn't work.<br /><br />I have carefully
checked the 3 variables (in the article):<br /><br />ARBORPATH =
points to the essbase directory<br />PATH = pointed to the essbase/bin
directory<br />LD_LIBRARY_PATH = pointed to the /essbase/dlls and the
/essbase/bin<br /><br />NOTE: the essbase/dlls directory does not
exists/<br /><br />I have <br /><br />1 - olap server
(hyperion version 7.1) /opt/arbor<br />2 - db2 UDB
/opt/IBM/db2/V8.1<br />3 - analyzer server
/opt/hyperion/analyzer<br /><br />all installed on the same
machine which is a sun workstation(SPARC) running solaris 8 .<br
/><br /><br /> PATH=/opt/hyperion/analyzer/adm/bin/solaris:/opt/hyperion/analyzer/common::/usr/bin:/usr/sbin:/usr/ccs/bin:.:/opt/arbor/bin:/opt/arbor/common/ODBC/Merant/4.2/lib<br
/> LOGNAME=root<br /> MAIL=/var/mail/root<br />
ESSLANG=SimplifiedChinese_China.MS936@Binary<br /> ARBORPATH=/opt/arbor<br
/> SHELL=/bin/ksh<br /> JAVA_HOME=/opt/hyperion/analyzer/jdk<br
/>
ICU_DATA=/opt/hyperion/analyzer/adm/bin/solaris:/opt/hyperion/analyzer/common:/HssEssDriver/<br
/> ODBCINI=/opt/arbor/common/ODBC/Merant/4.2/odbc.ini<br />
HYPERION_HOME=/opt/hyperion/analyzer<br /> HOME=/export/home/root<br
/>
LD_LIBRARY_PATH=/opt/hyperion/analyzer/adm/bin/solaris:/opt/hyperion/analyzer/common:::/usr/openwin/lib:/usr/lib:/opt/arbor/bin:/opt/arbor/common/ODBC/Merant/4.2/lib<br
/><br /><br />when i tried to make a connection to olap server
through the applet program ,i got the following message:<br />
<br />[color=Red][1033] native: 2001 Essbase Error; nested
exception is :<br /> <br
/>
com.hyperion.ap.APException:[1033] Native: 2001<br />
<br /> Essbase Error[/color]<br />but when i
try to connect to db2 udb ,it works fine.<br /><br />my olap
server also works fine , i can use maxl and ESSCMD correctly<br
/><br />anyone who can help me ? thanks in advance !<br
/><br />BTW ,i am from china ,so the lang var is zh.GBK <br /> |
|
Re:
Analyzer server installation error:[1033] native: 2001 Essbase Error; nested
exc |
I have
solved the problem by creating symbol links to the essbase library
file:<br /><br />libessapi.so -> libessapiu.so.1<br
/>llibessapiu.so -> libessapiu.so.1<br />libessotl.so
-> libessotlu.so.1<br /><br />there are some very
important log files which can help to position this problem:<br
/><br />Analyzer_install_path/appserver/logs/..... |
|
Re:
Analyzer server installation error:[1033] native: 2001 Essbase Error; nested
exc |
Good
experience shared with us.<br /><br />Thanks. Man from China. |
|
Unable to
save in EIS |
I
don't know why but since last week I have been unable to save a
model or a metaoutline in EIS (Hourglass for ever!)<br /><br
/>SERVER OS: Linux Redhat Version 3<br />EIS VERSION: Release: 7.1
(Build EIS71B168)<br /><br />I've tested with a EIS
console on 3 different PCs (two XP and one 2000) --> same result<br
/>There is no error message and everything else works fine. I can do
outline or data load without any problem ???<br /><br
/>is this issue sound familiar to someone? |
|
Lock
Outline |
Hi
All,<br /><br />Just wondering if anyone out there could throw me
some pointers. I have an Outline which says its locked, but when
checking for locked objects its not shown as locked.<br /><br />I
have run a MAXL script (see below) to clear any hidden locks but this doesn't
work either.<br /><br />[code]alter database
'Payroll'.'PayMth' unlock all
objects;<br /><br />alter system logout session on database
'Payroll'.'PayMth';<br />alter
system kill request on database 'Payroll'.'PayMth';<br
/>alter database 'Payroll'.'PayMth'
disable startup;<br /><br />alter database
'Payroll'.'PayMth' enable startup;[/code]<br
/><br />Thanks in advance<br /><br />Mark ??? |
|
Re: Lock
Outline |
Occasionally,
there is an issue where some "hidden object" gets locked by
a user. One way to clear the lock is to delete the user that holds
the lock. Of course, you should copy the user to another name and
then rename them afterward (and if they are internally authenticated, inform
them of their "temporary" password, etc...).<br
/><br />This works in cases where the lock was performed in Essbase,
and the object was either deleted behind Essbase's back, or the
security file was somehow "out of touch" (i.e. restored
afterward) when the lock was removed, user deleted, etc...<br /><br
/>In other words, a lot of different ways can result in this
"Essbase" style lock, and the solution is relatively easy
(apart from informing the user of the need to reset their password).<br
/><br />However, some times, the lock is made at an O.S.
level. Perhaps someone opened the file on the server and never
released the lock that the system placed on the file. This will
occasionally prevent Essbase from getting it's own lock, and it
naturally shows up as an already locked object. The solution here
is to go in and remove the O.S. lock (chmod in Unix, R/O property in Win,
etc.).<br /><br />HTH<br /> |
|
Re: Lock
Outline |
Hey
DougWare<br /><br />That did the trick - Thanks V.Much<br
/><br />Mark ;D |
|
Re: Lock
Outline |
Has
another "locked Object" issue recently. :'(<br
/><br />Copied the database and.. ;D<br /><br />just
another way of getting rid of a lock. However, we have some small
db's so I don't know what the affect of this would be with
a larger Db<br /><br />Regards<br /><br />Mark |
|
Formula
in ASO outline - causes Excel retrieves to run slow |
I have a
formula in a member (TimeX) of my Time dimension and it is causing my Excel
retrieves to run slow. It's a simple formula:<br
/><br />TimeX:<br />IIF ( IsUda([Account].CurrentMember,
"Asset"), <br /> ([Jun-05])<br /> , [Q3-05] )<br /><br />This is
the only formula in the entire outline. Retrieves on TimeX are taking
24 secs. If my retrieve does not include TimeX, it takes less than
a sec. Has anyone else notice the same performance degradation when
using a formula? Is there a way to speed our Excel retrieves
up? ASO is not as useful to most people if a formula causes
retrieves to be slow. We are running Essbase 7.1.2 on Windows
2000. |
|
Re:
Formula in ASO outline - causes Excel retrieves to run slow |
I have
been working with ASO a lot and have not had any issues like you
describe. There is a bug in 7.1.2 with UDA's and retrieves
though so you may want to investigate that avenue.<br /><br
/>Also, try using a CASE statement and see if that speeds it up any.<br
/><br />[code]<br /><br />CASE<br />
WHEN(IsUDA([Account].CurrentMember,
"Asset")<br />
THEN<br />
[Jun-05]<br /><br />ELSE<br
/><br /> [Q3-05]<br /><br />END<br
/><br />[/code] |
|
Getting
Page cannot be found when trying to launch Administration Tools client |
I was
wondering if anyone ran into this issue. I launch the Analyzer
start page and on that page there are links for the Java, HTML clients and
the Administration Tools. I can get into both Java and HTML clients
without a problem but when I click on the Administration Tools I get "Page
Canoot be Found" error. I checked the URL that
it's being called and it's a correct one. This
used to work a few months ago but now it doesn't.<br />This is
Analyzer 7.0.1 running on a Win2003 server on Websphere 5.0.2.<br /><br
/>I checked the Websphere logs and I see this entry in the
SystemOut.log:<br /><br />[i][10/19/05 13:31:53:225 EDT] 7fc932bf
WebAppServlet E SRVE0182E: Caught an exception trying to load a JSP on
startup: java.io.FileNotFoundException: /Administrator.jsp<br
/> at
com.ibm.ws.webcontainer.jsp.servlet.JspServlet.loadJSP(JspServlet.java:9<br
/>14) [/i]<br /><br />Has anyone ran into this problem?<br
/><br />Thanks,<br />Mario |
|
Re:
Getting Page cannot be found when trying to launch Administration Tools
client |
You might
want to check your privelges, which might have been "revoked"
to a user instead of the earlier Administrator.<br /><br />HTH |
|
Re:
Getting Page cannot be found when trying to launch Administration Tools clie |
Thanks
for the suggestions - I just solved the problem by comparing setups on two
servers. What I found was that Administrator.jsp was missing from
my Analyzer folder.<br /><br />After I copied it to:<br
/>\WebSphere\AppServer\installedApps\HIXHYPDEV1\Analyzer70.ear\Analyzer7<br
/>0.war\<br /><br />I could access Administrator Tools
again.<br /><br />Mario |
|
Re:
Getting Page cannot be found when trying to launch Administration Tools
client |
Good,
Hope the info was useful. If so, do leave a feedback/comment for the
user.<br /><br />Also, don't forget to click on the
'tick' image, this marks the topic as
'solved' and helps others search. |
|
Re: How
can i exclude #missing value from the Time Balance Avg calculation? |
thanks
anyway to garycris.<br /><br />I am using IBM DB2 OLAP SERVER
8.2( hyperion essbase 7.1) and IBM will not continue cooperating
with hyperion ,so I can not get the newest patch/release version .<br
/><br />Now I am trying to solve this problem with Calculate script/
formula .<br /><br /> |
|
How can i
exclude #missing value from the Time Balance Avg calculation? |
very
strange problem :<br /> I have a account member tagged with Time
Balance Avg ,and i have four Time member: Qtr1 , Jan, Feb, Mar<br
/><br />the values are:<br /><br />Jan 100<br
/>Feb 200<br />Mar #missing<br />Qtr1 100 <br /><br
/>But the expected value of Qtr should be (100+200)/2=150 ,<br
/><br />so I tagged the account member with the 'skip
#missing value in Time Balance' and then verify and save
the outline.<br /><br />After I re-calculated the cube ,I found
the value remain the error one : 100 not 150<br /><br />and when
I re-opened the outline ,I found that the tag 'skip #missing value
...' was missing.<br /><br />then I tried several times
,but still couldn't add the 'skip #missing...' tag
to the account member<br /><br />Does anyone know why? <br
/><br />see the attachment pls.<br /><br /><br
/><br /><br /><br /> |
|
Re: How
can i exclude #missing value from the Time Balance Avg calculation? |
Had a
couple of minutes to kill so I built a quick test app and made it identical
to yours. Was able to get the correct resluts. Not sure
what could be causing the problem, but the underlying functionality appears
to work.<br /><br />Tested on Essbase version 7.1.3.<br
/><br />Best of luck, if you figure out what was causing the
problem, post the solution.<br /><br /><br /><br /> |
|
Re: How
can i exclude #missing value from the Time Balance Avg calculation? |
Just came
up with one more thing. Did you clear your data after you made the
change to the setting? Try clearing your data, reloading and see if
the problem persists. |
|
Re: How
can i exclude #missing value from the Time Balance Avg calculation? |
thanks to
garycris !<br /><br />I can get the picture too.<br
/><br />The problem is that when I saved the outline and re-open
this outline ,the 'skip ...' tag disappeared.<br
/><br />And I had cleared all the data before I modified the
outline. |
|
Re: How
can i exclude #missing value from the Time Balance Avg calculation? |
by the
way ,my essbase version is Release 7.1.0 (ESB7103B019) |
|
Re: How
can i exclude #missing value from the Time Balance Avg calculation? |
Now
I'm wondering if it's a bug in that version. When
I tested it I was able to save the outline, close it and when I went back the
skip #missing tag was still in place. |
|
Creating
a "Complex" spreadsheet |
::)<br
/><br />I am trying to create a spreadsheet with too many
variables...or so it seems. A little background:<br /><br />The
basic spreadsheet is a plot of [b]Time [/b] vs [b]Program[/b]. The other
dimension members are: <br />[b]Organization[/b], [b]Scenario[/b],
[b]Measures[/b].<br /><br />The "complex" part
is:<br /><br />I need to extract the Actuals ([b]Scenario[/b])
for a Division ([b]Organization[/b]).......I have set them up as Page
Dimensions....for two measures (A, B, C...in one member of [b]Measures[/b] vs
X, Y, Z in another member of [b]Measures[/b]).<br /><br />Can I
create all of them in one report? If so how?? The complexity arises mainly
due to the fact that I have already chosen [b]Measures[/b] for A,B,C....so
when I create another combox for X, Y Z....results are not what I expect to
see.<br /><br />I am sure there is a more effective way of doing
this...<br /><br />I will need to create a several similar
reports for different scenarios?<br /><br />Any help will be
appreciated.<br /><br /><br /> |
|
Re:
Creating a "Complex" spreadsheet |
It
depends on how interactive you want the report to be for your
users. If you can pre-define the views, you can do it, but there
ability to drill and pivot, etc becomes limited.<br /><br />The
process in Analyzer is clunky but basically it can be done with the Show/Hide
functionality. Using the Show/Hide with Advanced member selection
you can remove from view the "extra" results you
don't want your users to see. Basically you're
creating asymmetric reports in Analyzer (which by default does symmetric
reports).<br /><br />HTH |
|
Re:
Creating a "Complex" spreadsheet |
Gary:<br
/><br />Thank you for your prompt reply.<br /><br
/>To expand further,<br /><br />The
"problem" is mainly from the fact that I am using members
from the same dimension to (as you rightly fathomed) create assymmetric views.<br
/><br />Thus a user from a particular organization should
be able to able to toggle between Forecast and Actual ([b]Scenario[/b]) but
should be able to view C([b]measure[/b])-Y([b]measure[/b]) for October
2005.<br /><br />Does it make sense??? <br /><br
/>Currently, the users are using excel and have several views and a lot of
manual labor is involved to arrive a particular value.<br /><br
/>I am not sure how Show/Hide may work in this situation.<br
/><br />Regards<br /> |
|
Re:
Creating a "Complex" spreadsheet |
I'm
not certain it would work for you without actually seeing what you are trying
to do. The idea behind Show/Hide is to first pull a Symmetric
report and then hide the rows/columns you don't want to see to make
it Asymetric. The problem is that you lose a lot of the 'dynamic'
functionality and the reports become more static giving the user less
functionality. Ther reason for that is because it's
usually too much work to try to pre-build every view a user might want.<br
/><br />A simple example would be if you had Scenario Actual and
Budget on your columns along with your months and you wanted to see Jan:Jun
Actual and then Jul:Dec Budget. In order to do that you would pull
Jan:Dec for Actual and Budget and then use Show/Hide to hide Jan:Jun Budget
and Jul:Dec Actual. From a presentation perspective it will look
nice, the problem starts to come next month when you want it to
roll. The report becomes very maintenance intensive and you have to
go and update the show hide settings. Moral of the story is that
Analyzer is not great for Asymetric reports. Do you have Hyperion
Reports? That product's Grid layout allows you to do
Asymetric reports pretty easily and the web interface would give your users a
familiar way to connect. Another option would be to build an Excel
package and use VBA to automate the things that are slowing you down with the
current Excel package.<br /><br />Sorry it's not more
help. |
|
Re:
Creating a "Complex" spreadsheet |
Gary:<br
/><br />It makes sense. Thanks a lot for the detailed explanation. I
have been able to work around that "problem", though not
exactly as I wanted it to be at the start.<br /><br />On a
different issue:<br />1) How do I share access of my
reports/presentations with users? Though I, as an administrator, have given
them requisite list/read rights and even placed the individual reports and
presentation in their folder, they are able to access only the individual
reports...and not the presentation. What am I doing wrong?<br /><br
/>2) How do I add comments to my reports/presentations for users to see
(as a part of the repor/presentation)?<br /><br />Thanks again
Gary<br /><br /> |
|
Re:
Creating a "Complex" spreadsheet |
Have you
set the security for the presentation to allow the users to have access to
it? Try going to the view pane, navigate to your presentation,
right click the presentation, go to the Security tab and assign access
there.<br /><br />As far as Comments, I take it you mean a
description that is more descriptive than the Save As file name.
Following the steps above if you go to any report or presentations properties
via right click menu, you can set the description. If by comment
you meant some kind of text in the actual report, then you should look at
Label or Text Area objects.<br /><br />HTH |
|
Security
Dumper add-in (auditing) |
This
add-in extends the Essbase menu to allow creating a dump of the Essbase
security (more complete than the security workbook posted in the other
thread).<br /><br />This list includes all filter details, all
group details, and all access details, for a given database, and was intended
as an "audit" tool.<br /><br />Between this
add-in and the security workbook already posted (which was intended to make
managing security assignments easier, not so much for auditing), I'm
about done messing with security. ::)<br /><br /> |
|
Re:
Security Dumper add-in (auditing) |
This tool
is quite nifty. Thanks for sharing it with us. <br /><br />Doug-
here is a question for you on a related note, I am not really familiar with
either VBA macro programming nor VB. How difficult is it to learn VBA
programming and apply it in the Essbase world? If one does end up learning
this, how frequently they might use it in the real world such as day to day
activities, maybe as an Essbase developer? Never got around to learning
API/VBA etc., :( |
|
Re:
Security Dumper add-in (auditing) |
I have
personally owned every version of VB produced (INCLUDING the truly awfull
"VB DOS", which I somehow managed to market an application
in). So to me, VB is like a second language, and VBA has become the
dialect of choice.<br /><br />How easy is it to learn? Too
easy. Script kiddies dabble in it and claim proficiency. Casual
users think they've mastered it because they can automate tasks in
Excel and take complete control of the application. VB has always had
a bad rep because "it lacked structure", and VBA has taken
on that same rep because it ALLOWS unstructured development.<br
/><br />Does this mean I try to discourage it's use?
Yes and no. It's not the answer to every problem, and for
*ANY* business environment, it should be reserved as a last resort
solution. Minimizing it's uses is a good thing, but because
of it's bad reputation, many IT departments have outright outlawed
it entirely, which is NOT a good thing. It doesn't take into
account the benefits it provides to those "novice users",
the independence it gives to anyone that takes a little time to learn it, OR
the amazing versatility it gives to professional deveopers that have truly
mastered it. People rip on it using old programming concepts, not
realizing that the abilities VB has brought to users have made those concepts
obsolete.<br /><br />You see, the "bad
reputation" is not fair because it presumes that the maintenance
aspect of VBA code will always be a higher price to pay than the loss of
benefit or the upfront development time of alternative approaches.
It's also not fair because today's development alternatives
suffer from (pretty much) the same issues, just with a "protected"
skill set that IT fiefdoms can more easily reserve to themselves.<br
/><br />I remember a developer conference where a well known C++
programmer compared C++ to VB, and he showed some beautifully drafted C code
to do some simple string parsing (a supposed weak point in VB). He
then displayed some "VB Code" to do the "same
thing", and used this as a basis for comparison. Naturally,
the C++ program was 10 times faster than the VB crap he used. Within a
couple hours, I designed some VB code, and using his C++ code for comparison,
had a VB version that ran nearly 3% faster than his original version (under
"normal" conditions, well written functionally identical
C++ code would run a fraction of a percent faster than the VB version, I can
only assume that I was able to get better optimization in the algorithm
itself). The point -- C++ uses a set of highly [s]compiled[/s]
optimized DLL's to do it's real low level work, BUT SO DOES
VB. Until recently, the VB run time DLL's were NOT that
optimized. Now, however, you pretty much have to write sloppy code to
get "poor" results.<br /><br />As for using
VB/VBA with Essbase -- well, I'd say it was moderately easy.
It's easy in the sense that the Essbase API is easy to work with,
and not quite so easy when you consider that using any API at all can be
frustrating to novice users. It's procedural instead of
object oriented, for one thing, and for another, the sample code used to
explain the Essbase API is written with the same care as the VB code written
by that C++ programmer at the developer conference I mentioned above.<br
/><br />My recommendations:<br />- Don't be afraid of
using VBA in Excel, get samples, get comfortable, get creative. This
is what makes it powerful AND useful.<br />- Always use
"Option Explicit" -- this is an absolute must.<br />-
Keep it simple -- complexity breeds problems like nothing else.<br />-
Don't try to create applications or "applets" --
instead, create tools that help you get the job done. This distinction
helps keep each element separate, which leads to less complexity.<br
/><br />One last thing -- IT departments can not support user
generated code, so if a problem occurs, you are on your own. However,
it's not difficult to get help from the forums, like this one. |
|
Re:
Security Dumper add-in (auditing) |
Hey
Doug,<br /><br />That's a nice write up. Would
you mind elaborating a little more on the<br /><br />"-
Always use "Option Explicit" -- this is an absolute
must."<br /><br />TIA |
|
Re:
Security Dumper add-in (auditing) |
Doug -
Thanks for the excellent write-up. The information you have provided is
invaluable for a VBA/programming n00b like me. I am planning to buy a VBA
Macro Programming book. If yourself or anyone in this board have suggestions
on a good book, could you please share it with us? Thanks again! :) |
|
Re:
Security Dumper add-in (auditing) |
Sure,<br
/><br />"Option Explicit" is an absolute must for
a lot of related reasons. I'll begin by what it does for
the compiler, as a review of it's original design, and then go on to
why this is so critical.<br /><br />Option Explicit forces
variables to be explicitly declared in the code, as opposed to allowing
undeclared variables to be generated for you. When you fail to
declare your variables, VB will (by default) happily supply you with a
variant class variable. Variant's are not type cast in any
meaningful way, and can be used to store any type of value.<br /><br
/>Now why it's critical for good development:<br /><br
/>1) Your variables won't be type cast without being declared, so
overflows and assignments could generate invalid results, this is generally
known as "Evil Type Conversion" (although this also applies
to conversions between typed variables as well).<br /><br />2) If
you have a typo in your code, there will be no indication, and you end up
with two different variables that are especially difficult to
identify. This particular issue exists even if you declare your
variables, without the option explicit keyword, you'll get no
outward indication that a problem exists.<br /><br />3) Most
importantly, maintenance will always be made more complicated when you deal
with undeclared variables, even if you declare them routinely, the potential
for an undeclared variable is enough to cause unnecessary maintenance
problems.<br /><br />So you may be saying to yourself,
"so what, big deal" -- the point is that it really is a big
deal. The effort required to declare variables is miniscule
compared to the effort associated with fixing a bug in a project that
doesn't require them. While a project that contains option
explicit may not be well designed, I consider any project without option
explicit to automatically fall into the "poorly coded"
category. Not out of a sense of moral superiority, but because it
lacks the most basic troubleshooting tools to help correct any bugs that
might exist.<br /><br />Finally, there are a number of
"standards" that actively help to distinguish
"well developed" projects from hastily assembled macro
collections, and you'd be hard pressed to find one that
doesn't place "option explicit" at or near the top
of the list. It's not obvious, but there's a
reason this represents a consistency you won't find in most other
elements of a good standard -- it just helps promote good programming skills
from the start.<br /> |
|
Re:
Security Dumper add-in (auditing) |
Thanks
for that great tool. I just use to audit some filters recently.<br
/>The only issue I found is that some of my filter rows are longer than
511 characters! and then they are not displayed totaly in Excel cells.<br
/><br />Best regards and keep on dougwaring!<br /><br
/>Sébastien Roux<br /><br /> |
|
Re:
Security Dumper add-in (auditing) |
Hmm,
unless this was a change in V7, you are probably looking at a real issue
there -- for the filters themselves.<br /><br />I can confirm
that for version 6.5 and below, anything beyond 511 chars (510, actually) is
truncated in a filter line. The best thing to do is break long
lines up into multiple lines, and avoid lines longer than ~500 chars.<br
/><br />This isn't an issue with the tool, it's an
issue with the filter itself, I pull the entire filter line using the API,
and if it cannot see the whole line, neither can Essbase (you can confirm
this by trying to edit the line in Application Manager).<br /><br
/>However, if this has changed in V7+, it has some backward compatibility
issues that I'll need to deal with -- but I'd still
recommend keeping the lines shorter.<br /><br />Thanks for the
feedback++<br />-Doug<br /> |
|
Can I
change the cell size of my database? |
the docs
says: the space allocated to each cell is 8 byte <br /><br />if
my data value will never be greater than 4 byte ,can i change it to 4 byte?
how?<br /><br />if essbase does not allow me to change this param
,why? |
|
Re: Can I
change the cell size of my database? |
No, you
cannot change the cell size. <br /><br />There are plenty of
historical reasons why this is not alterable, it is not too difficult to
understand why. ;)<br /><br />The good news, perhaps, is
that ASO in the new Version 9 will automatically store to 2, 4 or 8 bytes
depending on the value required.<br /> |
|
Re: Can I
change the cell size of my database? |
thanks to
|
|
Re: Can I
change the cell size of my database? |
Additionally,
compression settings will determine how big your block size actually is so
many of those 8 byte cells will be compressed down if they are empty. |
|
Re: Can I
change the cell size of my database? |
It has
been many a year since I last did testing on compression types (BSO,
obviously) and then it seemed to be a quite specific scenario before one
option showed any significant improvement on another.<br /><br
/>Do you have any samples or test results (mine being long gone...) that
could give a more definitive "in these conditions use bitmap, in
these use RLE, etc"? |
|
Re: Can I
change the cell size of my database? |
Chris - I
can't say that I know any more than what I learned years
ago. I guess I haven't done much testing either.
The rules that I always went by were based on block density. When
you have low block density and are loading zeroes (bad idea anyway) you
should use RLE. If you have extremely high block density (over 80%)
use no compression and everything else should be Bitmap. I forget
which version but fairly recently they released a 4th compression type which
is ZLIB and I believe it's based on the same algorithm that
"Zip" programs use. I've never tried
it. I'd also say that it's been a very long time
since I used anything other than BitMap. |
|
Re: Can I
change the cell size of my database? |
What
about the use of the Accounts tag to indicate a compression dimension?
I read in System 9 dbag that I should be able to see the bundle fill and
average bundle length in DB properties but I do not see them. Any
ideas? Is this only in a System 9 version - I thought for now
System 9 uses Essbase 7.1.5?. |
|
Re: Can I
change the cell size of my database? |
Not sure
about your question Dino, but I can tell you that System 9 Essbase is not
v7.1.5. System 9 Essbase has new functionality like duplicate
member names, sub variables in member formulas ad other stuff. |
|
Network
error when reading from txt file |
Hello!<br
/>I have the following statement in my nightly .mxl file<br
/>[code]<br />MAXL> import database XXX.Sales data from
data_file<br /> 2>
'd:\Hyperion\Essbase\App\XXX\Output\R_ExpAllSales.txt'<br
/> 3> on error write to
'd:\Hyperion\Essbase\App\XXX\Logs\E_SalesLoad1.txt';<br
/><br /> ERROR - 1042013 - Network error [10054]:
Cannot Receive Data.<br /> ERROR - 1042012 - Network
error [10054]: Cannot Send Data.<br /> ERROR - 1241101 -
Unexpected Essbase error 1042013.<br />[/code]<br /><br />The
user that I am logged in with have just previously in the same .mxl file
written to the same location. I.e. it seems that I do not have an access
issue here. The exact script works perfectly in an other environment.<br
/><br />Does anybody have any clue?<br /><br
/>Thanks,<br />Erik |
|
Re:
Network error when reading from txt file |
Unfortunately,
this is an error that many of us have to live with -- below is a technical
explanation, so I apologize if it generates the dreaded
"MEGO" effect (My Eyes Glaze Over...):<br /><br
/>The network will occasionally step on a crucial packet (via collisions),
and the Essbase server will either not get a request or the client will not
get a response. The timeout
occurs when the other one figures out it can't complete a request,
and depending on the request itself, you can only retry the
operation. This isn't a bug in Essbase so much as Essbase
being "not quite" tolerant enough for a network that loses
too many packets. Making it (essbase) more tolerant usually means
giving it longer delays and additional retries, but if you already have a
fairly high setting for both, increases won't do much (meaning the
network is highly over-utilized). It is also possible that some
router or hub is not configured appropriately, contributing to this issue,
but finding it, or even being able to point the network people in the right
direction could be a monumentally difficult task. (I've
heard that it often occurs as a result of client bridges between wired and
wireless networks, but even this much doesn't really help much, it
only shows us where to look).<br /><br />If anyone else has a
more "useful" answer, please chip in. Otherwise,
my only real recommendations are to:<br />a) try increasing network
retries and/or delays (refer to the DBAG section on Essbase.cfg)<br
/>b) try getting your network people to identify any possible network
issues that might reduce collisions.<br /> |
|
Re:
Network error when reading from txt file |
Oh,
forgot to mention -- <br /><br />I HAVE seen posts where application
conflicts contributed to this type of error, but not knowing what you have
running makes it difficult to determine if there is a conflict, and I
don't remember any based on reading text files (I seem to remember a
planning/data load issue, though). |
|
Re:
Network error when reading from txt file |
You
mentioned that is your nightly.xml file.<br />Is it possible that the
server backup process is running and has a lock on the file at the same time
your are trying to load it? |
|
Re:
Network error when reading from txt file |
Good
point. Most of the backup related issues I've seen were
not direct file lock issues though, but due to the increased network
traffic. This happened at more than one client every night withing
minutes of their nightly backups kicking off, even though they had the
Essbase servers at the bottom of their backup queue (doesn't make
much difference if they all use the same SAN).<br /><br />Either
way, moving the start of the job so it doesn't have any potential
conflicts makes sense.<br /> |
|
Creation
of PDF through Hyperion Reports |
Hi
All,<br /><br />Our current situation is: We have lots
of "static" reports (due to licensing issues) and now we
have new licenses so can create dynamic reports ;D .<br
/><br />I'm toying with the idea of creating PDF reports
from these dynamic reports, but was wondeirng how it would be possible to
cycle through 20 Cost Centre members (LEV1) and have each PDF point to a
different member. Can H' Reports cycle through a recordset
or such like ???<br /><br />Hope this makes sense<br
/><br />Many Thanks<br /><br />Mark |
|
Re:
Creation of PDF through Hyperion Reports |
If I
understand the situation correctly, you should be able to put the Cost Centre
dimension in the 'Page' section of the report
grid. Select the 20 members and when you generate the PDF report
you will have a 20 page report, one for each cost centre.<br /><br
/>HTH |
|
Re:
Creation of PDF through Hyperion Reports |
Maybe
I'm confused but why don't you create a book?
Then you can schedule it to run or e-mail out, etc... |
|
Re:
Creation of PDF through Hyperion Reports |
Hi<br
/><br />thanks for your responses...<br /><br />Gary -
I'll give this a go, but what I'm after is 20 separate
PDF's created from one dynamic report/book. We'd
prefer if each Cost Centre member couldn't see each other portfolio
- it might distract them!! Might find a way of splitting the PDf out,
but it's an additional step in the process.<br /><br
/>Aleck - If we use static reports/books, I think each one would have to
be separate. Therefore we'd have 20 or so reports to
maintain rather than one.<br /><br />...One Report to Rule them
all!! ;)<br /><br />Off to the Hyperion Conference in Barcelona
tomorrow, so might find out a little more. Will get back to you
with what I find.<br /><br />Thanks for your suggestions.<br
/><br />Mark |
|
Re:
Creation of PDF through Hyperion Reports |
Sounds
like you need a batch.<br /><br />Create your report so the Cost
Centre is a user prompt.<br />Add your report to a batch and select the
cost centre you want. Repeat adding the same report to the batch
and each time selecting a different cost centre until you have all 20
added. Use the scheduler to run the batch and export the results to
PDF. When completed, you should have 20 PDF files, one for each
cost centre. The maintenance is kept to one report and one
batch.<br /><br />HTH |
|
Re:
Creation of PDF through Hyperion Reports |
Hi
Gary<br /><br />Thanks for that, I´ll give it a go when I get
back.<br /><br />Thanks<br /><br />Mark |
|
Re:
Creation of PDF through Hyperion Reports |
Hi
Gary<br /><br />Worked a treat. ;D<br /><br />Many
Thanks<br /><br />Mark<br /><br />PS there is a
supplementary question but that can wait for another day! |
|
Two
concurrent sessions end up to connect to the same application. |
Goodmorning.
We have noticed that when one user needs to watch simultaneously forms from 2
different applications and switches from form i that is connected to app A,
to form iv that is connected to app B, form i is no longer connected to app A
but to app B. This is very annoying because there are many cases where a user
needs to have two windows opened with data from the 2 applications so as to
be able to compare them.<br />We know that this can be corrected cause
there are some pcs that work ok.<br />Has anyone faced a similar
situation?<br /><br />Thanks in advance for any help,<br
/>Maria<br /> |
|
Re: Two
concurrent sessions end up to connect to the same application. |
Try
opening two separate Internet Explorer sessions instead of opening a new
window from the first one.<br /><br />To do this, you need to
launch Internet Explorer from the Start menu or desktop [i]twice[/i], log
into one application from the first session and the other application from
the second. Works for me when I'm setting security as an
admin in one window and testing the result as a user in the other! |
|
Re: Two
concurrent sessions end up to connect to the same application. |
I did
open 2 different sessions but using the same shortcut.<br /><br
/>When I used a shortcut stored in Favorites to open the application, the
situation changed.<br />The session's details (application,
username) remained unchanged.<br /><br />Thank you very much for
your help,<br /><br />Maria |
|
Connectivity
Issue? |
One of
the servers which Analyzer was using crashed yesterday. Though it has
subsequently been up, my Analyzer (7.2) is not working....gives me error when
i try to open an existing report or try to create one. <br /><br
/>When I look into the Repository tab under administration tools, the
error generated is: <br
/>org.apache.commons.lang.exception.NestableRuntimeException:Error loading
object with specified column "atf_id" with value of "1420"
<br /><br />Any ideas on how to resolve this? Does it mean that I
need to reinstall the whole thing again? What kind of privileges would I
need? <br /><br />Regards <br /> |
|
Hyperion
System 9 BI+ Analytic Services (Essbase 9X) New Features |
Aside
from the new name (sigh) it looks like there are some really nice new
features in Essbase 9.<br /><br />1) ASO Restructuring:
"In most cases, you can now change a database outline and
restructure without clearing data from the database."<br
/><br />2) ASO Export: "Ability to export level-0 data from
ASO databases."<br /><br />3) Kernel Improvements:
"Enhanced support for deep, ragged hierarchies in an
outline." "Improved database
compression."<br /><br />4) Support for outlines with
Duplicate Member Names.<br /><br />5) Advanced Relational
Access.<br /><br />6) Extended Substitution Variable
Support: You can now use sub variables in Outline Formulas,
Security Filters, Areas and Mappings definitions for partitions, MDX
statements, and Data Load Rules.<br /><br />There is also added
functionality for Report Writer Commands, Data Mining Enhancements, Maxl and
MDX, and the API.<br /><br /><br />Overall it looks like
some very nice new (long awaited) features.<br /><br /><br
/>Regards, |
|
Reports
in Spreadsheet Addin |
hi
guys,<br /><br />I am back here for some direction...<br
/><br />Our business users want to do ad-hoc reporting against the
cube using spreadsheet add-in. I think they have been trained to use the tool
and are comfortable with it. Now the situation is that our cube is designed
in such a way that the kind of reporting they want , does not work. <br
/>The business users are trying to get some detailed level records from
the cube using query designer. So, when the query runs, it is creating just
about million of rows (all of them don't have data). And now
whenever they run these reports, the add-in just hangs there for hours and it
has to be closed forcefully. We can have similar reports using hyperion
reports but as per requirement, they need to do ad-hoc reporting using
different options quickly. We have worked on cube design and there are no
more associations left to me made between different data in the cube so that
we can narrow down the possible combinations.<br /><br />In
hyperion Reports, we can choose to do compression on database server, which
allows it to run, since it is getting non-supressed rows only. In spreadsheet
add-in, I am not familiar with this kind of feature.<br /><br
/>Hyperion Tech support could not provide a good enough answer for
this..<br /><br />What could be a way to be able to allow
business users to do ad-hoc reporting? Are there any configurations that I
can do to allow the users to be able to send a query from excel and supress
data on the database server??<br /><br />All suggestions are welcome.<br
/><br />Thanks in Advance. |
|
Re:
Reports in Spreadsheet Addin |
I've
seen behavior like this when there were several dimensions that were being
zoomed in on. You can mimic this behavior by doing the zooms
manually. If you select all dimensions and zoom at once, you will
wait very very long, and most likely stall out. However, if you
zoom in on one dimension at a time, it works fine.<br /><br />The
bottom line then, is that you could try setting the query up to do the first
zoom in, and do the others manually. Not a great answer, but one
that might work, assuming of course this is your issue. |
|
who knows
how to monitor the progress of a calculation |
when a
long-time calculation is in progress, I want to know when will the
calculation stop.<br /><br />thanks! |
|
Re: who
knows how to monitor the progress of a calculation |
The answer
to this depends on how/who kicked the calculation off.<br /><br
/>If you are the client that initiated the calculation, you may be
referring to an asynchronus calc that was initiated via several
methods. For instance, a calc initiated via the Excel add-in may
not display a message when finished if you have your Essbase settings to
display errors only. Changing the setting to Warnings will display
a dialog when the calc finishes. If you initiate the calc using the
API, you have to monitor the process state in a loop, waiting for it to
finish.<br /><br />Please post more information on what
circumstances you are interested in monitoring, and perhaps there is a way to
provide a more specific answer.<br /> |
|
Re: who
knows how to monitor the progress of a calculation |
"The
Hyperion Essbase Calc Status utility is an Essbase management tool that
enables administrators to monitor the status of Essbase calculation
scripts."<br /><br
/>http://dev.hyperion.com/download/utilities/calcstatus_utility.cfm<br
/><br /> |
|
Re: who
knows how to monitor the progress of a calculation |
That
looks like a nice tool -- unfortunately, I couldn't get it to work
here.<br /><br />Gary, have you been able to get that to
work? I may have to try it out at home, but here it's
probably butting heads with the group policy settings (they are a bit
restricted here).<br /> |
|
Re: who
knows how to monitor the progress of a calculation |
I
haven't tried it. I just recalled seeing it and figured I
would point it out. If I can find some time I'll try to
test it out. Right now I'm installing all the System 9
products to a test environemt, so that's keeping me busy for a few
days. |
|
Re: who
knows how to monitor the progress of a calculation |
the
'calc status' tool doesn't work . it always show a
error message'1030000' |
|
Re: who
knows how to monitor the progress of a calculation |
This is
the same error I got -- either it's tied to a version issue, or the
group policy on my work machine is preventing key registry settings (or some
such).<br /><br />The interface itself looked
"slightly" kludgy also, but this was forgiveable.
Either way, I added the concept to my "future tools" list
-- it has direct potential. Of course, I'll want to use
more of a dashboard + detail list approach, with more than just calcs
included (i.e. restructures, which affect the users just as much).<br
/><br />Anyway, it was still a nice suggestion, thanks Gary.
:)<br /> |
|
Re: who
knows how to monitor the progress of a calculation |
I tried
the the Calc Status and if I remember correctly is a shareware - it stops
working after a number of days and you have to buy a registration
key. I even complained about it in a post on the Hyperion Developer
Network ([url]http://dev.hyperion.com[/url])<br />I would also be
interested in trying out another tool that would accomplish this.<br
/><br />Madmari |
|
Re: who
knows how to monitor the progress of a calculation |
Its not
the best, but the following put into the Essbase.cfg may help a
bit-- you just have to monitor the app log:<br /><br />//Displays
messages after x% of the DB is calculated<br />CalcNoticeDefault
10<br /><br />Eric |
|
Re: who
knows how to monitor the progress of a calculation |
[quote
author=DougWare link=topic=119.msg362#msg362 date=1131625238]<br />If
you initiate the calc using the API, you have to monitor the process state in
a loop, waiting for it to finish.<br />[/quote]<br /><br
/>Hi there Doug<br /><br />Any chance you could expand a
little on how to do this as I'm wanting to to run additional VBA
just as soon as my Calc has finished running.<br /><br />Any help
you could give would be greatly appreciated :o)<br /><br
/>Thx,<br /><br />steve |
|
Re: who
knows how to monitor the progress of a calculation |
The
following is an older function for running file based calcs... It
works with references to things you don't need (for instance, the
myApp object, which I typically connect to an Excel application or a wrapper
class in my own programs). This may point you in the right direction
for monitoring asynchronous calculations, provided you kick them off with the
same context.<br /><br
/>===================================================<br
/>' RunCalc -- Runs standard essbase calc script on server<br
/>Public Function RunCalc(ByVal hCtx As Long, ByVal App As String, ByVal
Db As String, ByVal Calc As String, ByVal CalcDesc As String) As Long<br
/>Dim nResponse As Long<br />Dim sMsgText As String, nMsgType As
Long<br />Dim dCalcStart As Date<br />Dim dNextTry As Date<br
/>Dim sCalcTime As String<br />Dim tProcState As ESB_PROCSTATE_T<br
/> On Local Error Resume Next<br />
myApp.StatusBar = CalcDesc<br /> nResponse =
EsbCalcFile(hCtx, hCtx, App, Db, Calc, 1)<br /> If
(nResponse = 0) Then<br /> '
Asynchronous calc running...<br />
dCalcStart = Now<br /> dNextTry =
dCalcStart + cTenSecs<br /> On Error
Resume Next<br /> Do<br />
Call DontHogTheSystem<br
/> If Now > dNextTry
Then<br />
If Now > (dCalcStart + cTenSecs) Then<br />
sCalcTime =
Elapsed(Now - dCalcStart, False, False)<br />
myApp.StatusBar =
"Elapsed calc time: " & sCalcTime<br
/> End
If<br />
dNextTry = dNextTry + cFiveSecs<br />
nResponse = EsbGetProcessState(hCtx,
tProcState)<br />
If nResponse <> 0 Then Exit Do<br
/> If
tProcState.State <> ESB_STATE_INPROGRESS Then Exit Do<br
/> End If<br
/> Loop<br />
If nResponse <> 0 Then<br />
sMsgText = "Warning - Due to an
unknown (network?) error, this operation could not
continue..."<br />
sMsgText = sMsgText & vbCrLf & "(Ref =
" & nResponse & ")"<br
/> nMsgType =
vbExclamation<br /> End If<br
/> Else<br />
myApp.StatusBar = "Essbase calculation error (" &
Calc & " object)"<br />
sMsgText = "Error - Unable to run "
& Calc & " (Ref = " & nResponse
& ")"<br />
nMsgType = vbExclamation<br /> End If<br />
If nMsgType <> 0 Then MsgBox sMsgText, nMsgType<br
/> RunCalc = nResponse<br />End Function<br
/><br />===================================================<br
/><br />HTH<br />-Doug |
|
Re: who
knows how to monitor the progress of a calculation |
Hi
there<br /><br />Thx for the code.....it put me on to some of the
API functions I was not aware of and in turn has led me to put together the
following VBA which seems to work ok until it reaches "Check Process
State until Done" section where an error is encountered, sts returns
a 1030001 error and so the code just loops continuously.<br /><br
/>Can anyone spot the problem? The code to check the process state
I've actually just copied from the Essbase Help which is partly why
I'm confused that its not working.<br /><br
/>Background: The code is attached to a login form and based on
user input a Calc script may be executed on the server before refreshing a
series of reports within the spreadsheet. I need to know that the
script has finished before refreshing reports.<br /><br
/>[code]Private Sub OkCB_Click()<br /><br />Dim ProcState As
ESB_PROCSTATE_T<br />Dim hCtx As Long<br />Dim strCalc As
String<br />Dim x As Long<br /><br
/>application.ScreenUpdating = False<br /><br />varUser =
UserTB<br />varPasswd = PasswdTB<br /><br
/>Worksheets("Login
Data").range("usernme") = varUser<br
/>Worksheets("Login
Data").range("passwd") = varPasswd<br
/><br />Unload EssBase_Login<br /><br />strServer =
Worksheets("Login Data").range("server")<br
/><br />If loadedCB = True Then<br /><br />x =
EssVConnect("login data", varUser, varPasswd, strServer,
"AOPANS", "ANSAOP06")<br /><br
/> If x <> 0 Then<br /><br
/>MsgBox "Essbase connection failed. Please call |
|
Re: who knows
how to monitor the progress of a calculation |
[quote
author=steve_s link=topic=119.msg577#msg577 date=1137584749]<br />Can
anyone spot the problem? The code to check the process state
I've actually just copied from the Essbase Help which is partly why
I'm confused that its not working.[/quote]<br /><br
/>Sorry, I have to laugh here, it's NOT at you, it's at
hyperion. ;D<br /><br />Essbase's example
routines are a joke, in terms of showing how to use the API. It
barely works for syntax (and often doesn't). So copying
from the help is pretty much the same as writing VBA code by using recorded
macros (except recorded macros at least tend to work).<br /><br
/>My first guess is that you are calling the GetProcessState too quickly
after initiating the calc. It could also be that the context handle
isn't valid at the point of retrieving it, and you don't
hit an error until the attempt to get the state. If you check too
soon, you probably never get into the loop (because you are using
"while = INPROGRESS", and there is a small delay in
"getting that far"). In my code, I use the
initial delay before checking the first time and then exit when the calc is
no longer in progress. This isn't by accident.<br
/><br />This is why I use a timer function to only
"hit" the server once every few seconds... If you
hit it too often, the server will slow things down a LOT while it handles
your requests (picture the kids in the car saying "are we there
yet" over and over, but with you having to slow down a bit to answer
each time). In my experience, asking "are we there
yet" more than once a second can add 10% to the calc time, doing it
repeatedly (without a pause), can cause it to take 10 times longer than
normal, easily. Of course, this all depends on a lot of
factors.<br /><br />I would strongly recommend that you:<br
/>a) Validate the context handle before attempting to use it.<br
/>b) Add a delay in your check loop, 2 to 5 seconds is good.<br />c)
Don't check for it being in progress too soon.<br />d) Take
those samples from the help files with a grain of salt -- scratch that, a
truck load of salt.<br /> |
|
Re: who
knows how to monitor the progress of a calculation |
hmmmmm....ok
point taken :o)<br /><br />Rather than trying to be clever and
creating something myself I'll do what I should have done first time
around and perhaps just modify the code you put up :)<br /><br
/>I certainly hadn't thought about the impact on the server of
the continuous request to check the process state. Will bear that in
mind.<br /><br />Thanks again<br /><br /> |
|
Migration
to ASO - PArtition not Validating |
All
-<br />Here are few problems I am facing:<br />1.I have migrated
my Outline from 6.5.4(BSO) to 7.1.2(ASO).<br />The Dimensions
are:Original BSO dimensions<br />Dimension 1 - Accounts (Dense) - Has
Formulas,DTS,TB Members,Two Pass Calc,Dynamic Calc,Shared Members<br
/>Dimension 2 - Time (Dense) - Has Formulas<br />Dimension 3 -
Scenario (Sparse) -Has Formulas,Two Pass Calc,Dynamic Calc<br
/>Dimension 4 - Sparse<br />Dimension 5 - Sparse<br />After
Conversion to ASO<br />Dimension 1 - Accounts (Dynamic) - Formulas
changed into MDX Expressions<br />Dimension 2 - Time (Dynamic) -
Manually Changed to Dynamic<br />Dimension 3 - Scenario
(Dynamic) - Manually changed to Dynamic to support formulas<br
/>Dimension 4 - Multiple Hierarchies Enabled<br />Dimension 5 -
Multiple Hierarchies Enabled<br />To Enable DTS,Time Balance,Two Pass
Calc and to support Write Back I have partitioned the ASO as Source and BSO
as Target.<br />Now my issues are:<br />1.Do I have to Partition
along all the 5 dimensions or is it enough to partition across the first 3
dimensions.(I have partitioned only along the 3 dimensions to support for
TB,Two Pass,Dyn Calc....)<br />2.When I try to Validate the Partition I
get Warnings and the Account Dimension members as mismatching.<br />It
says: Validated with Warnings -<br />BSO Target [83,62,44,]; Members
[Dim1,Dim2,Dim3]<br />ASO Source [72,62,44,55,77] The numbers are the
members in the 5 dim respectively.Why is there a mismatch in members of
Account dimension in ASO and BSO<br />3.I guess I have to load the data
into ASO,but since 3 of my Dimensions with formulas are in the Partitioned
BSO DO I have to Calculate as well as Aggregate both BSO and ASO?<br
/>Please throw some light on these issues.<br />Thanks in Advance<br
/>Jeeva |
|
Re:
Migration to ASO - PArtition not Validating |
1. The
number of dimensions to include in the BSO cube depends on your analytic
needs. As you are including just dimensions 1 to 3, I assume that you do not
need to perform any analysis on dimensions 4 & 5, and all you need
for those dimensions are their totals.<br /><br />If this is the
case, the partition is correct. But if you need to perform analysis tasks
over dimensions 4 & 5, you need to consider them in the
partition.<br /><br />2. My best guess for the cell count mismatch
is that you are defining dimensions 4 & 5 as part of the partition
area. In this case, you need to define just the top of the dimension, not
members of those dimensions. And as you do not have those dimensions on the
BSO cube, you will need to map them to void.<br /><br />3. If
there is still any cell count mismatch, you should review the partition areas
defined for the 3 dimensions, to see if these are equivalent or not (like a
difference in the number of members).<br /><br />HTH |
|
Memory
Error |
All
-<br />I have encountered this Error message today -<br
/>" There is not enough of memory in the Essbase Administration
Server to open the Outline".<br />I was also encountering
Weird stuff in EAS today.Unable to do anything,the system was hanging and was
doing nothing.<br />I have checked the Server memory and it had some
14765434 KB of Unused memory available.<br />I even tried to STOP and
START the SERVER but to no use.<br />Please let me know if there is any
work around involved in solving this problem.<br />Thanks in
Advance,<br />Jeeva |
|
Re:
Memory Error |
Many
times, the reason an outline cannot be opened has more to do with the
"temp" path on the client than anything else.
This is where the application manager stores the working file when you open
an outline for editing. To do this, it needs a string to point to
the temp file, and some versions of Essbase don't provide a large
buffer to do this. I've seen the "out of
memory" message when the "Temp" path is as short
as "C:\Windows\Temp" -- how much room is available appears
to be dependent on the client installation itself (so it only affects a few
people in the version that this happens...). It used to be that all
windows versions used the same temp path for all users,
"C:\Temp", then they got the idea to change it to be a
directory under windows, so it's "part of the
system" so to speak... Finally, they made it part of each
users profile, and suddenly, the path to the temp variable became very long
-- "C:\Documents and Settings\<user
name>\Temp" or even longer. This is where Essbase
started seeing this problem.<br /><br />Okay, so to fix it:<br
/>- Create a directory called "C:\Temp" (it may already
exist)<br />- Right click on "My Computer" and select
properties, then select the "Advanced" tab (this
varies...)<br />- Press the "Environment Variables"
button<br />- Look for a "User" variable called "Temp",
and change it to "C:\Temp" (or similar)<br />- Log
out, log back in<br /><br />The (not so) funny thing is that
Windows is SUPPOSED to dynamically increase the space for environment
variables, so there must be something else that could address this, but this
approach is the easiest way, so I haven't tried to find any
others.<br /><br />Semi-related Note: If there are a large number
of files in the temp directory, you can try deleting some older files with the
"tmp" extension. Don't try to delete
anything from the last time you logged in, though. When there are
too many files, it can make Windows a bit sluggish.<br /> |
|
Re:
Memory Error |
The
Version I am using is 7.1.2 and this is happening in EAS.THis is on a Sun OS
box.Will the solution work for this toooo?<br /><br
/>Thanks,<br />Jeeva |
|
Re:
Memory Error |
If will
apply if the client is windows, and has little to do with the server
environment. For instance, the server could be on V7.x, and if the
client is a v6.1 client, I can be fairly sure that a long path has the
*potential* to see this problem. I don't know for sure if
this problem exists with a V7 client, but we used Unix and AIX boxes and had
this issue (like I said, it's not the server's OS that does
it).<br /><br />Worst case: try the change, if it
doesn't help, let me know -- and revert the path back to the old
setting.<br /><br />HTH<br /> |
|
Re:
Memory Error |
As said,I
have changed the path to C:\Temp, but still the same problem.<br />And
moreover when I try to do something else other than opening the outline the
system is freezing.<br />I am able to open the Outline in View mode but
not in Edit mode.<br /><br />Please help.<br /><br />Thanks,<br
/>Jeeva |
|
Re:
Memory Error |
Hmmm, the
symptoms *sound* like they are the same -- open for edit fails while open for
query only doesn't. This is usually a good indication that
the client is unable to create the temp file used to store the local copy of
the outline (or any other object).<br /><br />However, we could
be barking up the wrong tree, but other than the "Temp"
variable, I am not aware of any issues that create this situation.
Just to be clear, could you drop down to a command shell and type in
"set Temp" to confirm the value? If it's
short, I'm out of ideas.
:(<br /> |
|
Re:
Memory Error |
In the
command promt I get -: <br /><br />TEMP = C:\Temp<br
/><br />Will Uninstalling EAS Client and re-installing it ,will
work?<br />I am on Windows NT. |
|
Re:
Memory Error |
I
don't have any other ideas, and although I hate to give that
"default answer" -- it isn't likely to hurt.<br
/><br />Perhaps Gary has run into this one, or somebody else on
Network 54 or Hyperion Developer Network.<br /><br />Whatever you
do find out, let us know, okay?<br /><br />Good Luck. |
|
Re:
Memory Error |
I am not
sure if this is a Windows Client issue or the Server issue,because I checked
to open the outline in other machine I get the same Error.I have opened a
Ticket with Hyperion,lets see what they come up with.<br /><br
/>Thanks,<br />Jeeva |
|
Re:
Memory Error |
Hi
-<br /><br />Atlast I was able to resolve the memory issue.Did
nothing but rebooted the Essbase Server,Admin Sever and EAS Server.I get no
Error.<br />But now I am facing a new problem which is :<br
/><br />The issue is we have few Analytic Servers namely:<br
/><br /> <br /><br />Dev 1<br />QA 1<br
/>DEV2<br />QA2<br /> <br /><br />The issue is we
are unable to connect to the Servers from EAS Console.<br />I am not
sure if this has to do with OS enviornment because I have installed EAS
server and EAS client on Windows XP and its working fine.<br />All the
above 4 servers are on Sun Solaris where the actual problem is.<br
/>Please let me know if you have any details of it.<br /><br
/>Thanks,<br />Jeeva |
|
Essbase
6.5.3 and 7.1.3 in the same UNIX maschine |
Hello,<br
/><br />before I start to experiment with this issue, I want to ask
if anyone has experience with running 6.5.3 and 7.1.3 on the same server?
E.G. how can I give them different names to distinguish them in EAS? We use a
UNIX Sun Solaris 5.8 Server.<br /><br />Thanks in advance!<br
/><br />Michael |
|
Ranking
and Dynamic Members |
Does
anyone know if the @RANK function be used on dynamic members? I am trying to
run the following and getting no results (brackets indicate a dynamic
member)<br /><br />"Rank" = @RANK(SKIPBOTH,"Product"->[QTR3]->"[%
to
Goal]"->Manager->Sales,@RANGE(Product"->[QTR3]->"[%
to Goal]"->Manager->Sales,@DESCENDANTS("Cost
Center")));<br /><br />I have never used @RANK before so
I am sure I must be missing something obvious. I have no idea on the
dense/sparse implications if any and am still a bit fuzzy on what @range is
doing for me in this instance. Was hoping someone could spot something for me
so I can avoid wasting a perfectly good Friday on this!<br /><br
/>If this helps:<br /><br />Qtr3 - Dense (dynamic -
time)<br />Sales - Dense (accounts)<br />Rank - Sparse<br
/>Product - Sparse<br />% to Goal - Sparse (dynamic)<br
/>Manager - Sparse<br /><br /><br />Thanks |
|
Re:
Ranking and Dynamic Members |
Thanks
Mark - confirmation that it was possible was just what I needed.
<br /><br />I still could not get mine to work for a
while. At first I thought it may have been a block creation issue but
that wasn't it. What I finally found was that if I have a
sparse being set equal to rank AND I have a dynamic member in my rank
calculation I get #MI/no results. However if I rearrange to have a
dense member being set equal to my rank OR I take out all dynamic members out
of my rank it works fine. Go figure - I am sure there is a good reason
for this somewhere but I am moving on for now.<br /><br />Again -
thanks for your help |
|
Re:
Ranking and Dynamic Members |
Hi
Cleg,<br /><br />Good news, yes the @RANK functions can be used
within a dynamic member. Bad News, retrieval times are really
bad. Recreated this on our Management Accounts Db (Cost Centre=300
members) and if I was quick could have made a cup of tea/coffee!<br
/><br />This is the example i used:<br /><br
/>[code]<br />@RANK(SKIPBOTH,"Total
Income"->"Qtr1"->"Act"->"Yr2005",@RANGE("Total
Income"->"Qtr1""->"Act"->"Yr2005",@DESCENDANTS("Organisational")));[/code]<br
/><br />The results of this were sort of right, but you might want
to tinker with how you select Cost Centre members.<br /><br
/>With "% to Goal" being dynamic you might want to set
the member to 2-Pass. But I imagine this will extend retrieval
times further. I don't know what's your outline
is, but you might want to move "Rank" into your Accounts
Dimension and have a Branch called KPI or RANK and set it to tilda (~) so the
figures don't aggregate through. Only a suggestion.<br
/><br />Hope this helps, look forward to seeing how you get
on.<br /><br />Regards<br /><br />Mark |
|
Re:
Ranking and Dynamic Members |
Glad I
could help<br /><br />Mark |
|
Hyperion
Essbase User Guide? |
Hello <br /> <br />I've a
question: Where is the 1.Essbase Users guide 2.Essbase
Adimistrative Service help guide(not online) in the
Hyperion Tech Doc's ?<br /><br />Hyperion Tech
Docs: http://dev.hyperion.com/resource_library/technical_documentation/<br
/><br /><br />Thanks<br /> |
|
Re:
Hyperion Essbase User Guide? |
[color=Blue]The
Hyperion Essbase docs are in the software. Under the information
roadmap.[/color] |
|
UnknownHostException
- where is Analyzer setting file to change this setting? |
Hi,<br
/>I have installed Analyzer 7.1 and on Analyzer server Windows computer
Analyzer java web client works fine - without problems.<br /><br
/>But on the ordinary computer only having JRE installed (Windows
operating system) it reports the error: "An unknown exception
occrurred while communicating with server. Nested exception is:
java.net.UnknownHostException: olap"<br /><br />The name
of Analyzer computer is "olap" so on local Analyzer server
computer Analyzer java web client works fine. But on remote computer
doesn't find "olap".<br /><br />Work
around solution is to add "name to ip" conversion in
c:\windows\system32\drivers\etc\hosts file on each end user computer, but
this is very time consuming task.<br /><br />I supose there is
some setting file on Analyzer computer where 'hosts' are
defined. But I just can't find the correct setting. Where can this
host be changed?<br /><br />Thanks,<br />Grofaty |
|
Going
from 6.5.4 to 6.5.7-Any issues? |
Plan on
upgrading from Essbase 6.5.4 to 6.5.7 on both client & server. <br
/>Primary reasons are Excel 2003 on clients and Windows 2003 on the
server. <br /><br />How much testing should be done to ensure
everything works? <br />Appreciate comments & feedback from any
one who has done this. <br /><br /><br /><br
/>Regards,<br />Tom M.<br />tmonahan@hotmail.com<br
/>Essbase 6.5.4<br /> |
|
HFM
Application Back Up |
I'm
new to HFM. How do you back up an application in HFM? Is
it the same as Hyperion Enterprise wherein you just copy and paste the
application? ???<br
/><br />Thanks! |
|
Re: HFM
Application Back Up |
That
would be nice! No is the short answer.<br />HFM is a different beast,
and the backup needs to be done part of the DBA/IT routine. i.e., you would
need to request a backup of the SQL/Oracle (whichever you use)
schema(s).<br /><br />Enterprise, as you know has folders and
files - HFM is a relational database made up of a lot of tables, so DO NOT
fiddle :) Your Hyperion Infrastructure contact should be able to advise on
you specific environment.<br /><br />There are ways of migrating
from Enterprise, and doing 'soft' backups which
would enable you to do an auto reshell rather than restore from the backup.
Here is a link you may find useful: [url]http://pgww.com/Solutions/Solutions.asp[/url].
There may be others, so look around.<br /><br />Hope this helps. |
|
Re: HFM
Application Back Up |
Thanks
ng. I'll talk to our Hyperion IT support. |
|
Analyzer
error |
Hello,
<br /><br /> I have a user who is using Analyzer 6.5 on
XP Professional. He just installs several MSFT security patches on his PC and
he get this error when trying to run the Java client "The program
C:\programfiles\Internet Explorer\iexplorer.exe caused a problem and is going
to close. Would you like to save a dump file?". This error
automatically closes the Java client. What reason does this cause?<br
/><br />Thanks,<br />EB ??? |
|
One for
HFM - Renumber Web Forms |
This
utility is for renumbering the rows in Web Data Entry Forms.<br
/><br />Normally, if you insert or delete a row in a webform, you have
to manually renumber all other rows. To identify a webform row, it looks for
lines starting with Rxx= (where xx is a number). As long as any inserted rows
have this prefix, it will renumber all rows correctly.<br /><br
/>This does not require an active connection to HFM. Installation does
however require Microsoft .net Framework v1.1<br /><br />Once
installed, there are instructions.<br /><br />It can process many
files at once. Feel free to use it if you find it useful - appreciate
feedback. |
|
How to
import column reports |
Is there
any way for me to create rows in a grid but have different choices for the
column. Like being prompted for a column template. The
choices may have different dimensions.<br /><br />In Enterprise
Reporting, we have the capability to import column reports but in Hyperion
Report, both row and column dimensions should be laid out.<br /><br
/>Please help. The reports won't be as dynamic as the
ones in Hyperion Enterprise.<br /><br />Thanks! |
|
Re: How
to import column reports |
I
don't think Hyperion Report can meet your requirement
directly.<br /><br />Can you add a dynamic calculated member of
another dimension named "Header" ( or something
else), write the formula in outline.<br /><br />IF
(@ISMBR("measure1"))<br />
measure1 condition1
constraited;<br />ELSEIF (@ISMBR ("measure2"))<br
/>
measure2 condition2 constraited;<br />ENDIF<br /><br
/>Put the member "Header" on the grid dimension layout -
columns. Hope it can help you. |
|
More bad
news about clustering and server names |
Not sure
if it's just me but it appears that once you have a cluster and
server, you can't change that. We moved our Oracle
repository from schema to another, then installed HFM on a new
server. When HFM config is launched, it does not allow us to change
the server / cluster. <br /><br />Has anyone else done
this, if so did it work? |
|
Re: More
bad news about clustering and server names |
It was
just me! :o |
|
Supress
Rows for negative data. |
Hello,<br
/><br />I have one report in which I have to subtract 2 columns (say
A & B) and show the value in column(say C). I want to supress all the
rows for which there are negative values in column C ... This is not working
for me.<br /><br />Then I need to calculate the percentage of C
compared to A . Now there might be ZERO or MISSING Values in column A and the
division by these gives error. Is there anything I can do to replace these
values so that division does not gives errors.<br /><br />I have
tried to use conditional supression but it does not works for me. I have only
few rows in the report which expand ( I am using lists for different levels)
and I need to supress these rows for missing data. But when I remove the
basic supression and add the conditional in additional supression, the report
just stops working and stays in a loop for a long time.<br /><br
/>Any suggestions....? It would be a really great help.<br /><br
/>Thanks<br /><br />Monu <br /><br /> |
|
Workaround |
Use
conditional formatting to replace the cells in the row with no value, then
use row suppression to suppress rows with no data.<br /><br /> |
|
Re:
Supress Rows for negative data. |
Gary,<br
/><br />That's a good suggestion . I tried it but this is
not working for me.<br /><br />As far as I understand ,
formatting (conditional or normal) is applied on the report after all the
data retrival and calculations are done. So If I replace the values using
conditional formatting, they are not considered in the calculation and the
division by ZERO or MISSING values would still show error on my report.<br
/><br />About condtional supression, I had basic supression (on missing
values) on the row. Now when I change the supression to supress rows if
A>B or for "NO DATA" in current row, the report just
takes forever. With basic supression , the report is generated in 5 secs and
with conditional supression for NO DATA , the report ran for like 5 minutes
and I had to cancel if eventually.<br /><br />Thanks |
|
Re:
Supress Rows for negative data. |
If
possible, I'd suggest just adding a dynamic calc member to the
Essbase cube that calculates a value for C for you, substituting the result
with #MISSING if it is negative. My apps tend to be peppered with
these sorts of artificial sweeteners for reports. ;D |
|
Re:
Supress Rows for negative data. |
Try using
Reference Property Arguments (IfNonNumber) in your expression.<br
/><br />That should fix your problem<br /><br
/>Hyperion49 |
|
Word Wrap
in Hyperion Reports 7.2.1 |
I
can't find Word Wrap in the View Menu. The User Guide says
it should be in the View Menu, I don't see all the items in the View
Menu. Should we change the Hyperion Report set up?
???<br />Thanks in advance :) |
|
copy
application |
We use
Essbase V6.5.3 and I was wondering if there is a way to copy an application
from one server to another with all of the filters and users/with privileges.
I will appreciate any comments and feedbacks.<br /><br
/>Thanks<br />Sibel<br /><br /> |
|
Re: copy
application |
You
cannot default copy apps and databases easily server to server with the
native tools.<br /><br />The only thing I have found, without
doing exports and recreating everything on the new server (i.e. dev to
production) is OSE from Technolab Corp (approved Hyperion partner). Have a
look on their website. This is not meant as an advert.... but I have not seen
a way to interact off site.<br /><br />If you find anything else,
or others have something, lets hear it. |
|
Re: copy
application |
Migrate
the apps using EAS migration wizard. EAS allows you to migrate
applications from server to server. Users, Groups, and filters are
migrated with the application. |
|
Page Axis
Memebers not showing |
Hello,<br
/><br />I have 3 members in my page dimension. Logically the report
should show a drop down box with three options. For some odd reason , only
one options is being showed in the drop down box and when i looked carefully,
i found out that all the data for all 3 members is being shown on one
page(with one memeber) only.<br /><br />Any suggestion as to why
this might be happening??<br /><br />thanks a lot |
|
Re: Page
Axis Memebers not showing |
Did you
select the 3 members in ur page dimension? |
|
Re: Page
Axis Memebers not showing |
Yes I did
selected the 3 members in page dimension.<br /><br />Now if i
look carefully, the data for first 2 members in showing up in the first
selection, data for 3 member is showing in second selection and for 3
selection there is no data on its page.<br /><br />I have
actually larger reports which shows detailed level data. The page dimension seems
to be fine but whenever i enter my last row for detail data( this row
expands), everything blows out and the data appears on different pages for
other members.<br /><br />I have no clue as to why it is showing
this erratic behavior.<br /><br />Thanks a lot for looking into
this !!! |
|
Partitions
in 7.1.2 ASO |
Hi All
-<br /><br />I have created a partition in ASO 7.1.2.<br
/>We have total of 7 dimensions.I have created a Transparent partions with
3 dimensions in BSO which are partitioned .<br />My questions is:<br
/>1.Do I load to ASO database?<br />2.Do I Aggregate the ASO as well
as Calculate the BSO? (I have few formulas in BSO dimensions which are
partitioned)<br /><br />Please let me know.<br />Thanks in
advance.<br /><br />Jeeva |
|
Choosing
Active Directory after availability |
Hi!<br
/>In our environment we have several active directory machines. For our
planning application we use external authentication which is hardcoded in a
css.xml file.<br /><br />What has happened is that our
outsourcing partner sometimes remove some of the servers from the network for
a period and then bring them up again. Does anybody have a clue how to code
this in the css.xml file so that the lookup is made to several active
directories if the first one is not available?<br /><br
/>Thanks,<br />Erik |
|
Re:
Choosing Active Directory after availability |
Not sure
how to do exactly what you are looking to do, but I believe if you install
Hyperion Hub, you can configure HUB to scan multiple Directories.
Then you just point Planning to the HUB config and it should work. |
|
Re:
Choosing Active Directory after availability |
The CSS
XML file can contain multiple providers. <br /><br />If you
include all MSAD providers in the XML file, and then configure the search
order as required, each provider will be searched in the specified
order.<br /><br />FYI: When using multiple providers, be aware
that if a user exists in more than one provider with a different password,
the first occurance of that user is the one against which the login will be
authenticated.<br /><br />Also, you should use Hub if you have
more than one product using External Authentication, i.e. Analytic Server
& EAS.<br /><br /> |
|
ERROR or
DESIGN? FIX on subset of FIX |
Is this a
known restriction / bug / design feature? (Essbase 7.1.3)<br /><br
/>Trying to use a nested FIX on a subset of a previous FIX has no effect
... and the original set holds.<br /><br />Eg: from
Sample.Basic<br /><br />Add an Account "Test1"
... then create a calc script like:<br /><br />FIX( @RELATIVE(
"Product", 0 ) )<br /> FIX( @RELATIVE(
"East", 0 ) )<br /> FIX( @MATCH(
"Market", "New *" ) )<br />
"Test1" = "Sales" /
"Ending Inventory" ;<br />
ENDFIX<br /> ENDFIX<br />ENDFIX<br /><br
/>You'll find it calcs for all of the Children of EAST, when
logic says it should only be for "New York" and
"New Hampshire" - and, no, it doesn't seem to
matter if you swap @MATCH for something else. Yes, an "AND"
works on the same FIX but I'm really questioning the situation where
they are nested.<br /><br />I don't recall this
behaviour but that doesn't mean it hasn't always been
there!<br /><br />Thanks. |
|
Re: ERROR
or DESIGN? FIX on subset of FIX |
I guess
it depends on who you ask? A Hyperion loyalist would probably say
it's a feature.<br /><br />In some ways I guess it makes
sense since you have already locked the block @RELATIVE(
"East", 0 ), at that point it doesn't seem to be
able to slice out another piece. As you mentioned, you could use
the AND. You could also nest an IF which would allow you to
evaluate the block you locked.<br /><br /> |
|
Re: ERROR
or DESIGN? FIX on subset of FIX |
It
appears that "nested" FIX's only add to the Set of
Members, and never subset it.<br /><br />I suggest this is
illogical. Though I accept the corollary to your premise that it makes
programming more simple for Hyperion. But I've never accepted that
ease of programming is always the right solution.<br /><br
/>I've been 20 years working in a variety of multidimensional
tools, and 10+ with Essbase - I've never been a loyalist to a
product or vendor. :) <br /> |
|
Re: ERROR
or DESIGN? FIX on subset of FIX |
Since
version 3.x, nested fixes were documented as an intersection, not a union. So
this behavior would represent a change from the past, and a dangerous one at
that. I cannot remember which version it was fully tested in, but we did go
through a significant effort to validate the nature of nested fixes, and our
conclusion was that it was indeed an intersection selection, as any software
developer would naturally assume.<br /><br />The logic is simple,
and has meaning from a design perspective as follows -- if you wanted to extend
beyond the currently selected partition of data, you would need to create a
new fix, instead of nesting it. Logically, adding new selections to the
current fix (a union) would "invalidate" the outer fix, and
has no meaning syntactically as inclusive selections are part of the current
fix syntax already. Another way to look at this is as follows -- If you
nested selections on *different* dimensions, the nested fixes are an
intersection, etc...<br /><br />Therefore, this is either a bug
or an unannounced design change -- and if this were a design change, they
would have had to announce it with significant fanfare, since it's
not backward compatible.<br /><br />-DougB<br />PS: I
believe it was version 4.1, where the tests were done, and I've
coded nested Fixes through version 6.5 without noticing this behavior, so
I'm left wondering how many bizzarre issues this may or may not
account for...<br /> |
|
Re: ERROR
or DESIGN? FIX on subset of FIX |
I can
concur that I've seen this behaviour too in at least 6.x in code
such as:<br /><br />[code]FIX(@LEVMBRS("Market",
0))<br /> /* do something for every Market */<br
/> FIX (@REMOVE(@LEVMBRS("Market", 0),
"New York"))<br /> /* do
something for every Market except New York */<br /> ENDFIX<br
/>ENDFIX[/code]<br /><br />So if it's not
[i]always[/i] true (which is possible), then it's at least true in a
variety of cases.<br /><br />I can even recall seeing the member
I thought was excluded appearing in the selection list that appears in the
application log, which was rather eye-opening. |
|
Re: ERROR
or DESIGN? FIX on subset of FIX |
I would
generally only use multiple fixes like that in order to grab different
sections of different dimensions. Since you are ideally getting
down just to two members why would you want the overhead of multiple fixes
anyway?<br /><br />The behavior that bothers me more is that when
a FIX results in an empty set it just ignores the fix and calculates on
everything. THAT is dangerous! |
|
Re: ERROR
or DESIGN? FIX on subset of FIX |
Well,
it's been one of those long-standing pieces of received wisdom that
it's generally good to FIX early and often rather than trying to fix
on everything you need in one go. Besides, the original script does
a good job of expressing the author's intention -- if you imagine
there's more to it than just that one assignment, a reader could
look at it and think "OK, this stuff applies to this range, that
makes sense... and this stuff applies to a subset of that range... and I can
see at a glance exactly what range of members is being deliberately excluded
from this part of the calculation".<br /><br />On the
latter point - just as well Essbase 9 fixes it, eh? ;) |
|
Re: ERROR
or DESIGN? FIX on subset of FIX |
FYI<br
/><br />Hyperion have accepted this and the "empty
fix" error (not corrected in 7.1.5 contrary to documentation) as
defects. <br /> |
|
HINT: Fix
on children of parent |
The
Entity dimension design of my current client has an input member at each
level of the hierarchy. Data changes made to these members can affect /
over-ride values in the bottom level children of it's parents
branch; so you want to calculate all the lowest level members that are
affected. <br /><br />Following??<br /><br
/>[code]<br />Country<br />--Country Input<br
/>--State<br /> |--State Input<br />
|--City<br /> | |--City Input<br />
| |--Shop1<br /> | |--Shop2<br
/> |--City2<br /> | |--City2 Input<br
/> | |--Shop3<br /> |
|--Shop4<br />etc<br />[/code]<br /><br />You
may have a form (this is Planning, obviously) on, say, State Input and it
affects all the Shop1...4. Unfortunatly you cannot use a @PARENT in a FIX ...
but you can use @RELATIVE ... so if want to do this you use:<br
/><br />[code]<br /><br />@RELATIVE( @RELATIVE(
[Entity], -1 ), 0 )<br /><br />[/code]<br /><br />The
inner @RELATIVE goes to the level 1 parent of the input (level 0) member, the
outer one goes to all the level 0 descendants of that parent. <br
/><br />Problem solved. :) <br /><br /><br
/><br /> |
|
Re: HINT:
Fix on children of parent |
Nice Tip,
Chris... I rarely use Planning myself, but this is just one more example of
being use to the "good life" with Essbase, being able to do
things the easy way. :)<br /><br />Thanks++<br /> |
|
Aggregation
design wizard in ASO |
Does
anyone have insight as to how to use "Aggregation design
wizard" in ASO to optimize retrieve performance? I have
been using "query tracking" to create recommended aggregate
views- but no matter how many queries are run, I only get 4 aggregate
views. Is there a way to increase the number of aggregate
views? Also, is there a way to control what dimensions get
aggregated. Any other tips will be appreciated.<br
/>Thanks.<br /> |
|
Re:
Aggregation design wizard in ASO |
A way to
increase the number of aggregate view is using the MaxL command
"execute aggregate process" with "stoping when
total_size exceeds" option...<br />However it is not possible
to have control of what dimensions get aggregated.<br /> |
|
Re:
Aggregation design wizard in ASO |
Oh, that
will not work as well as the new "Query_Tracking" option -
which will allow me to target aggregated views creation based on what users
pull into Excel. <br /> |
|
Space in
Substitution Variable Member |
Good
morning everyone,<br /><br />i am using Essbase 7.0 and Hyperion
Business Rules 3.5.1. My problem is that i cannot use a substitution variable
in calculation scripts when the underlying member name contains spaces. For
example, the substitution variable CurrVer corresponds to member name
"1st Submission" (without the double quotes). Every time I
try to make a cross-dimensional reference of fix using this substitution
variable, I get an error.<br /><br />e.g.<br
/>"Value Index" = "Performance
Index"->&CurrVer;<br />or<br
/>FIX(&CurrVer)<br /> (error: operator expected after
[1])<br /><br />Does anyknow know a way to overcome this
problem?<br /><br />Thank you in advance,<br />Dimitris |
|
Re: Space
in Substitution Variable Member |
This is
easily fixed - you need to include the double-quotes in the substitution
variable's value. |
|
Re: Space
in Substitution Variable Member |
Ben,
thank you very much for your immediate response. I've tried what you
suggested and it works fine.<br />The only side effect is that I cannot
use the same substitution variable in my reports any more, but I can have two
variables, one for Hyperion Reports (without double quotes) and one for
Business Rules (including double quotes).<br /><br />Best
regards,<br />Dimitris |
|
Assign
different access priveledges to combination of dimensions |
Good
afternoon everyone,<br /><br />I have an application in Hyperion
Planning 3.5. Two of the application dimensions are Accounts and Products.
Let's support that User Group1 and User Group2 are two different
user groups, Account1 and Account2 are member of the Accounts dimension and
Product1and Product2 are member of the Products dimesnion. What I want is to
assign different priviledges to specific user groups (not users) based on
combinations of members of these two dimensions.<br />For example, User
Group1 must have read access to the combination of Account1 and Product1 and
write access to the combination of Account1 and Product2, while User Group2
must have write access to the combination of Account1 and Product1 and read
access to the combination of Account1 and Product2.<br /><br
/>Thank you in advance,<br />Dimitris |
|
Re:
Assign different access priveledges to combination of dimensions |
No,
it's not possible, but there are a couple of things you can do to
fake it in certain cases. To illustrate:<br /><br
/>(E1, E2 and E3 are entities; A1, A2 and A3 are accounts.)<br
/><br />Let's say you want to grant this sort of access (R
= read, W = write):<br />[table]<br
/>[tr][td][/td][td][b]E1[/b][/td][td][b]E2[/b][/td][/tr]<br
/>[tr][td][b]A1[/b][/td][td]R[/td][td][/td][/tr]<br />[tr][td][b]A2[/b][/td][td]
[/td][td]W[/td][/tr]<br />[/table]<br /><br />So
you'd need to grant READ to E1, READ to A1, WRITE to E2 and WRITE to
A2. But this gives you this:<br /><br />[table]<br
/>[tr][td][/td][td][b]E1[/b][/td][td][b]E2[/b][/td][/tr]<br />[tr][td][b]A1[/b][/td][td]R[/td][td]R[/td][/tr]<br
/>[tr][td][b]A2[/b][/td][td]R[/td][td]W[/td][/tr]<br
/>[/table]<br /><br />This might not be hugely disturbing,
because at least it doesn't let people write where they
shouldn't, but it gets much worse as the number of areas that must
be written to starts to grow.<br /><br />There's no
universal work-around, but one idea is to use dynamic calc accounts to
provide limited read access:<br /><br />[table]<br />[tr][td][/td][td][b]E1[/b][/td][td][b]E2[/b][/td][td][b]E1*[/b][/td][/tr]<br
/>[tr][td][b]A1[/b][/td][td][/td][td][/td][td][/td][/tr]<br
/>[tr][td][b]A2[/b][/td][td][/td][td]W[/td][td]R[/td][/tr]<br
/>[tr][td][b]A1*[/b][/td][td][/td][td]R[/td][td]R[/td][/tr]<br />[/table]<br
/>(Grant WRITE to E2, WRITE to A2, READ to A1*, READ to E1*)<br
/><br />This uses a couple of dynamic calc members (A1* and E1*)
which just evaluate to the real A1 and E1 members, but returning #MISSING in
the unwanted E1*->A2 and E2->A1* cases.<br /><br
/>If anyone has [i]any[/i] better ideas I'd be very grateful. |
|
application
manager window disappears |
Hi
everyone,<br /><br />Does anybody know under what circumstances
the app manager window will disappear suddenly. This happens to us very often
and I don't know what can cause this. I will appreciate any comments
and feedbacks.<br /><br />Thanks<br />Sibel |
|
Re:
application manager window disappears |
I
haven't seen this reported elsewhere, in this large company, we have
at least 50 people that regularly use the application manager on both Windows
2000 Pro and Windows XP -- and a sudden crash of the application manager
hasn't been brought to our attention yet.<br /><br />Are
you running any "unusual" task tray items?
Perhaps a "non-typical" anti-virus, user manager (i.e.
Citrix) or remote control software?<br /><br />Seems rather
strange...<br /> |
|
Re:
application manager window disappears |
I had
this happen regularly using 6.5.x App Manager across a broadband VPN to a
client site, and reading a sizeable outline file. Solution was to use a
remote desktop "closer to the action". I never bothered
chasing up the exact cause.<br /><br />Does this come close to
your scenario?<br /><br />Have you tried the EAS console? <br
/><br /> |
|
Re:
application manager window disappears |
Yes,<br
/>I guess when you are trying to open a very big Outline app manager
closes automatically.As Chris said try to open this using EAS which should be
stable.<br /><br />Thanks,<br />Jeeva |
|
Re:
application manager window disappears |
Could be
a RAM issue--<br />Does it happen on a machine with alot of RAM?<br
/><br />Eric |
|
Re:
application manager window disappears |
This
happens on a regular basis here. <br /><br />If you
attempt to open an outline and then focus is removed from app manager, app
manager just shuts itself. I usually have to turn off my email and
instant messaging alerts as it can be very frustrating. It does not
appear to be related to outline size. Any outline will
do. We just put it down to an App Manager
"feature" (we use v6.5.3).<br /><br />We have
not had this problem since moving to EAS, but EAS also has some little quirks
too. <br /><br />Sorry that I could not offer any
solutions to the problem just added some observations. |
|
Re:
application manager window disappears |
App
Manager 6.57 on Win XP Pro with 1 Gig RAM over LAN to Essbase 7.X on
Linux. We build several cubes using the same metaoutline (same
design) against some different sets of data resulting in similar cube designs
with varying size. It seems like opening the larger outlines
consistently crashes App Mgr.<br /><br />We switched back to App
Mgr from EAS after EAS started randomly changing our compression settings. |
|
Is Visual
Explorer free? |
We will
be upgrading to 7.1.x from 6.5.4 in the next few months. In getting familiar
with the upcoming migration, I have been reading about the new Visual
Explorer add-on that is a part of the Excel add-in. Is this tool free? Is it
installed by default? I have looked through the install guide and I see that
Visual Explorer is listed as a "new feature" for release
7.1.<br /><br />In a webcast I watched on the Hyperion Dev
Network (http://dev.hyperion.com/webcasts_demos/webcasts/) it was not
clear.<br /><br />Anyone?<br /><br /> |
|
Re: Is
Visual Explorer free? |
Visual
Explorer is an additional fee item. It is pre-installed with the
Excel add-in, so you will see it on the Essbase menu, but you will not be
able to use it unless your license file grants the appropriate permission. |
|
Combining
Grid Pages |
I have a
report with 2 grids which require the users to select a series of dimension
members. Currently the end user is required to enter the members in for each
grid. Is there a way that each grid can read the initial prompt values
inputed by the user ILO the user being prompted second time to enter the same
value? ??? |
|
Re:
Combining Grid Pages |
You're
not able to reference a prompt from one grid to another. It used to
be that you couldn't reference a prompt from one row to another in
the same grid, but tankfully they fixed that. The work around is to
use the point of view. |