Philip:In our instance, we built a DynamicCalc formula in UD8 dimension
to get the parent of a UD4 member.This could be modified to get an
Entity’s parent based on its relationship properties such as Parent Sort
Order, Text1 to Text 8.' Derive Indust...
There are XF MarketPlace solutions you may leverage for this. Developed
by OneStream with no additional cost.Security Audit ReportsSet the Start
Date and End Date at the top of the dashboard then Refresh. To derive
active user count, take the differe...
Nicole:We just upgraded to 6.4.0 from 6.3.1 yesterday!For our PowerShell
scripts that interact with OneStream, we set up a native user within
OneStream Security to act as an internal service account exclusively for
executing automated tasks. I intend...
Here are the SQL queries used in the Data Statistics report starting
with getting imported record (row) counts:Imported Row Counts By Cube,
Scenario & OriginSELECT[Cube].Name AS CubeName,Member.Name AS
Scenario,(CASEWHEN OriginId = -999 THEN ‘Import’...
Calculation only applies to Origin member Import.Based on your
screenshot:For Actual, 484,625 cube records divided by 91,251 imported
records equals 5.31 explosion factor.For ActualAR, 479,599 cube records
(at Origin member Import) divided by 198,025...