| Subject | Date Asked | Expert |
|
| Web Analysis connect to MSAccess | 2/12/2009 | Todd Binenstock |
Q: Is is possible to set up a dataconnection to MSAccess (relational Database) from Web Analysis? I ...
A: In short, the answer to your question is yes. You should be able to connect to Access as a ...
|
| Hyperion Essbase Fails to Launch | 2/7/2009 | Todd Binenstock |
Q: I am a relatively new user of the Hyperion Essbase tool, which is an add-in within my Excel. I am ...
A: Shelly, Office 2007 periodically disables addins. This is apparently some sort of security ...
|
| Essbase Cube slice copy by day | 1/15/2009 | Todd Binenstock |
Q: I am new to Essbase and I need some advice. My cube has a version dimension with 6 members: ...
A: You can use Windows (DOS) Batch commands to extract the day of the week from the date and generate a ...
|
| Half Year to date | 10/31/2008 | Todd Binenstock |
Q: Hope you are doing well.I wanted to ask you is there any way to calculate Half Year to date data. I ...
A: There is a HTD (Half Year to date) option in dynamic time series in Essbase. Remember that DTS ...
|
| How to restart Essbase server using unix. | 10/31/2008 | Todd Binenstock |
Q: I was able to shut down the Essbase server using MAXL in the unix scripts.Similarly i want to start ...
A: Unfortunately I don't have direct access to a Unix box right now. The normal startup script which ...
|
| Automatic Retrieval In Multiple Sheets By Using Macro | 10/2/2008 | Todd Binenstock |
Q: In My report I need to do retrieval in multiple sheets. I want it to be done by writing a macro. Any ...
A: The Essbase Spreadsheet Toolkit includes macro functions to do retrievals. Look specifically at ...
|
| Essbase Projections | 9/26/2008 | Todd Binenstock |
Q: I am working on Essbase system 9.Is there any built in function in essbase to project or forecast ...
A: Amit, the function in Essbaes that allows such calculations is called the cross-dimensional operator ...
|
| Essbase Projections | 9/24/2008 | Todd Binenstock |
Q: I am working on Essbase system 9.Is there any built in function in essbase to project or forecast ...
A: Your example is not very clear, so I will ask you for a concrete example, maybe using a spreadsheet. ...
|
| Copy on Hyperion | 9/1/2008 | Todd Binenstock |
Q: We have two environment for Hyperion (one for development and another for production), we need to ...
A: I am sorry that this has taken so long... the question was lost in my email and I just found it. ...
|
| Essbase | 8/26/2008 | Todd Binenstock |
Q: Good Morning; I am just starting to use essbase and was wondering is there a way to get access to ...
A: I assume you are using the excel add-in to retrieve data. There is no function that I am aware of ...
|
| MAXL Script Issue | 8/21/2008 | Todd Binenstock |
Q: I Have a client that has an existing Planning Application which they use for Planning and ...
A: Are you looking for advice or consulting assistance to actually do the work to create the process. ...
|
| Hyperion | 3/3/2008 | Todd Binenstock |
Q: how to perform schedule dataload in cube in hyperion
A: There are scripting languages for Essbase. The older one is called Esscmd and has been a staple for ...
|
| Hyperion Question | 2/26/2008 | Todd Binenstock |
Q: how can we take the back up in Hyperion essbase? when a databse is crash in essbase what to do ?
A: Hyperion databases must be quiesced in order to back them up. You must either stop the application ...
|
| Re:unix commands in Hyperion essbase | 2/26/2008 | Todd Binenstock |
Q: what unix commands we will use in hyperion essbase ANSWER: Hyperion Essbase has separate scripting ...
A: Migration in Essbase is not easy. This is mostly because the location (Drive and Path) is embedded ...
|
| Hyperion | 2/26/2008 | Todd Binenstock |
Q: How Unix play a Role in HYperion Essbase Dimensional Modeling ANSWER: Hyperion Essbase runs on ...
A: I'm not exactly sure what you're asking. Unix has various scripting capabilities which allow ...
|
| Hyperion | 2/22/2008 | Todd Binenstock |
Q: How Unix play a Role in HYperion Essbase Dimensional Modeling
A: Hyperion Essbase runs on several platforms including Windows and several flavors of Unix. While the ...
|
| Moving database to another drive | 2/21/2008 | Todd Binenstock |
Q: I need to move some Essbase OLAP databases from the current server to a NAS device for DR purposes ...
A: The best way I can think of is to use the "spanning" feature which allows you to have databases on a ...
|
| Hyperion Essbase | 10/29/2007 | Todd Binenstock |
Q: I am in the same boat as Ashok was last year. I have access to Essbase, but no training $ ...
A: I am not aware of any free downloadable training resources from Hyperion (Oracle), but the Database ...
|
| Tracking Extra Members coming in DataFile | 9/10/2007 | Todd Binenstock |
Q: We are using scheduled shell scripts/Maxl for loading for building the outline and loading the data ...
A: You have two choices, really. You could perform a dimension build on the "Global Customer" ...
|
| Updating Excel info via VBA (Essbase) | 8/23/2007 | Todd Binenstock |
Q: I have a workbook with many sheets. I am looking for VBA code to update (retrieve) from Essbase. I ...
A: Sorry for the delay getting back to you. This is my busiest time of the year. I don't have the ...
|
| Automatic Logon & refresh multiple sections in many sheets | 8/15/2007 | Todd Binenstock |
Q: This is a two partA) I need to find a way to have people automatically log on...use of VBA maybe - ...
A: Chris, Sorry for the delay but I have now posted an answer to your public question. Let me know if ...
|
| Automatic Logon & refresh multiple sections in many sheets | 8/13/2007 | Todd Binenstock |
Q: This is a two partA) I need to find a way to have people automatically log on...use of VBA maybe - ...
A: Chris, Hyperion Essbase includes a "spreadsheet toolkit" which includes functions that may be ...
|
| Restricting Dimensions | 2/2/2007 | Todd Binenstock |
Q: I have two dimensions - one for programs (8 elements)and one for projects (15 elements). Both are ...
A: sorry it has taken a little while to get back to you. I am assuming this is an Essbase question. ...
|
| Hyperion | 11/2/2006 | Todd Binenstock |
Q: Iam new to hyperion tools, but have knowledge in business objects. Now iam asked to get trained in ...
A: By your question, I think you are wanting knowledge about Hyperion Intelligence, formerly Brio. My ...
|
