Jason Ash
Activity overview
Latest activity by Jason Ash-
Jason Ash created a post, Dimension Reference Table In Memory Data Model Setup
Targit version 2022.6 build 21002 I have a Dimension Customer table and a Fact Sales table joined on CustomerID One to Many. I want to introduce a Dimension Customer Reference Table which has Many ...
-
Jason Ash commented, Perfect explanation except I can't seem to select any columns data unless the column is visible. e.g. Lookup valuesRevenue1Value Drop Down - doesn't list column if is not visible. I made the column...
-
Jason Ash created a post, Column Order Number to be used in Row Calculation
I want to create a row which numbers all column e.g. 1,2,3,4 etc. across all dimension and calculations so I can then reference it in another row i.e. below I do not want to apply calculation to th...
-
Jason Ash commented, Hi Dirk, In my data model I have as an example something like below, then create the cubes, share the dimension attributes and put together in a virtual master cube. I've not had any performance is...
-
Jason Ash commented, Thanks Louise, Yeah issue is it is 100 Locations and 3 Years :-( Problem is it's a finance request and they just want to data dump into Excel, arghh, but have set column order BUT also be able to s...
-
Jason Ash commented, Hi Marlene, Good shout I'll give it a go but I think could be an issue when criteria changes and existing columns move. i.e. in image above location 003 closed so doesn't have any data/columns for ...
-
Jason Ash created a post, Hide Columns based on heading not position
I have a user that wants the layout below with two dimensions on each axis and two measures. The measure Sales Budget will only be populated for year 2021 green box and the other years orange box w...
-
Jason Ash commented, Thanks Kristoffer I will give it a go but I don't think it will work as we would now be removing the original calculation from row3 for the other columns, I'll let you know once tested. Fingers cro...
-
Jason Ash commented, Thanks Kristoffer for the suggestion :-) Yeah I tried that previously and ran into the problem of it only works against Dimension rows and does not include calculated rows, for instances. This does...
-
Jason Ash commented, Hi Marlene, Sure thing, the green boxes I want to apply a different calculation. Demand, Returns and Sales are User Dimensions and Returns %, Gross Margin and GM% are calculated rows. (I'll add for...