MDX - tuples or sets must use the same hierarchies in the function

By Unknown -
MDX is totally different from SQL queries. MDX engine thrown back the error when I have given the below query .Here [Color] and [Size] belongs to the same dimension Dim Product.

Fig 1








This is very simple syntax issue. In MDX we should keep all the members of same dimension within the brackets ( ) as showed below.

Fig 2

Comments

  1. AmadeusFebruary 3, 2015 at 7:41 AM

    Thanks for the tip. I ran into the same problem today, thanks a lot!

    ReplyDelete
  2. Jithesh K BalanMarch 24, 2015 at 10:06 PM

    You are welcome Amadeus

    ReplyDelete
  3. AnonymousMarch 30, 2015 at 9:31 AM

    Thanks for your help

    ReplyDelete
  4. NaveenNovember 12, 2015 at 4:51 AM

    Nice Tip .. Thank you

    ReplyDelete
  5. UnknownNovember 26, 2015 at 1:14 AM

    This comment has been removed by the author.

    ReplyDelete
  6. UnknownNovember 26, 2015 at 1:22 AM

    In sql this sub query is like this
    (SELECT SUM(r$_profit_total) FROM V_RELATIONSHIPS WHERE
    (((V_RELATIONSHIPS.RF_Closed = '0')
    AND (V_RELATIONSHIPS.RA_Count_Services = 4)))
    and r_branch_id = br_id ) Profit,


    but in mdx i create this
    SUM(EXISTING{([Relationships Flags].[RF Closed].&[False],
    [Relationships Activity].[RA Count Services].&[4],[Relationships].[R Branch ID]=[Branch].[BR ID])},
    [Measures].[R_ Profit Total])

    but it shows error in profit column

    ReplyDelete
    Replies
    1. Jithesh K BalanNovember 29, 2015 at 9:24 PM

      Can you please paste the error too here. also sample data.

      Delete
  7. UnknownJanuary 12, 2018 at 3:58 AM

    a pride for me to be able to discuss on a quality website because I just learned to make an article on
    cara menggugurkan kandungan

    ReplyDelete
  8. Lily AllenSeptember 19, 2018 at 11:47 PM

    Really Awesome Blog Thanks for Sharing...
    clipping path
    clipping path service
    background removal
    car photo editing

    ReplyDelete
  9. AparnaJune 25, 2019 at 10:49 PM

    Outstanding post and Thank you for sharing such useful information with us. Keep blogging...

    Pega Training in Chennai
    Pega Training
    Spark Training in Chennai
    Oracle DBA Training in Chennai
    Excel Training in Chennai
    Embedded System Course Chennai
    Tableau Training in Chennai
    Power BI Training in Chennai
    Unix Training in Chennai
    Job Openings in Chennai

    ReplyDelete
  10. velrajJune 27, 2019 at 5:59 AM

    Great experience for me by reading this blog. Nice Article.

    Ethical Hacking course in Chennai
    Ethical Hacking Training in Chennai
    Hacking course
    ccna course in Chennai
    Salesforce Training in Chennai
    Angular 7 Training in Chennai
    Web Designing course in Chennai
    Ethical Hacking course in Thiruvanmiyur
    Ethical Hacking course in Porur
    Ethical Hacking course in Adyar

    ReplyDelete
  11. Aditi RayJuly 28, 2019 at 7:09 AM

    TreasureBox is operated by a group of young, passionate, and ambitious people that are working diligently towards the same goal - make your every dollar count, as we believe you deserve something better.
    bedroom furniture nz
    pregnancy pillow nz
    chicken coops nz

    ReplyDelete
  12. shaliniJanuary 31, 2020 at 9:32 PM

    I got some clear information from this blog.. Thanks for taking a time to share this blog...
    Data Science Course in Chennai
    Data Science Courses in Bangalore
    Data Science Course in Coimbatore
    Data Science Course in Hyderabad
    Data Science Institute in Marathahalli
    Data Science Training in Bangalore
    Best Data Science Courses in Bangalore
    Data Science Institute in Bangalore
    Spoken English Classes in Bangalore
    DevOps Training in Bangalore

    ReplyDelete
  13. Sadhana RathoreFebruary 21, 2020 at 2:58 AM

    I want to thank for sharing this blog, really great and informative. Share more stuff like this.
    Ethical Hacking course in Chennai
    Ethical Hacking Training in Chennai
    Hacking course
    ccna course in Chennai
    Salesforce Training in Chennai
    Angular 7 Training in Chennai
    Web Designing course in Chennai
    Ethical Hacking course in Tambaram
    Ethical Hacking course in Anna Nagar
    Tally course in Chennai

    ReplyDelete
  14. dedyMarch 26, 2020 at 7:45 AM

    Thanks dude. You saved my day.

    ReplyDelete
  15. raneedevanApril 20, 2020 at 1:22 AM

    Nice blog, very informative content.Thanks for sharing,waiting for next update...
    Photoshop Classes in Chennai
    Best Place to Learn Photoshop in Chennai
    Photoshop Training Classes in Chennai
    Photoshop Training in Anna Nagar
    Photoshop Training in Tnagar
    Drupal Training in Chennai
    Manual Testing Training in Chennai
    LoadRunner Training in Chennai
    C C++ Training in Chennai

    ReplyDelete
  16. cara menggugurkan kandungan dan mempercepat haidJune 20, 2020 at 12:42 AM

    I thank you for the information and articles you provided

    ReplyDelete
  17. Raj GuptaApril 20, 2021 at 2:24 AM

    Its very impressive information!
    Brokerage calculator

    ReplyDelete
  18. jackr76May 10, 2021 at 4:01 AM

    Finally I’m glad to check this blog because it’s a nice and informative blog.
    Tally Training in Chennai
    CCNA Training Institute in Chennai
    SEO Training Institute in Chennai
    Big Data Course in Chennai
    Cloud Training in Chennai
    Blue Prism Training Institute in Chennai

    ReplyDelete
  19. EddieBrockMay 12, 2021 at 3:40 AM

    It’s a nice blog with very useful information!!!
    Java Training Institute in Chennai
    Selenium Training Institute in Chennai
    Python Classes in Chennai
    AWS Certification in Chennai
    Data Science Certification in Chennai
    DevOps course in Chennai

    ReplyDelete
  20. Ame AutoMay 18, 2021 at 7:27 AM

    This blog is very informative!
    Tyre Repair Canning Vale

    ReplyDelete
  21. cara menggugurkan kandunganMay 28, 2021 at 11:12 AM

    thank you for the information provided, we are waiting for the next info

    ReplyDelete
  22. ModernSuppliesJune 14, 2021 at 3:52 AM

    Rockfon Soffit Range by Modern Supplies

    ReplyDelete
  23. ninositsolutionJuly 5, 2021 at 4:48 AM

    very clearly explained thanks for sharing !
    TALLY TRAINING IN CHENNAI
    TALLY TRAINING INSTITUTE IN CHENNAI
    TALLY ERP 9 CLASSES IN CHENNAI
    TALLY COURSE IN CHENNAI
    GST TALLY TRAINING INSTITUTE IN CHENNAI
    TALLY CLASSES IN CHENNAI
    BEST TALLY TRAINING CENTER IN CHENNAI
    TALLY CERTIFICATION COURSE IN CHENNAI
    TALLY CLASSES IN CHENNAI
    BEST TALLY TRAINING COURSES IN CHENNAI
    BEST TALLY ERP 9 TRAINING IN CHENNAI
    TALLY ERP 9 COURSE IN CHENNAI
    COMPANY ACCOUNTS TRAINING INSTITUTE IN CHENNAI
    COMPANY ACCOUNTS TRAINING IN CHENNAI
    ACCOUNTING COURSES IN CHENNAI
    ACCOUNTS TRAINING CENTER IN CHENNAI
    GST TRAINING INSTITUTE IN CHENNAI
    GST CLASSES IN CHENNAI
    GST TRAINING COURSES IN CHENNAI
    GST CERTIFICATION COURSE IN CHENNAI
    TALLY GST CERTIFICATION TRAINING IN CHENNAI
    BEST TAXATION TRAINING IN CHENNAI
    TAXATION COURSE IN CHENNAI
    TAXATION CLASSES IN CHENNAI
    INCOME TAX CONSULTANT COURSE IN CHENNAI
    BEST TALLY TRAINING IN CHENNAI&VADAPALANI
    BEST TALLY TRAINING COURSES WITH 100% JOB PLACEMENTS & CERTIFICATION

    ReplyDelete
  24. ChristyJuly 5, 2021 at 5:40 AM

    You are sharing excellent information.
    SMO Company in Chennai
    google adwords company in Chennai
    google adwords Services company in Chennai

    ReplyDelete
  25. ninositsolutionJuly 7, 2021 at 4:47 AM

    great!very useful article thanks for sharing
    Java training institute in Chennai
    Java training in Chennai
    Best Java courses institutes
    Java training in Chennai with 100% placements
    Best Java training institute in Chennai
    ONLINE JAVA TRAINING INSTITUTE IN CHENNAI
    BEST JAVA TRAINING IN CHENNAI & VADAPALANI
    CORE JAVA/J2EE TRAINING IN CHENNAI
    BEST NO.1 JAVA TRAINING INSTITUTE IN CHENNAI & VADAPALANI
    JAVA COURSE IN CHENNAI
    JAVA CLASS IN CHENNAI
    JAVA CLASSES IN CHENNAI
    BEST JAVA TRAINING CENTER IN CHENNAI
    JAVA CERTIFICATION COURSE IN CHENNAI
    BEST JAVA TRAINING COURSES WITH 100% JOB PLACEMENTS & CERTIFICATION

    ReplyDelete
  26. DiyalabsJuly 26, 2021 at 4:46 AM

    Thanks for sharing such a helpful, and understandable blog. I really enjoyed reading it.

    Robots for kids
    Robotic Online Classes
    Robotics School Projects
    Programming Courses Malaysia
    Coding courses
    Coding Academy
    coding robots for kids
    Coding classes for kids
    Coding For Kids

    ReplyDelete
  27. EZaccountingAugust 3, 2021 at 3:30 AM

    I Would like to thank you for this article. From this article I got more and more useful information. This is so helpful to me. Keep updating more articles.
    Ubs accounting
    Myob Singapore
    Best Accounting software Singapore

    `

    ReplyDelete
  28. ArnoldDecember 15, 2021 at 11:43 AM

    Thankyou For Sharing Such An Excellent Post Enjoyed Reading it.

    Regards

    microsoft365.com/setup
    micrsoft365.com setup
    microsoft365
    office365.com
    www.primevideo.com/mytv
    primevideo.com/mytv
    123.hp.com/setup
    kashmir honeymoon packages
    best kashmir holiday packages

    ReplyDelete
  29. Microsof 365 SetupJanuary 1, 2022 at 8:38 PM


    Great Post Enjoyed Reading it will come to explore more..

    Regards

    microsoft365.com/setup
    micrsoft365.com setup
    microsoft365
    office365.com
    www.primevideo.com/mytv
    primevideo.com/mytv
    123.hp.com/setup
    best kashmir tour packages
    kashmir honeymoon packages
    kashmir tour and travel

    ReplyDelete
  30. Durai RajJanuary 21, 2022 at 4:45 AM

    Thanks for sharing this blog. It was so informative.
    How to prepare for an online interview
    Online interviews

    ReplyDelete
  31. Himanshu TyagiApril 2, 2022 at 8:56 AM

    THANK YOU for this amazing and for sharing this blog with us, it is very helpful.
    please keep updated us more about like this type of blog.
    If someone is looking for the best java training institute for software training in Ghaziabad, java training institute
    It is the best place from where you get the practical knowledge of java training institute here. You will be an expert in this field after doing the java training.

    ReplyDelete

Post a Comment

Popular posts from this blog

Microsoft BI Implementation - Cube back up and restore using XMLA command

By -
Image
Current BI implementation require to deploy the cube in multiple location to make it available  locally in each location to improve the performance. Cube development happening in one location say X but since the company is having presence in around the world and so business users sits in different locations X, Y and Z. Internet connectivity between X, Y and Z are not good and accessing the cube deployed in X from Y and Z is very slow and it impact the end user productivity. To overcome this issue, cube has to be deployed in Y and Z locally and upload the connection in their local SharePoint as mentioned below.  Fig 1 Now let see how we can automate all these process from taking back up of the cube database to restore it in each location. Follow the below mentioned steps to automate back up and restore of cube database. - select the back up option by right click on the cube database to be backed up and generate the XMLA script after providing necessary proper
Read more

Databricks - incorrect header check

By -
This post I would like to show you how we can fix the problem of " Incorrect header check " received while fetching the data from hive table. Actual message " SparkException: Job aborted due to stage failure: Task 0 in stage 63.0 failed 4 times, most recent failure: Lost task 0.3 in stage 63.0 (TID 3506, 10.1.1.7, executor 28): java.io.IOException: incorrect header check.   at org.apache.hadoop.io.compress.zlib.ZlibDecompressor.inflateBytesDirect(Native Method)     at org.apache.hadoop.io.compress.zlib.ZlibDecompressor.decompress(ZlibDecompressor.java:221)     at org.apache.hadoop.io.compress.DecompressorStream.decompress(DecompressorStream.java:82)     at org.apache.hadoop.io.compress.DecompressorStream.read(DecompressorStream.java:76)     at java.io.InputStream.read(InputStream.java:101) " To better understand the scenario, let me explain how the data got loaded in the hive table. we are storing the data from source systems to RAW layer. H
Read more