Analytic Blend

20 Topics

Cubeview Drill Down issue: Load Results for Importe Cells is empty
Hello there, We are having an issue when using the Drill Down option from a Cubeview, and it's that after getting to a base data cell within the Drill Down window, and then trying to navigate to stage using the "Load Results for Imported Cell", the results window is displayed empty: The workflow that is being used it's a simple Import, Validate and Load, that retrieves the imported data from a Connector and there is no further data processing once it's in the Cube. From the Workflow Page we can use Drill Down and Drill Back just fine. Any ideas of why is this happening? Thank you. Oriol
ogonzalez
5 days ago Place Workflow and Data Integration
21Views
0likes
3Comments
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
4 months ago Place Workflow and Data Integration
83Views
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
4 months ago Place Workflow and Data Integration
46Views
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
5 months ago Place Workflow and Data Integration
126Views
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
9 months ago Place Workflow and Data Integration
1KViews
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
10 months ago Place Workflow and Data Integration
45Views
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
11 months ago Place Workflow and Data Integration
176Views
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
12 months ago Place Workflow and Data Integration
55Views
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
591Views
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.2KViews
0likes
4Comments