BIBlend - 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
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?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
