When I browse my Cube and drag/drop different elements for calculations I get my results within a second or two. However, my MDX code (created by the Wizard) takes around 6 minutes or so.. let's say I have 10 instances of what I drag/drop for calculation, even so, it should not take more than 10 seconds.. let alone 6 minutues!! thank you so much for your help.
Related Questions in REPORTING-SERVICES
- How to ignore warning errors?
 - Data execution plan ended with error on DB restore
 - Powershell Split a file name
 - PowerShell EWS Save as for e-mails
 - Run SQL Server Update Statement With Powershell
 - using a global variable in multiple functions powershell
 - Heisenberg was here: Aliases for PowerShell parameters only appear in cmdlet help when you do NOT document the cmdlet
 - PowerShell Script to add newuser
 - Why is PowerShell "not recognized" when installing Chocolatey?
 - Enumerate a PSCustomObject as key/value pairs
 
Related Questions in MDX
- How to ignore warning errors?
 - Data execution plan ended with error on DB restore
 - Powershell Split a file name
 - PowerShell EWS Save as for e-mails
 - Run SQL Server Update Statement With Powershell
 - using a global variable in multiple functions powershell
 - Heisenberg was here: Aliases for PowerShell parameters only appear in cmdlet help when you do NOT document the cmdlet
 - PowerShell Script to add newuser
 - Why is PowerShell "not recognized" when installing Chocolatey?
 - Enumerate a PSCustomObject as key/value pairs
 
Related Questions in CUBE
- How to ignore warning errors?
 - Data execution plan ended with error on DB restore
 - Powershell Split a file name
 - PowerShell EWS Save as for e-mails
 - Run SQL Server Update Statement With Powershell
 - using a global variable in multiple functions powershell
 - Heisenberg was here: Aliases for PowerShell parameters only appear in cmdlet help when you do NOT document the cmdlet
 - PowerShell Script to add newuser
 - Why is PowerShell "not recognized" when installing Chocolatey?
 - Enumerate a PSCustomObject as key/value pairs
 
Related Questions in BIDS
- How to ignore warning errors?
 - Data execution plan ended with error on DB restore
 - Powershell Split a file name
 - PowerShell EWS Save as for e-mails
 - Run SQL Server Update Statement With Powershell
 - using a global variable in multiple functions powershell
 - Heisenberg was here: Aliases for PowerShell parameters only appear in cmdlet help when you do NOT document the cmdlet
 - PowerShell Script to add newuser
 - Why is PowerShell "not recognized" when installing Chocolatey?
 - Enumerate a PSCustomObject as key/value pairs
 
Popular Questions
- How do I undo the most recent local commits in Git?
 - How can I remove a specific item from an array in JavaScript?
 - How do I delete a Git branch locally and remotely?
 - Find all files containing a specific text (string) on Linux?
 - How do I revert a Git repository to a previous commit?
 - How do I create an HTML button that acts like a link?
 - How do I check out a remote Git branch?
 - How do I force "git pull" to overwrite local files?
 - How do I list all files of a directory?
 - How to check whether a string contains a substring in JavaScript?
 - How do I redirect to another webpage?
 - How can I iterate over rows in a Pandas DataFrame?
 - How do I convert a String to an int in Java?
 - Does Python have a string 'contains' substring method?
 - How do I check if a string contains a specific word?
 
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
 - Is it possible to use adb commands to click on a view by finding its ID?
 - How to create a new web character symbol recognizable by html/javascript?
 - Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
 - Heap Gives Page Fault
 - Connect ffmpeg to Visual Studio 2008
 - Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
 - How to avoid default initialization of objects in std::vector?
 - second argument of the command line arguments in a format other than char** argv or char* argv[]
 - How to improve efficiency of algorithm which generates next lexicographic permutation?
 - Navigating to the another actvity app getting crash in android
 - How to read the particular message format in android and store in sqlite database?
 - Resetting inventory status after order is cancelled
 - Efficiently compute powers of X in SSE/AVX
 - Insert into an external database using ajax and php : POST 500 (Internal Server Error)
 
                        
Browser creates an unoptimized code in the background. To have a look at the code generated by the browser, click on the "Design Mode" icon.
You will often see the code riddled with number of subcubes, which might seem non-intuitive and ineficient coding practices.
As far as I know, there is no way to control this code. Deal with it! And use MDX to query your cube's data.