Analytic Blend

19 Topics

importing a file with variable columns
We have been tasked with importing a file that has a large number of variable columns. For the sake of easy explanation, let's say the first five columns are standard (time, entity, ud1, ud2, ud3) but the file could have from 50 to 150 additional columns, one for each account. If there is no data for the account, there is no column for it. New accounts could appear in the future without warning. No, we don't have the ability to change the format of the report. (Oh, how I wish.) I have thought up several ways of making this work but each is fraught with its own type of peril. Create a new, custom table dynamically to stage the data. Parse the column names from the file. Use the column name list to run a new SQL query to unpivot. Parse the file in-memory to manually unpivot by parsing each data column and adding rows to a datatable, then returing the full data table. Maintain a list of the columns we care about the most, parse the file in advance and save the column name/position maps to parameters/a lookup table. Use up every possible attribute/value field in a data source to stage to BI Blend and try to unpivot from there. Hope they never need more "important" columns than OS can handle. (This is similar to option 1 but we're not stuck dropping/creating a custom table ourselves and we have more consistent column names.) Write a manual file-parser that creates a new, sane text file and then imports that instead. (Seems wasteful. If I can get it this far, I can probably just do it in-memory, ie, option 2.) Some other, better idea that I haven't thought of yet.
Solved
photon
6 hours ago Place Workflow and Data Integration
34Views
0likes
2Comments
Error Message: A column named 'AccountType' already belongs to this DataTable.
Has anyone seen the above error message or have thoughts on what it might pertain to. I am trying to load a delimited file to a BI Blend table. My test file only has 5 records. When I import the data it gets to 12% Complete - Translating Cache step. The only place I can find a reference to this field is on the file suffixed with '_RS'. BI Blend definition Error Msg:
Solved
RandyThompson
28 days ago Place Workflow and Data Integration
20Views
0likes
1Comment
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
2 months ago Place Workflow and Data Integration
75Views
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
6 months ago Place Workflow and Data Integration
969Views
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
7 months ago Place Workflow and Data Integration
30Views
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
8 months ago Place Workflow and Data Integration
117Views
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
8 months ago Place Workflow and Data Integration
35Views
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
2 years ago Place Workflow and Data Integration
530Views
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