ContributionsMost RecentMost LikesSolutionsRe: How do I set up drill down for relational sources in BI Viewer? Hi Franz, just checking, are you saying that you can drill down on a single dimension this way? Because I can only add a single dimension and....that's it (unless I'm overlooking something). Re: Add variance for scenario in BI Viewer component I've tried the data grid and to be honest in my situation data grid is perfect to be honest. Again, many thanks. Re: Add variance for scenario in BI Viewer component Perfect, that's it. Still getting used to the syntax! Many thanks. I've a last question regarding this BI project if I may. I notice that in a pivot I can only sort rows/columns when in the BI desi...Re: Add variance for scenario in BI Viewer component Hi Sai, thank you this seems like a very suitable solution as we don't have that much different scenario's in use. So I'm trying to do this, step 2 and 3 I think are ok. Step 1 and 4 is actually one...Re: Add variance for scenario in BI Viewer component Sorry, let me explain myself. You pointed me out in order to create an actual / budget and variance column in a pivot, that I should create calculated fields: Actual, Expression = Iif([Scenario] = '...Re: Add variance for scenario in BI Viewer component Hi Sai, when creating a calculated field, can you reference to parameters in way? I've made the two scenario's used in this comparison dependent on parameters, that's why. Basically my Cube View beh...Re: Add variance for scenario in BI Viewer component Again many thanks, also for for this clear picture. Works perfectly. Re: Add variance for scenario in BI Viewer component Hi Sai, thanks for this practical solution, works great this way to create calculated columns. However, I am not sure still how to sort the pivot by the values in the delta column. Yes I could add t...Re: Create a date field In the meanwhile I've found a built-in solution that OneStream provides that is even simpler. Just go to the data adapter with the cube MD an put Add Start End Calendar Time to True (standard is fals...Add variance for scenario in BI Viewer component Hi, I have two question in one: 1. I'm trying to add a variance column in a Pivot in BI Viewer for amounts that are split by 2 scenario's, actuals and budget. What is the most practical way to do th...Solved
