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.
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?
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.
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, MarkBIBlend - YTD Values
Hi, I am working on a demo for BIBlend. I understand that "View" is not supported in BIBlend and we should derive it on the reports or by using BRs. Does anyone have some some examples on how I can use Time math Business Rules to derive YTD values in the BIBlend Dashboards? Or any other methods to report YTD/QTD values for BI Blend? Thanks Liliya
