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 FabioG13Views0likes0CommentsFilter 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 FabioG37Views1like3CommentsExtensibility report usage
HI, OS has report to verify extensibility. I wanted to know based on exp that what happen when report has an error from technical perspective. We have some ragged hierarchy to full fill our req, but report shows an error so trying to understand if consolidation won't work if that is the case. By they are in UD.20Views0likes3CommentsCalculate values in different scenarios
Hi all, I tried to issue an api.Data:calculate with the following (fake) formula : A#ACCXXX:F:MYFLOW:S#MYSCEN = A#ACC001:F#CHI:S#ACT Of course OS complains because I'm reading from the current Scenario (ACT) but I want to write in a different Scenario that implies a different Data Unit (is it ?) While being in ACT scenario, if I would switch to DataBuffers to write in the destination Scenario (is it?) Could someone point me in the right direction ? I did this, but looks like it doesn't write a **bleep** ! Dim _srcDC As DataCell = api.Data.GetDataCell("A#ACC001:F#CHI:S#ACT") Dim _targetDB As New DataBuffer() Dim _dcNew As DataCell = New DataCell(_srcDC) _dcNew.SetScenario(api, "MYSCEN") ' This WON'T CHANGE <=================== _dcNew.SetAccount(api, "ACCXXX") ' This Change _dcNew.SetFlow(api, "MYFLOW") ' This Change _targetDB.SetCell(si, _dcNew) api.Data.SetDataBuffer(_targetDB, _destinationInfo) In the end, works fine... just doesn't change the Scenario... :-/ What am I doing wrong ? Thanks in advance for your help FabioG23Views0likes1CommentCompilation Chain issues
Hi all, I wrote a bunch of BRules and a couple of Assemblies (in different workspaces) that work together to perform calculations. So in the end I have a dependency chain like this: BR => Assembly => Assembly Things works like a charm. Sometimes, after I made changes to an Assembly, I get a weird error saying that OneStream cannot find my assembly. While this is true when it cannot compile correctly (due to errors), it doesn't make sense to me when it compiles fine. Even if I compile my assemblies before I run the BRules, sometimes it happens. I'm trying to find out an explanation and I thought that: I run the BRule and OneStream think that Assembly1 - a dependence - is "old", so.... OneStream start compiling Assembly1, and, while compiling it, OneStream think that Assembly2 - a dependence - is "old", so.... OneStream start compiling Assembly2 Maybe these compilations are running async and in parallel... And, maybe, the last compilation takes too much time, taking the first one returning the error. This is just an idea that could explain this issue, but I'm quite sure this is the right way: when I started working on OneStream, my code wasn't affected, IMHO because the assemblies were small enough to be compiled in a reasonable time. But now they are growing up, and the compilation time is growing too. In any case, I'm wondering it there's a way to solve this annoying issue: I often have to (re)launch the same BRule and, on a customer's perspective, seeing a compilation error (even if fake) doesn't make a good impression. Thanks FabioG48Views0likes2CommentsManaging Application Secrets
Hi all, While getting into OS, I'm trying to figure out how to leverage on its framework... And I have a question related to secrets management. Let's say that - at application (workspace?) level - I need to access to a remote service that requires an OAuth token (or user/pass tuple, or whatever I need to keep away from user's eyes - and fingers). The above mentioned secrets should be (visually?) managed by an administrator. Does OS offer something out-of-the-box to accomplish this task ? And, in case, can we leverage on some API to retrieve secret data ? Thanks for Your answers. FabioGSolved110Views0likes4CommentsXFString inside an Assembly
Hi all, while building new classes inside a Workspace's Assembly, I'd like to get Strings in specific languages. On components, we use "XFString(<stringName>)" to get the localized string, in the User's language. How can I accomplish the same thing inside a method ? I mean, which is the equivalent for XFString inside - let's say - BRApi ? Or should I really get the localizations from the DB Table ? Thanks for Your help Regards FabioG16Views0likes0CommentsUsing Assembly's XFBRs
Hi all, I'm in trouble in using an XFBR from an Assembly, inside a Data Adapter. I've just discovered that it's possible to use the XFBR function as part of a SQL Command, like this: SELECT * FROM MyTable WHERE MyField = 'XFBR(MyBR, MyFunction, Param1=|!prm_Whatever!|)' I was surprised to see it working, but this is not the point. When MyBR is defined as a Business Rule, everything isworking fine. Then I moved the Business Rule into a Service XFBR. Since the Factory is defined at Workspace level, I converted the query as: SELECT * FROM MyTable WHERE MyField = 'XFBR(WS, MyFunction, Param1=|!prm_Whatever!|)' Directly testing the Data Adapter everything works fine, I can see the converted query and also the results. Now, the problems: The above mentioned Data Adapter is used by a Report. When the XFBR is defined under the Business Rules area, everything is ok. When I launch the report (from a Dashboard), i get the following error: Error processing XFBR String 'MyFunction'. Unable to find the Workspace Assembly Service Factory class for name 'WS' in Workspace 'Default' Not clear what I'm missing. Can someone point me in the right direction, please ? As an additional info, let me say that the DataSet/DashBoard/etc were moved from the Default WorkSpace into a brand new WorkSpace (but I cannot see any reference to the Default WorkSpace in Data Adapter or Report) Thanks a lot FabioGSolved292Views1like10Comments