Jason Ash

Dimension Reference Table In Memory Data Model Setup

1. Community
2. Data Warehouse Developer

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

• Created March 07, 2023 08:16
• 1 follower
• 0 comments
• 0 votes

Column Order Number to be used in Row Calculation

1. Community
2. Frontend, Designer and Consumer

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

• Edited May 06, 2022 08:14
• 1 follower
• 0 comments
• 0 votes

Hide Columns based on heading not position

1. Community
2. Frontend, Designer and Consumer

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

• Created June 28, 2021 13:07
• 3 followers
• 5 comments
• 0 votes

Add Row Numbers or use Absolute Reference in an IF calculation

1. Community
2. Frontend, Designer and Consumer

(Targit Version 2019.4 build 17106) I have a column where I need to use a different calculation depending on the row. I know row 3 and 5 will always be the rows needing a different calculation so t...

• Edited May 11, 2021 09:38
• 3 followers
• 7 comments
• 0 votes

Schedule Export to Sharepoint Excel Format

1. Community
2. Frontend, Designer and Consumer

Can I schedule exports to Sharepoint in Excel format?(Targit Version 2019.4 build 17106)

• Created April 27, 2021 10:42
• 2 followers
• 1 comment
• 0 votes