Data Audit Dashboard
Hi All, I am trying to create a dashboard to extract the data for the given point of intersection basically I have given all the dimension parameter for the user to select and click on the button download that runs the DataManagement job and will extract the data for the selected POV . I am able to achieve the above requirement just like an enhancement I want to also get the data of the user details who has loaded data into those point of intersection. Can some one help me with the lead how can I achieve the above user details that would be really great. Thank You
Eliminations between Balance & P&L accounts
Hi everyone; we have an application using standard elimination, we have been used eliminations between balance account and P&L accounts, I created a new account in Balance sheet accounts with plug account as Assets, create another P&L account (Revenue) using the same plug Asset account; now when runs the consolidation & Eliminations, there is a difference with balance, is unbalancing. Is there an specific configuration that I need to setup into the accounts? Thanks in advance and best Regards. Mario GV
Cube View Group - Forms
Hi, I'm trying to figure out how can I make few rows as un editable. Example: highlighted rows in below screenshot. I remember this can be done through Row overrides but its not working. In column member filter, I defined two dimensions as below. What should I define in Row override to have 'Total Revenues', 'Total Expense' and 'Personal' rows un editable?
Entity Consolidation status change for Forecast scenarios
Hi Folks, We have 12 forecast scenarios and 12 FX rate tables for each FC scenario. When we update the FX Rates in one table, it's upsetting the status in all other Forecast scenarios, but not Actual. We don't want other scenarios status getting affected when ever FX rates updated. and there is impact status rules exists in our application. Appreciate your advise. Thanks
Extracting Journals in a loadable format?
Hi, We're on 7.4. Is there a way to extract a posted journal from one application so that I can easily load it to another application. This would be super useful for investigating issues. At present, we can easily find imported data files, and load these into our test app. But I can't see any way to extract journals in the same way. The only options seem to be extracting a .csv file, which has the information but is not formatted in a way that can be loaded again.Attribute Members on Entity Dimension Do Not Translate ?
I'm using attribute members, unfortunately on the entity dimension, so the associated data is stored and not dynamically calculated on Parent Entities. These attributes members do not translate to foreign currencies during the consolidation process ! I'm using a 'Custom Translation', and when I execute the method 'Api.Data.Calculate()' or 'Api.Data.CalculateForTranslation()' the attribute cells do not translate. The only way I was able to actually convert them is by using Data Buffers and forcing the conversion. Is there a reason why ADC methods do not translate attributes ? Is there a hidden property to activate in order to take these members into account ? Should I use 'Api.Data.Translate()' instead of ADC ? ThanksExport Data of Selected Parameter
Hi All, I am trying to create the dashboard where I pass all dimension from combo box to button taht triggers the DM sequence that has the Export Data step. I get the following error mentioned below. FYI please see the screenshot of the export data step mentioned below. Can someone please help where I am going wrong please help me with the approach. Thank you
Cannot Execute the Process Cube (Calculation)
Was able to "Process Cube" for October and November... in attempting to close a form for December (1Q) - now receiving this error message. The Entity Assignments and Calculation Definitions on the Workflow Profile are the same as they've ever been. Can somebody share other possibilities based on what this code is telling me? Cannot execute the Process Cube (Calculation) workflow task because the current workflow profile [Investment_Sub] has not been assigned a calculation definition. User Interface Stack Trace: at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(MethodCall methodCall, ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(MethodInfo targetMethod, Object[] args) at generatedProxy_4.StartProcessCube(SessionInfo, WorkflowUnitPk, StepClassificationTypes, Boolean) at OneStream.Client.Api.Wcf.DataQualityProcessingServiceReference.DataQualityProcessingServiceClient.StartProcessCube(SessionInfo si, WorkflowUnitPk workflowUnitPk, StepClassificationTypes stepClassification, Boolean updatePreceedingWorkflowUnits) at OneStream.Client.Api.Wcf.DataQualityProcessingServiceReference.DataQualityProcessingServiceClient.<>c__DisplayClass227_0.<BeginStartProcessCube>b__0() at System.Threading.Tasks.Task`1.InnerInvoke() at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
Time Profile: Time dimension at week level vs at month level with weeks in UD
Hi All, I am designing a new app with huge data set at detailed level and need time at weeks level. I would like to know if going by custom profile with time dimension at weeks level would be more efficient or having time dimension at month level and using WEEKS in User defined dimension would be better in the performance. It would be great if you can share some pros and cons for both the approaches and which one would be optimistic. Thanks in advance.
