Analytic Blend

17 Topics

Orphan members - validation error required
Hello dear community members, Background: We have had situations with month end workflow load validation errors which were fixed with UD1 mass upload. Few UD1 members ended up in Orphans, as the Parent did not exist yet in OneStream at the members mass upload step. The validation error disappeared and the workflow was complete. However, this created an Out of Balance and it was difficult to retrieve the issue. Questions/potential solutions help required: Would it be possible for the month end Workflow load Validation error to ignore Orphan members and still get an error even when we create members and end up by mistake in Orphans. Is there a way to delete Orphan members with a BR? Is there a way to stop the Metadata builder xml file to create Orphans when a parent is missing from OneStream? Thank you in advance for any idea/suggestion/tip/hint.
Solved
IrinaDragusanu
6 days ago Place Workflow and Data Integration
59Views
0likes
11Comments
FdxExecuteStageTargetTimePivot
Hi, I am trying to explore the FDXExecuteStageTargetTimePivot if I can use it to show stage data. Does anyone have the business rule and share Thank you
Solved
cons1
5 months ago Place Workflow and Data Integration
955Views
0likes
2Comments
Summary: BI-Blend base data does NOT match any Aggregation Base Members.
We have noticed that BI Blend drop tons of lines during the import and does not log any error. We took few not loaded entries and try to load to table again but getting below error. Just few lines of data. Tried to play around with Agg properties but could not find any solution. Summary: BI-Blend base data does NOT match any Aggregation Base Members.
pranav46
5 months ago Place Workflow and Data Integration
26Views
0likes
2Comments
Reference External DB and Application DB in one SQL Query
Hello, I am writing a SQL Query that references tables in different databases, one that exists in the External database (BI Blend) and one that exists in the Application database. I am having trouble setting up my data adapter to allow for pulling in both tables to perform a Union, as I need to specify the Database Location. Is this possible?
Solved
danszczepanski
7 months ago Place Workflow and Data Integration
108Views
1like
8Comments
Reusing Bi Blend attributes
Hi All, We currently have BiBlend set up to use all 20 attributes. We're considering reusing two attributes to load data from different columns (these attributes are currently used but are no longer needed). Our plan involves renaming these attributes in the Cube Settings and updating the data source. Does anyone know if this is possible? Are there any restrictions or limitations on how attributes can be used or modified after the initial configuration? Thanks in advance for your insights.
Solved
SaraA
7 months ago Place Workflow and Data Integration
34Views
0likes
2Comments
How do I clear/truncate/delete BIBlend tables?
I have some BIBlend tables I have created during testing of a Workflow. that I want to delete/Truncate Resetting the Scenario doesn't do it. Do I need to do it programatically or via a Data Management job? When I try this it tells me that the SQL is not safe (I have tried with TRUNCATE TABLE and DELETE) Thanks Steve
Solved
SteveK
12 months ago Place Workflow and Data Integration
527Views
0likes
1Comment
BI Blend : No valid Datakeys (Scenario/Time) found in Data Source
Hi, I am practicing building a BI Blend report on Golfstream Application. I was able to create a connection to the external database i.e SQL Studio, make the config changes in Onestream Database Configuration Utility and I can fetch that data in the dashboard using SQL connection string which is working fine. Then I created a new Workflow profile that uses the BI Blend functionality. It is throwing some errors as you can see below Any help would be highly appreciated. Moreover, if someone has a working guide/tutorial to get started with BI Blend, that would be appreciated. P.S. - I already have the BI Blend reference guide but it is not working since there is no specifically designed tutorial to practice BI Blend Reporting in that.
Manjinder_Singh
2 years ago Place Workflow and Data Integration
1.1KViews
0likes
4Comments
BI Blend to Cube
Hey all, We are currently looking into BI Blend and use it for our Sensible Machine Learning solution that we are about to implement. The initial plan is to use two BI Blend instances one for historical data which is very detailed data with a long historical range. And a second for a more short term forecast period. Our ambition long term is to be able to use our Forecast BiBlend table data in our Planning process and our regular Cube and Scenario. Do anyone have a recommended approach to migrate data from BIBlend into cubes?
Solved
Jones
2 years ago Place Workflow and Data Integration
2.9KViews
0likes
7Comments
Create a Bi Blend Table without any aggregation
Hi I am loading data into a Bi Blend table and I don't want any aggregation applied. My understanding from the documentation is that I can use 'SSOnly.' However, whenever I try use this I get an error. Below is the config: Question 1: Am I doing something wrong in my config or is my understanding of how it works is incorrect? Another idea of mine is to set the Blend Unit Dimension Token to a UD member which will only ever have 1 member (e.g. UD4 and set the Aggregation Info to 'None'), so the aggreation should never create any additional aggregated parent records. I have tested this and it appears to work but I am worried that there is a potential issue that I'm not aware of... Question 2: Is this a viable workaround and is there anything that I should be worried about if I follow this approach? Thanks, Mark
MarkBird
2 years ago Place Workflow and Data Integration
1.3KViews
1like
3Comments
FDX methods (like FdxExecuteCubeView) ... Why are they faster?
Recently I heard in these forums that FDX methods (like FdxExecuteCubeView) should be used from a BR whenever the performance of the data is critical. Can someone help me understand why they are faster? We've already built quite a lot of client-integration software using cubeviews. The cubeviews are being executed via the REST api. We are retrieving data with "api/DataProvider/GetAdoDataSetForCubeViewCommand". Now that I have discovered the "FDX" methods, it puts me in the troublesome position. I realize that a ton of our integration software should probably be re-written to use those FDX methods. The re-write may take some time. Why won't onestream just extend the "normal" cubeview interface of the REST api, and add an option to run it in FDX mode? That would be similar to the "turbo" buttons they used to put on a the tower of a PC to make it run faster (for those users who had a preference between a fast computer and a slow one.) It would be helpful to understand the differences between these two (fast and slow) mechanisms for retrieving data from cube views.
Solved
dbeavon
2 years ago Place Workflow and Data Integration
9.5KViews
2likes
15Comments