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. 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
  8. 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
  9. 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
  10. 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
  11. dedyMarch 26, 2020 at 7:45 AM

    Thanks dude. You saved my day.

    ReplyDelete
  12. 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
  13. cara menggugurkan kandungan dan mempercepat haidJune 20, 2020 at 12:42 AM

    I thank you for the information and articles you provided

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

    Its very impressive information!
    Brokerage calculator

    ReplyDelete
  15. 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
  16. Ame AutoMay 18, 2021 at 7:27 AM

    This blog is very informative!
    Tyre Repair Canning Vale

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

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

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

    Rockfon Soffit Range by Modern Supplies

    ReplyDelete
  19. 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
  20. 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
  21. 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
  22. 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
  23. 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
  24. 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