Analytic Blend

16 Topics

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
3 years ago Place Workflow and Data Integration
9.2KViews
1like
15Comments
Aggregation BI-Blend non-attribute dimensions without base members
Hello: I've integrated a set of transaction details from a GL into a bi-blend cube within OneStream. I'd like to aggregate along the UD1 dimension so we can see the data at the parent level for each transaction. The dimension consists of a set of parents with a few base members rolling up to each one, it's a pretty simple dimension. I'd like to be able to see the parents in a column with the base members in the other column. Note: that the base member is being passed directly form the data source, i.e. It's a pass thru mapping. An example of a parent child relationship is below: Parent: Clubs Base:1000 Base:2000 In the ud1 value column, I'd like to only see "clubs" while in another column I would like to see "1000" and "2000" values in another. I know that in the ud1 when I aggregate this dimension, I'll see the base member and the parent members in the same column for UD1 even if it's the blend unit dim. I'm passing the base values into an attribute. Is the only way to exclude non-base members is filtering the data set on the data adapter that feeds the BI-BLEND dashboards? I know it will work, but just curious if anyone else has run into this. Thank - James
Solved
JamesKirkby
4 years ago Place Workflow and Data Integration
3.8KViews
0likes
5Comments
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.8KViews
0likes
7Comments
XFCell number format issue in People Planning Solution
Hi, I have setup the Global drivers in the People Planning module to be XFCell formulas, so that users can input drivers by Period/Scenario via cube views. The formulas look like this one: (XFCell(Cb#People_Planning:E#RU0451:P#GL1151:C#Local:S#Plan:T#|WFTime|:V#Periodic:A#PP_Acc_Driver_DE007:F#None:O#Forms:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None)) The formula works fine as long as the value retrieved is lower than 1000. The reason is that the retrieved value is by default retrieved in the #,###.000 format, which the People Planning module doesn't like. This is an example of error message: Summary: Error processing Data Management Step 'CalculatePlan_PLP'. Unable to execute Business Rule 'PLP_DataMgmt'. Global Driver [DE Max health insurance wage] Expression Error Non-Numeric value found after substitution: [Expression Before Substitution =(XFCell(Cb#People_Planning:E#RU0451:P#GL1151:C#Local:S#Plan:T#|WFTime|:V#Periodic:A#PP_Acc_Driver_DE007:F#None:O#Forms:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None)), Expression After Substitution=(56,250.000)]. Syntax error in the expression. I have therefore tried to include a NumberFormat option in the XFCell formula, like here: (XFCell(Cb#People_Planning:E#RU0451:P#GL1151:C#Local:S#Plan:T#|WFTime|:V#Periodic:A#PP_Acc_Driver_DE007:F#None:O#Forms:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None, NumberFormat=####0.00)) but the People Planning seems to not like the fact that there is a coma in the string, because this is the message it gives when trying to save the formula in the Global drivers page: "String or binary data would be truncated. The statement has been terminated." Anybody else had the same issue? How did you solve it? Thank you
Solved
AndreaF
3 years ago Place Workflow and Data Integration
2.4KViews
0likes
2Comments
I want to create a SQL Select Statement but I need to check whether the table in BI Blend exists first.
Originally posted by Eric Osmanski 4/13/2020 I want to create a SQL Select Statement but I need to check whether the table in BI Blend exists first.
OSAdmin
5 years ago Place Workflow and Data Integration
2.2KViews
0likes
2Comments
Short of joining to a dimension table to get a member's description, is there a way to configure the blend table build process to use a member's description (alias) instead of the member name?
Originally posted by Barry Nuckolls 3/13/2020 Short of joining to a dimension table to get a member's description, is there a way to configure the blend table build process to use a member's description (alias) instead of the member name?
OSAdmin
5 years ago Place Workflow and Data Integration
1.5KViews
0likes
2Comments
I got the error below, which I realize is in the BI Blend Design Guide, but I am not sure how to diagnose the cause of it.
Originally posted by Barry Nuckolls 3/3/2020 I am trying to come up with an Analytic Blend example with the client's metadata/data on the UPS project. I have put Building and Division as Attributes 1 and 2, respectively. I did not put aggregation points for either of them in the BI Blend workflow however. I did put aggregation points well below the dimension tops for some but not all dimensions.
OSAdmin
5 years ago Place Workflow and Data Integration
1.3KViews
0likes
1Comment
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
BI-Blend base data does NOT match any Aggregation Base Members. - What does this error mean
Originally posted by Rahat Fatma Hi I am trying to load data into BI Blend cube but getting this error while table creation. "BI-Blend base data does NOT match any Aggregation Base Members." Where do I need to look to trouble shoot the issue.
OSAdmin
5 years ago Place Workflow and Data Integration
1.2KViews
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
11 months ago Place Workflow and Data Integration
1.1KViews
0likes
4Comments