Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamically populating and formatting cells with Essbase members
1. It is a long time since I used Essbase, but I just had to put the
Essbase row/column headers in (or do a drill down to achieve this) and Refresh when it retrieved all data. Subsequently all I had to do was Refresh ('EssRefresh' or something like that ?)to get the new data. A brilliant tool ... with limitations .... 2. My experience is that in no way should you format the row/colum headers or raw data that comes from Essbase if you want to re-use the sheet. I think because everything is text. Things seem to work alright to begin with, but gradually in time the sheet corrupts and odd values refuse to appear in the grid, needing to make a new sheet. Very difficult to trace and correct. It is easy to hide the Essbase extract columns and use cells to reference them in a formatted area elsewhere. Regards BrianB ============================================= Gerard Williams wrote in message ... I am working with Excel in the front end and Essbase in the back end. I currently use a MemberRetrieve command to pull in the members from a specific dimension. I need to dynamically list these members everytime I refresh the page with new data. The number of members can vary. Would I use some kind of counter? Once these members are displayed in a list in Excel, I then have to format the rows. Can you help with this? Thanks! *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
populating list and formatting | Excel Discussion (Misc queries) | |||
Dynamically Copying Changing Conditional Formatting | New Users to Excel | |||
Randomly populating empty cells with other text cells | Excel Discussion (Misc queries) | |||
Auto Populating and Formatting Data | Excel Discussion (Misc queries) | |||
Do the values in a range of cells include all members of a set? | Excel Discussion (Misc queries) |