Data Import of prices with average result
Hello, In our planning solution I'm looking for a change to plan with less detail. We import transfer prices on material level, but now we want to plan on product level which includes several materials. During transformation the items with the same dimensionality are being combined and show a total value, but for these prices I would need a simple average. Example below: Imported values: After transformation the original UD4 is replace by the product member which is imported on Flow, because some UD4's remain unchanged: I would need to have the simple average (871.48 + 880.82)/2 = 876.15. Is there a simple setting for this, i can't find it, any other suggestion would help also. kind regards BenSolved8Views0likes1CommentCan a Format Template Profile call a Cube View created in a named Workspace?
In v9.0, I have created all my cube views in a named Workspace (i.e. Not Default). I need to attach a single Cube View to a workflow task. In the past, I would create a Form Template Profile which I would then assign to a workflow Form Input task. In v9.0, when I select the Workflow task, I get the message (Unable to open Cube View "mycubeview"). Is this possible, or do I need to create them under the Default workspace or under Application->Presenatation->Cube Views? ThanksSolved17Views0likes2CommentsCube | Data Access | Data Cell Access Security/Slice Security by U1#Geography
Data Management Access Security Please share your expertise to set up a Cube's Data Cell Access Security / Slice Security to limit data read access as outlined below: Dimension: U1# - Geography Total_Geography = Child 1 + Child 2 = Total / Top North_America = Child 1 / NA International = Child 2 / Int'l Slice Security: Access Level - Read Data by Geography - in a CV and a QV Total_Geo_Data = Read Total data | Read NA data and Read Intl data NA_Data = Read NA data | no data access = International and Total Intl_Data = Read Int'l data | no data access = North America and Total TY for your practical advice - SMEs.Solved143Views0likes2Commentsis possible to upload data on the parent member?
hi All, I need to upload data into the new scenario Plan with 5 years and would like to load data in parent membaers (Entity, Account and UD1), I'm using the scenario property "Allow input into Aggegated Consolidation member" but I think that this property is for another purpose. I'm coming from EPM Planning where it could be possible and many people told me that uploading data at any level is possible but cannot find any example. Could somebody help me? Thanks in advance and best Regards. Mario Guerrero46Views0likes2CommentsOption to disable the "Load" button and only show "Load and Process" on the WF step.
Having the option to disable the "Load" button and only show "Load and Process" on the WF step would help when we add a rule in the process step that needs to be run every time the user uploads a file. This would reduce the risk of a user clicking Load and not Process, which is important for our operational planning teams to avoid data being missed or incorrect because a calculation or rule was not completed.24Views3likes1CommentActual at other FX rate (PY/Bud/PP) - Currency Neutral - How to view Fcst Scenario at other rate
Two part question. Comparing Actuals as other Rates to remove currency flux We want to take our Actuals and view at PYE, PYP & budget FX rates to take out flux in currency. Is there a feature (outside of creating BR's or Alt Rate types) to do this. We currently have built 3 scenario for the above rates and it works as expected for base level members. Where we run into issues is with converting to Reporting currency at parent members. Ex is converting our EMEA entity (currency - EUR) to USD. The BR seems to store the USD value at the base entity but is converting from EUR to USD at parent level using OS logic (ie current defined rate for Actual scenario). It is not consolidating up the USD value but converting from EUR at parent member. This BR was created almost 6 years ago when we implemented so hoping there is something out-of-the-box now that will do this. I am exploring creating 3 new Rate Types: PY Budget, PYE Actual & PYP Actual. I would copy all the PY rates into these 3 new rate types and then create 3 Actual scenarios, each using these new rates. The big issue is having to copy all the data over from Actuals and then reconsolidating. Hoping there is a better way. Fcst Currency Neutral - Having Fcst at the Budgeted rate We are US company with large % of our business from Europe and the flux in EUR to USD is distorting our review of how we are doing. Looking for a way to see our Fcst how we expect (current process) and at Budget rate. I could copy to new scenario that is set to Budget Rate but we have 12 Fcst scenarios and that would take up alot of resources to copy and consolidate as we would need to do this many times during Fcst process (ie it would not be something we only did once the Fcst was closed but during the process) Would this be a UD8 member and if so, how would it handle Base and Parent level members. Looking for best practice advice on how to handle these two issues.30Views0likes1CommentCapital planning - Access
Hi, We are using the capital planning module. There is a requirement from client For a few lines, users should not be allowed to change, modify, or delete anything. However, if he adds additional lines, he should be able to edit, add new line or remove. Example: In the budget scenario, data is copied from Actual, and it also has its own budget data. So, for data that comes from Actual, end users should not be allowed to modify or remove. However, for budget data, he should be able to update, change, and remove lines from the Capital Planning Register. Is it possible?17Views0likes0CommentsFetching text property by time
Hi, I'm trying to display a time-variant text property of the UD1 dimension member in a report. The challenge is that the text value can exist in any period of the member, so I currently loop through the forecast periods (spanning two years) to retrieve the values. While the code works, its performance is not good. Is there a way to fetch or look up the text properties by time (possibly from a specific table) without iterating through all periods? Any command or optimized approach to achieve this efficiently would be highly appreciated. Dim Date As String = $"{year}M{month}" Dim timeID As Integer = timedimhelper.getidfromname("Date") Dim myVaryByTimeId As Integer = BRApi.Finance.Members.GetMemberId(si,DimType.Time.Id, Date) Dim mbrText As String = BRApi.Finance.UD.Text(si, 9, mbrId, 1, -1, myVaryByTimeId)Solved147Views0likes8CommentsWorkspace Assemblies Extensibility Rule
Has anyone been able to get an extensibility rule to work in the workspace assemblies? I've looked and I haven't seen much of any documentation on this. I'm working in 8.4 and have the rule working when I have it using the regular extensibility business rule which is attached to a DM job to run. When I try to move it to a workspace assembly and put it on a DM job it doesn't work. I've created a new file as the Extensibility Business rule source code and have the same code with no errors. I don't see an option in the Ws Assembly Factory to specifically call out extensibility rules either. So far I've been successful with getting an XFBR, Extender Rule and Custom calculate rule to work in assemblies but extensibility doesn't seem to work. Below is the error I am getting.Solved150Views0likes9Comments