Export Cubeview with only the columns defined
Hi All, I am trying to export a cubeview using FdxExecuteCubeView, but I get every dimension even though my cubeview only shows 4 dimensions. What is the best way to export a cubeview to retain its view. I want to export multiple cube views and load them to a table so that I can have all of the cubeview data exported through one Data Adapter call via the rest API. Right now, I export one view I get 3 million rows, but when I aggregate it to the level in the cubeview I end up with 28,000 rows. I'd like to avoid exporting 12 million rows if possible. Thanks, Scott19Views0likes2CommentsHow to write Smart Integration Function in Assembly
Hi, I have created one one Smart integration function in to transfer file from sftp server to share point server. can we use smart integration function as a file or use existing smart integration function as dependency , not sure just need suggestions.52Views0likes1CommentFDXExecuteCubeView with Consol filter
Hi All, How would I go about passing a Consol member as part of the POV to a FDXExecuteCubeView call? I want to pull one extract that is in Local currency and another that is in USD. Can I do that with this call, or do I need to set up 2 cube views, one set to Local and another set to YTD? Thanks, ScottSolved44Views0likes3CommentsFdxExecuteCubeView parameters
If I build a cubeview that contains the desired POV and functions on its own, using FdxExecuteCubeView seems to work great. However, there is no documentation available on actually using the FDX functions and I can find no functional examples of how to pass the various filters/members from the FdxExecuteCubeView function to the cubeview it's actually calling. For example, I can enter T#2022M10 as part of the POV for the cube view and then FdxExecuteCubeView will create the table. However, if I pass the timeMemFilter a value of T#2022M10, I get no data. It seems obvious that I need to put something in the cube view POV to tell it to use this value but there's no indication of what that might be. Am I missing something obvious here? Is there some missing documentation or fundamental functionality that I'm unfamiliar with?Solved6.8KViews1like12CommentsEncryptText And DecryptText Replacement
Does anyone know what replaces the 2 utility commands below? I get a warning message that those commands are obsolete but it does not give any indication or hints of what the new commands are or what's currently available? BrApi.Utilities.EncryptText andBrApi.Utilities.DecryptText Any help is highly appreciated. Thanks, JunSolved161Views0likes3CommentsHow to check data load status of WFs with load overlapped siblings enabled
Hi, Is there a way to check status of all load overlapped siblings enabled WFs? The issue is that we have bunch of overlapped data WFs (even after L3 data unit) and people are stepping on each other, doubling the amounts every time someone loads their WF while other WF data load is in progress. Wanted to try event handler and message showing load is in progress. Any other ideas to avoid this are also appreciated. Thank you, Mikki39Views0likes1CommentSendMail input string not in the form for an e-mail address
Hello everyone, We recently made the jump from version 7 to 9, and a rule that was previously working is now throwing an error. We are trying to use the BRApi.Utilities.SendMail functionality after a certification is done through the DataQualityEventHandler, but OS is giving us the following message when executing the certification The specified string is not in the form required for an e-mail address. We verified the toEmailAddresses parameter is a List(Of String) with a single item in the format "user@mail.com". What can be causing this issue?39Views0likes1CommentThrow error when Clear/Deleting file in WF Import using TR event handler
Hi, I have been playing around with TransformationEventHandler and one of the things I am trying to do is throw an error when an user tries to clear imported/stage data. I think I got the code but I only want it to run on specific WF. I tried to use below but for some reason not able to retrieve the WF profile name. Any idea why? Case Is = BREventOperationType.Transformation.ParseAndTrans.StartClearData Dim ScenarioName As String = BRApi.Finance.Members.GetMember(si, dimType.Scenario.Id, si.WorkflowClusterPk.ScenarioKey).Name If ScenarioName = "Forecast" Then Dim objTransformer As Transformer = DirectCast(args.Inputs(0), Transformer) If objTransformer.WorkflowProfile.Name.XFEqualsIgnoreCase("AAAAA.BBBBB") Then Throw New XFException(si, Nothing, Nothing, "Data cannot be deleted.....") End If End IfSolved38Views0likes2CommentsDerivative logical operator issue
Trying to create simple rule based on value greater than or less than zero, however only my Negative rule successful. A#[ACC1]=ACC1_POS | Create If > x | Final and A#[ACC1]=ACC1_NEG | Create If < x | Final On the above stated expression type, I first tried to specify the Math Value only as 0, however nothing happened. Only when I changed it to 0.01, did the logic start to work. Now, if the source value is a negative, the second derivative rule works (returning ACC1_NEG), but if I put through a positive source value, it does not create ACC1_POS a bit stumped on this one now. Any suggestions someone can perhaps suggest? cheers, JacquesSolved1KViews0likes5CommentsDerivative Rule
Alo I’m trying to create a Source Derivative Rule that takes each inbound Stage row and produces **two** output rows. The first row should remain completely unchanged. The second row should be an exact duplicate of the first, except the **FERC** field must be replaced with the value from **A8**. I’ve confirmed that Rule Expressions cannot duplicate rows, and the `Transformer` object in Source Derivative Rules does not expose methods like `GetInputRow` or `GetSourceRecord`. I’m looking for the correct, supported API pattern for duplicating a Stage row inside a Source Derivative Rule, or confirmation that this must be done in a different rule type (e.g., Target Derivative Rule). Any examples would be greatly appreciated69Views0likes2Comments