Jason Ash

1. Community
2. Frontend, Designer and Consumer
3. How do I change the canvas size?

Right Click on your layout and choose Page settings From here you can change the sizing   You can also access Layouts from

• View comment
• Created February 23, 2021 08:44
• 1 vote

1. Community
2. Data Warehouse Developer
3. Bus Matrix for InMemory data models?

Yes from within your Data Model, it's simple, click the button :-)

• View comment
• Created February 23, 2021 08:29
• 1 vote

1. Documentation
2. ...
3. Labels
4. Mouse over

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...

• View comment
• Edited August 30, 2022 08:43
• 0 votes

1. Community
2. Data Warehouse Developer
3. Data Model editor with models with more than one fact-table?

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...

• View comment
• Created April 06, 2022 07:56
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Hide Columns based on heading not position

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...

• View comment
• Created July 02, 2021 14:05
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Hide Columns based on heading not position

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 ...

• View comment
• Created June 28, 2021 13:43
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Add Row Numbers or use Absolute Reference in an IF calculation

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...

• View comment
• Created May 12, 2021 08:56
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Add Row Numbers or use Absolute Reference in an IF calculation

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...

• View comment
• Created May 11, 2021 14:58
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Add Row Numbers or use Absolute Reference in an IF calculation

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...

• View comment
• Created May 11, 2021 09:59
• 0 votes

1. Community
2. Administrator
3. Which users are occupying our licenses

In Targit Management, go to Logins and double left click on a User Level.This will show Users, Last Logon/Activity datetime and also User Level.

• View comment
• Created February 23, 2021 08:33
• 0 votes