ContributionsMost RecentMost LikesSolutionsRe: SQL Optimization So, yes the globals is used for caching data in memory, particularly where you want subsequent passes of a business rule to 'remember' some information that a previous pass has done. Examples are: ...Re: FdxExecuteCubeView Function Public Class MainClass Private dctLastMemberName As New Dictionary(Of DimTypeId, (Integer, String)) Private Function GetMemberScript(ByVal si As SessionInfo, ByVal cpk As DataBufferCellpk) As S...Re: Deprecated GetLiteralParameterValue and SetLiteralParameterValue replacements? My apologies for some confusion, I was testing on a beta-release prior to the documentation (thanks AMoore the clarifying). I have installed the v7.4 general release and confirm this is how to acces...Re: Interactive prompt You need to remember your business rule will run on the server, in the cloud. Not on your laptop/PC. So MsgBox statement running on a server machine in an Azure cloud, isn't going to present a popo...Re: How to reset the InUse entity property to the way it was by default from a BR? It would be useful to have a screen cap of an example, for clarification on the question here. Let's say you have an entity , where the InUse property has been set to a stored value for a certain ...Re: Deprecated GetLiteralParameterValue and SetLiteralParameterValue replacements? In that case I would recommend the tip already given my AMoore in this thread, to get the workspace ID as follows: Dim wsIdValue As Guid = BRApi.Dashboards.Workspaces.GetWorkspaceIDFromName(si, isS...Re: Equity method of Consolidation If the Consolidation Algorithm is Standard then the PCON=0 will ensure nothing gets as far as the C#Elimination stage, because the internal DataBuffer for C#Share (dynamic calc) will be empty. If ...Re: Building External Libraries I know this may be a silly question but are you sure you are building your DLL using the same .NET framework version as the OneStream platform? I assume you are using Visual Studio? If you are on-pr...Re: Data Refresh between applications for on-premise To answer the other question regarding BinaryData20xx, DataRecord20xx, these refer to member IDs which will likely be different in the target application, so if you simply replicate those tables then...Re: Invalid Intersections on all lines of a data load Are we sure that each Workflow Profile has their own entity assignment? And the source files that are being imported are limited to only those entities?