Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Dimension to Fact table
12-12-2021
10:08 PM
Hello,
i have two tables and are linked with PO number:
fact table:
and dimension table:
i want to add calculated column LOA/PO issuance date to Fact table
how can i do this, could you please help me
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-12-2021
11:38 PM

@Anonymous ,
New column in fact
= related(fact[LOA/PO issuance date])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-12-2021
11:38 PM

@Anonymous ,
New column in fact
= related(fact[LOA/PO issuance date])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
09-04-2024 12:50 AM | |||
04-01-2023 03:12 AM | |||
09-04-2024 04:22 AM | |||
10-24-2023 11:50 PM | |||
10-11-2023 09:27 PM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
107 | |
87 | |
80 | |
54 | |
46 |