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 LiliyaFDX 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.Solved9.2KViews1like15CommentsReference 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?SolvedCreate 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, Mark1.3KViews1like3Comments