Including Journal Entries from Different Origin Member in Account Reconciliation Discovery
Hi Community, I’m working on an Account Reconciliation solution where I need to ensure posted journal entries balances are also included in the Account Reconciliation discovery process. Currently, by design the Discovery process only pulls trial balance information already imported and validated in the Stage. Therefore, I wanted to check if there’s a recommended, or best practice approach, to accomplish this requirement. Any guidance or examples would be greatly appreciated, thanks in advance for your help!
Accessing multiple import file names via DA
HI Guys, Is there anyway via a method query or rule in a data adaptor that I can specify parameters to give me all file names related to a workflow. I preferably want all file names in a specific workflow for all years in a data table of columns: (Workflow,Year,Filename). Presumably doable with a dashboard data set rule but Ive never played with the staging engine before! Guessing also that its probably a case of looping years and appending tables. Thanks, Tom
Cube Data Access - pull data to parameter?
Hi, I have an admin dashboard where I show all parameter values and information I need before I start my Data mgmt jobs. There is one value I dont figure out how to show in my dashboard. I have a Conditional input rule on the Cube. Can I create a parameter or Data Adapter or something to be able to pull the value and show in my dashboard? I only need to retrieve the Scenario value.
Cleaning Data Tables of old data
I recently discovered that data from deleted Scenarios is not removed from many of the application data tables (XFW_PLP_Plan, XFW_PLP_Register, ...) Does anyone know why it remains and is it safe to remove as the scenario no longer exists. I would think removing the old data would improve performance and reduce db size. Or am I unaware of the tools to perform such maintenance?Member Dimension correction
I created a detail account dimension without creating a summary account dimension first. When I attempt to create a summary account dimension now, I get an error message indicating the member already exists. I tried to delete the detailed dimension and start over but there is already data saved. How can I correct this?
Validation Errors mapping to placeholder
Hey Folks, I am looking to map all validation errors that might occur during an automated load to a placeholder member in the UD1 dimension, but i am running into issues as the mask rule approach is not working. Does anyone else have any other way to make this work? Below is what i have tried but i still get kickouts in the validation step of the load process.
