Recent Discussions
Consolidation in a Dynamic Cube
Hi Experts, I have a dynamic read only cube, source of this cube is a relational table having details like salary band, department, position, benefits %, tax %, etc. I am simulating some calculations in workspace assembly and setting records in the dynamic read only cube. I see expected data at base entity levels. How can I see correct data at the top entity level? Entity structure: I see same data at multiple levels. Asia and AllRegions data should not be same. Also drill down results are same at multiple levels which is weird. So if we are setting data at base entities in a dynamic cube, how does consolidation work here? JackLacava , would you please clarify this?Data Management Export configuration
Hi all, I'm working on a Data Management to "Export Data", launching it from a Dashboard. Everything works fine, since filters (Cube, Entity, Account, Flow, etc) can be parametrized through Parameters. Is there a way to parametrized also the Options such as "Include Zeros", "Include Member Descriptions", etc ? I see that at UI level I can only choose between True and False, but I'd like to manage them from my dashboard. Thanks in Advance FabioG
OneStream 9.0 file explorer error
Hello, I installed OS 9.0 on premise version recently and I am having the following error when I try to upload a file: You can find below the error details: Unable to load file.An error has occurred. BadRequest. User Interface Stack Trace: at OneStream.Client.Api.FileExplorerServiceReference.FileExplorerServiceClient.UploadFileFromStream(XFFileTransferRequest request) at OneStream.Client.Api.FileExplorerServiceReference.FileExplorerServiceClient.<>c__DisplayClass370_0.<BeginUploadFileFromStream>b__0() 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) Do you know what is the cause of this issue? Thank you in advance. AntonyFilter Members by Security
So we have the GetBaseMembers method (or the GetChildren, or the GetDescendant or event the GetMember) that would return instances of the Member class. What is not clear (at least to me) is how I could filter returned members based on security. I could set Nobody in all the member Security's fields of a specific member, but it keeps on being returned by (for instance) the GetBaseMembers. I'm wondering how I could get only visible members, applying a filter that won't return them from the call. Also, it would be nice to know, given a member, if it can be seen, read or written. Two ways to get the same result, for different scopes. Thanks FabioG
Account Attribute: In Use versus Allow Input
Hi all, We have hundreds of historical (no longer valid) accounts sitting in a cube and we are looking at ways of de-cluttering resulting data retrievals to avoid seeing them. But additionally, we want to prevent any accidental loading to these accounts from the source system. For reporting, I know we can populate one of the text fields with some text and then combine that with a Where() clause to filter out these old accounts. But, from a data load perspective, just wondering what the risks / benefits are of utilizing either (or both) of the In Use or Allow Input attributes; to prevent accidental loading of data there. We want to be able to continue to see any historical data for these accounts and be able to drilldown from the parent account and see that data. There are no member formulas associated with these - they are all base accounts. We don't care about the Scenario/Time specificity capability If anyone is using these attributes would very much appreciate any recommendations or hearing what your experience has been (before we go through the effort of testing either of these options). Many thanks, K.
Issue Retrieving Text Property from DynamicCalc Accounts in UD8
Hi all, I have a DynamicCalc account where the Text6 property is populated. I also created a UD8 member that dynamically retrieves the POV account and returns its Text6 property. In my Cube View, I set the POV for this UD8 column to Annotation. This works well for all non-DynamicCalc accounts... I can successfully retrieve and display the Text6 property in the Cube View. However, for DynamicCalc accounts, the Text6 property doesn't appear. It seems like OneStream can't resolve the property for DynamicCalc members in this context. Has anyone encountered this behavior? Thanks in advance! UD8 member filter:Mass modification of a Metadata member attribute
Hi all, Does anyone happen to have the correct syntax for an XML file that modifies a single attribute (member property) and can be uploaded to OneStream without resetting other member properties? A bit of background, I have to add content to the Text7 field of over 3000 members. I tried one version of a XML that only referred to the Text7 property for a single member But when I loaded the xml, some (but not all) of the properties for that member reverted back to original defaults. On the plus side, it DID update the Text 7 field. I'm clearly not defining my XML properly so if anyone has an example of the syntax I can use to update a property without affecting anything else, I would love to see it. I realize I can extract all 3000 members to an XML, but if the Text7 property is not assigned anything, then that property doesn't get included in the extract (otherwise I could simply do a global search/replace): in order to fix this I would have to write a script to run against the contents of the XML and 'add' a line identifying that property and it's contents. I'm hoping there's something more straightforward out there? Fingers crossed. Thanks in advance for any examples you might have.Environment Monitoring Graph Not Displaying Any Values
Hi everyone, I've been trying to use the Environment Monitoring feature, but for some reason the graph doesn't display any values. The interface loads correctly and I can select different metrics and time ranges, but the chart area stays empty—no lines, no points, nothing. Has anyone experienced this before or have any idea what might be causing it? Any tips on how to troubleshoot or configure it properly would be greatly appreciated. Thanks in advance!
