Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I'm Having Branch Master table in that I had created one section access based on Branch Region.
Now I want to give a section access to Product Master table based on some products heads.
Is it possible to write 2 section access in one Model???
Else If you have a scenario like this kindly share your section access code or any document
You can use section access on multiple dimensions in a datamodel. Like this.
Section Access;
SA:
LOAD * inline [
ACCESS, USERID,BRANCH, PRODUCT
ADMIN, DOMAIN\Vegar, WEST, DOLL
];
Section Application;
Transactions:
LOAD * inline [
BranchID , ProductId, Date, Value
E, C, 2019-08-12, 100
W, C, 2019-08-12, 200
E, D, 2019-07-01, 200
W, D, 2019-07-02, 222
];
BRANCH:
LOAD * inline [
BranchID, BRANCH
E, EAST
W, WEST
];
PRODUCT:
LOAD * inline [
ProductId, PRODUCT
C, CAKE
D, DOLL
];
If you are connecting fact table with item table you will not be able to follow up on item level only item group. I would keep the item to item master relation and expanded the solution with item group.
NB: In section access both field name and field values should be in upper case.
Any Ideas?
You can use section access on multiple dimensions in a datamodel. Like this.
Section Access;
SA:
LOAD * inline [
ACCESS, USERID,BRANCH, PRODUCT
ADMIN, DOMAIN\Vegar, WEST, DOLL
];
Section Application;
Transactions:
LOAD * inline [
BranchID , ProductId, Date, Value
E, C, 2019-08-12, 100
W, C, 2019-08-12, 200
E, D, 2019-07-01, 200
W, D, 2019-07-02, 222
];
BRANCH:
LOAD * inline [
BranchID, BRANCH
E, EAST
W, WEST
];
PRODUCT:
LOAD * inline [
ProductId, PRODUCT
C, CAKE
D, DOLL
];
Thanks vegar..
In My Sales Application 2 Modules are concatenate with Fact table
I have one Item Master table the columns are
For Sales Module Item_code is unique so i have connect fact table Item_code with Item master Item_code
For Business Plan Module i don't have Item_code level it has Item_Group level Data.
Give some solution for this
Following your first step means
Following Second step means
Item Master | Customer_Master | ||||
Fact_Table | |||||
Item_Code | Customer_Num | ||||
Item_Group | Item_Code | Customer_Name | |||
Item Description | Branch_Code | ||||
Customer_Num | |||||
Company_Code | |||||
Qty | |||||
Branch_Master | Sales_Value | Company_Master | |||
Net_Profit | |||||
Branch_Code | Company_Code | ||||
Branch_name | Company_Name | ||||
Area | |||||
Pincode |
For Business Plan and Sales Module all Master table are same except Item_Master so if i separate business plan as separate table then it forms Circular reference
How means,
Item_Master -> Fact_table -> Customer_Master -> Business_Plan -> Item_Master forms circular reference
My thougth of separating the plan from the fact would look similar to the picture below. Where the field %PlanId is a composit key created by multiple fields.
autonumberhash256(Item_Code, Branch_Code ,Customer_Num, Company_Code) as %PlanID,
You might even want to include period into that key if you have a plan value per period.
In Business Plan table there is no Item_Code column
In Business Plan table following Fields are there,
I see, I forgot about the ItemCode. My thougth was that you should leave the item out of the key field.
I notice you got item group in the plan and not in the sales.
Maybe the best way to solve your issue is just to move the information about item group from the ItemCode table into the fact table. You could just add it to the sales transactions using a simple applymap.
ItemGroupMap:
MAPPING
LOAD
Item_Code
Item_Group
FROM ItemCode;
Fact:
LOAD
Item_Code,
applymap('ItemGroupMap', Item_Code) as Item_Group
Branch_Code ,
Customer_Num,
Company_Code,
Qty,
Sales_Value,
Net_Profit
FROM Sales;
This solution also i'm given to my Head but they told in Item master Table,Item_code is Unique because for one Item group multiple Item_Code in Master table.
If i connect item group column with Fact table and item Master table is there any performance degradation???