Recent Discussions
Audit tracking: How do you track changes in OS and link with approvals?
Hello! What's your company's way of tracking OS changes and pairing them with approvals? Do you do it manually with a report out of OS that you put in excel and numbered to match the saved approval email in a shared drive? This is how I did it in a previous role where the changes were more manageable :) Do you create a custom database table in OS and add a field to tag to those OS change reports to a ticketing system you're managing outside of OS? Trying to brainstorm a more efficient way that meets auditors expectations but doesn't involve creating a full time role to pair changes with approvals. Any suggestions on how your company accomplishes this would be very much appreciated! Thanks, Nicole
Refresh of Spreadsheet with the Cube Views and Table View
Hi all, for one customer we need to prepare a an input file template with cube views to deliver correct metadata (dimensions). The Idea is to prepare as much data and metadata from the applicatoion for the user as possible. We were not able to find a solution how to retrieve a list of all entities when the user has access only few out of all. So we switched to the Table view. We created a dashboard containing the spreadsheet with the template that is refreshed at load. The trouble is refresh itself. If I have a blank spreadsheet and add the table view there, the refresh (TV or the whole Sheet) is almost instant. If I have the template with just some Cube Views, it is also very quick (few seconds). But refresh of the same template with added Table View takes almost 2 minutes and it freezes the client and even the Excel if I use the add-in. Would you have any recommendations?
How to move accounts from one hierarchy to another one
Hi, In our application Account hierarchy is Root>GL_Accts>SGL_Accts. The account A is created under "GL_Accts" heirarchy. The business requirement is the account A should move under SGL_Accts hierachy. Can we make change this change? please advise.
v9 - Linked Reporting Parameters not working
We have a dashboard that was originally built in v7 that allows us to add an intersection of data to a CV . When you click on an intersection in the CV, the code takes the Linked Parameters from the CV and populates combo boxes with the members in the intersection. You then change one or more of the members in the combo boxes and click another button to add this intersection (by adding a penny to another account) which then shows up in the CV. This used to work in v7 but now as we are testing this in v9 the linked parameters that are being passed to the code are not the current values in the intersection you are on. It seems to be passing old values. Any thoughts?
