How Would You Optimize The Dimensions?

1.	How Would You Optimize The Dimensions?
Answer» Use as many as possible for performance improvement; Ex: Assume that u have 100 PRODUCTS and 200 CUSTOMERS; if you make one dimension for both ,the size of the dimension will be 20000; if you make individual dimensions then the total number of rows will be 300. Even if you put more than one characterstic per dimension, do the math considering worst case senerio and decide which characterstics may be combined in a dimension. Use as many as possible for performance improvement; Ex: Assume that u have 100 products and 200 customers; if you make one dimension for both ,the size of the dimension will be 20000; if you make individual dimensions then the total number of rows will be 300. Even if you put more than one characterstic per dimension, do the math considering worst case senerio and decide which characterstics may be combined in a dimension.

Answer»

Use as many as possible for performance improvement; Ex: Assume that u have 100 PRODUCTS and 200 CUSTOMERS; if you make one dimension for both ,the size of the dimension will be 20000; if you make individual dimensions then the total number of rows will be 300. Even if you put more than one characterstic per dimension, do the math considering worst case senerio and decide which characterstics may be combined in a dimension.

Use as many as possible for performance improvement; Ex: Assume that u have 100 products and 200 customers; if you make one dimension for both ,the size of the dimension will be 20000; if you make individual dimensions then the total number of rows will be 300. Even if you put more than one characterstic per dimension, do the math considering worst case senerio and decide which characterstics may be combined in a dimension.

Discussion

No Comment Found

Related InterviewSolutions

I Encountered An Issue While Executing An Ess Employee Leave Request (ws20000081). To Explain Further, When An Employee Creates A Leave Request Through Ess, It Goes To His Manager. If The Request Is Logon To R/3 And His Manager Approves The Leave Request Through The Same R/3 Workplace, The Request Goes Back Out From That Screen. This Scenario Works Fine. However, The Problem Starts When I Do The Same Request From His Manager's Portal And I Press The "approve" Button, I Get The Message Saying "information Sent Successfully". I Will Then Press The "ok" Button, And Then Press The Button "quit". When I Double Checked, The Workflow Is Still Sitting At The Manager's Inbox. My Question Is Why Doesn't This Work From The Manager's Portal When The Same Function Is Working Inside The R/3?
Is There Anyway To Undelete Work Items In Sap Workflow After I Have Logically Deleted Them Already?
How Do You Set Up A User To Receive A Pop-up Reminder When He/she Gets A New Wf Message?
Is It Possible To Create Timed Events?
How Do You Set The Workflow In The Transaction Pb40 Of Hr For Functional Mobility?
I Am Currently Using A Standard Task Ts 00008314 (bus2038) To Launch Work Flow When Notification Is Created. Given This, How Can I Define Notification Type (only M1)? Subsequently, How I Can Launch A Pop Up Or Express Message When Notification Is Created?
Is It Possible To Download My Workflows?
It Is A Policy In Our Company That The Security Department Extends The User Validity Period Of Each User Id Every Year End I.e. From 12.31.2005 To 12.31.2006. We Have To Do This Manually Every Year And This Year, I Was Trying To Find Out How To Assign The Validity Period To A Much Later Date Than The Usual Annual Cut Off. Is There A Better Way To Configure This Without Going Through Each User Id Manually?
Is It True That Workflow Is Position Based And Not Person Based? Does It Mean That When A User Quits A Job, The Workflow Will Not Be Affected?
I Have Created A Situation Wherein The 'z' Object In 'swo1' Was Transposed To 'obsolete' By Mistake. After This, I Am Not Able To Edit The Object Anymore. This Message Appears Each Time I Try To Delete The Obsolete Misstep: "obsolete Object Types Cannot Be Changed Again." How Can I Reverse The Mistake?