drill down is not working

Posted by: albert2014 on 3 August 2017, 4:04 pm EST

  • Posted 3 August 2017, 4:04 pm EST

    I download ActiveAnalysis trail version and use it on asp.net web page.
    I use "SQl Server Profiler" to trace the MDX Query.


    now I have a cube, it is working on BI 2008. there is a hierarchy like below:

    CustKey
    ----CustName
    --------CustID

    one "CustKey" has more "CustName", one "CustName" has more "CustID".

    1. drag the hierarchy to Rows:

    WITH MEMBER [Measures].[Apache Constant] AS '1' SELECT NON EMPTY {(HIERARCHIZE({{[Customer].[Customer Hierarchy].[All]},{[Customer].[Customer Hierarchy].[Cust Key].ALLMEMBERS AS [apache set 0]}}))} DIMENSION PROPERTIES [PARENT_UNIQUE_NAME], [MEMBER_UNIQUE_NAME] ON AXIS(0) FROM [Aged Receivables] WHERE {([Measures].[Apache Constant])} CELL PROPERTIES VALUE, FORMAT_STRING
    SELECT ADDCALCULATEDMEMBERS( [Customer].[Customer Hierarchy].[Cust Key].&[#].CHILDREN ) DIMENSION PROPERTIES MEMBER_NAME, MEMBER_TYPE ON 0, {} ON 1 FROM [Aged Receivables]

    2. drill down the "CustKey" is "'"

    WITH MEMBER [Measures].[Apache Constant] AS '1' SELECT NON EMPTY {(HIERARCHIZE({{[Customer].[Customer Hierarchy].[All]},{[Customer].[Customer Hierarchy].[Cust Key].ALLMEMBERS AS [apache set 0],INTERSECT(DRILLDOWNLEVEL([apache set 0]),{[Customer].[Customer Hierarchy].[Cust Name].&[`]&[`cheng Hon wing],[Customer].[Customer Hierarchy].[Cust Name].&[`]&[`rivera Roque]}) AS [apache set 1]}}))} DIMENSION PROPERTIES [PARENT_UNIQUE_NAME], [MEMBER_UNIQUE_NAME] ON AXIS(0) FROM (SELECT (STRIPCALCULATEDMEMBERS({{{[Customer].[Customer Hierarchy].[Cust Key].ALLMEMBERS AS [apache set 2],INTERSECT(DRILLDOWNLEVEL([apache set 2]),{[Customer].[Customer Hierarchy].[Cust Name].&[`]&[`cheng Hon wing],[Customer].[Customer Hierarchy].[Cust Name].&[`]&[`rivera Roque]}) AS [apache set 3]} AS [apache set 4]} - GENERATE([apache set 4] AS [apache set 5], ASCENDANTS([apache set 5].CURRENT) - [apache set 5].CURRENT)})) ON AXIS(0) FROM [Aged Receivables]) WHERE {([Measures].[Apache Constant])} CELL PROPERTIES VALUE, FORMAT_STRING
    SELECT ADDCALCULATEDMEMBERS( [Customer].[Customer Hierarchy].[Cust Name].&[`]&[`cheng Hon wing].CHILDREN ) DIMENSION PROPERTIES MEMBER_NAME, MEMBER_TYPE ON 0, {} ON 1 FROM [Aged Receivables]

    3. drill down the "CustName" is "`cheng Hon wing":

    I cannot find "With Member" query like about, and only "Select ADDCALCULATEDMEMBERS" query, the problem is the query is for all "custname", not the "`cheng Hon wing". there are over 150000 cust names. so supper slow and not correct.


    Now, my question is this version is just working for 2 levels hierarchy or something I am missing?

    Thanks

  • Replied 3 August 2017, 4:04 pm EST

    Hello,

    Thanks for the schema. We tried to replicate the scenario at our end but the query string with the words “With Member” is generated at our end for the hierarchy i.e. Promotions in the dimension Promotions. The query string is generated after "Select ADDCALCULATEDMEMBERS" query. Hence, I would request you to share the dummy cube so that we can test the issue with your database. You can upload the cube on portal or we can share our FTP link for same.

    You can also refer to the attached screenshots displaying the behavior at our end.

    Regards



  • Replied 3 August 2017, 4:04 pm EST

    Thanks Ashish. I can send the structure to you. details in attach.
    2015/01/Aged-Receivables-Cube-Info.zip
  • Replied 3 August 2017, 4:04 pm EST

    Hello,

    I am trying to replicate the issue at my end and would get back to you as soon as possible. In between, if you can provide the sample cube then it would really help us in replicating the issue.

    Regards
  • Replied 3 August 2017, 4:04 pm EST

    the attach file is screen shot for query. Black part is for drill down "Cust Key" ("1"), when I drill down "Cust name" for "1", the query in Red part will run first. so I think it takes long time to load if "2" has lots of "Cust Name".

    Please advice. Thanks again.
    2015/01/Capture.zip
  • Replied 3 August 2017, 4:04 pm EST

    Thanks Ashish.

    the attach file is the cube with some sample data.

    the hierarchy in "Customer" dimension is "Customer Hierarchy", there are 2 "cust key", "1" and "2". I test on my local.

    the problem is the queries will run "SELECT ADDCALCULATEDMEMBERS" for "2" first when I drill down the "cust name" of "1", and run "WITH MEMBER [Measures].[Apache Constant]....".

    so if I have a lots "Cust name" in "2"(like 15000 records), the query "SELECT ADDCALCULATEDMEMBERS" will be run 15000 times. it takes long time to load data.


    2015/01/UCEBilling.zip
  • Replied 3 August 2017, 4:04 pm EST

    Hello Albert,

    Since, we are handling this issue on forum, the ticket in the portal is automatically closed. Hence, you have recieved the closure mail.

    Regarding the issue, the development team is still working on it and I am waiting for their reply. I would update you as soon as I get any information from them.

    Regards
  • Replied 3 August 2017, 4:04 pm EST

    Ashish, I got 2 emails today, like below:

    1.

    Request ID: 101477 has been updated.

    As we have not heard back from you, we are closing this case on our side for now.
    Incase you would require further assistance or have any questions related to this
    case, you need to reopen the case.

    Case ID: 101477

    Title: (GrapeCity ActiveAnalysis) Drilling Down is not working
    Status: Waiting for verification
    Updated Date: Friday, January 09, 2015 1:48:37 PM
    URL: http://supportone.componentone.com/casedetail/101477




    and I try to open the URL, but not working.


    2.

    Your feedback is important to us! Please take a moment to fill out the attached Satisfaction Survey regarding our support services and products.

    Regards,
    Technical Support Team
    ComponentOne, a division of GrapeCity
    www.componentone.com

    Complete Survey


    and I click "Complete Survey" link, it is nothing either.



    what I need to do? one more thing is do you got any solution about my question from your team?

    Thanks
  • Replied 3 August 2017, 4:04 pm EST

    Thanks Ashish.
  • Replied 3 August 2017, 4:04 pm EST

    Hello Albert,

    Thanks for the files. I could observe that the query i.e. "SELECT ADDCALCULATEDMEMBERS" for "2″ will run when we drill down the "cust name" of "1″ and have escalated it to the development team(177437) for review. I would update you as soon as I get anything from them.

    Regards
  • Replied 3 August 2017, 4:04 pm EST

    Hello Albert,

    As per the development team, the observed behavior is due to the current design of the ActiveAnalysis. I have requested them to change the same so that the performance can be improved. It won't be a small fix so it might take some time. I would keep you posted as I hear anything further from the development team.

    Regards
  • Replied 3 August 2017, 4:04 pm EST

    Hello Albert,

    Generally, we upload big files on our FTP server and send the link to our customers. I tried this FTP link on external network as well and the file started downloading instantly. I would suggest you to try on any other browser like Chrome or try using FileZilla.

    Regards
  • Replied 3 August 2017, 4:04 pm EST

    Hi Ashish,

    One week past, do you get any info?

    thanks
  • Replied 3 August 2017, 4:04 pm EST

    the error is "Internet Explorer cannot display the webpage". My network administrator say the link may be just work for your internal internet. Would you please double check for me?
  • Replied 3 August 2017, 4:04 pm EST

    Hello,

    I opened the link in the browser and the file started downloading at my end. Can you let me know if you facing any error while doing so ? Else, can you ask you network team to download the same for you ?

    Regards
  • Replied 3 August 2017, 4:04 pm EST

    I cannot open the link. Would you please double check?
  • Replied 3 August 2017, 4:04 pm EST

    Hello Albert,

    The development team has improved the behavior in the private build 982 which you download from the following link:
    ftp://ftp.componentone.com/SupportFTP/Public/Ashish/ActiveAnalysis_982.zip

    Can you check and let me know if it works for you ?

    Regards
  • Replied 3 August 2017, 4:04 pm EST

    I still cannot find any files you shared with me.

    Would you please give me a call when you are available?

    Albert 832-466-5177

    Thanks
  • Replied 3 August 2017, 4:04 pm EST

    I can see the files but download failed.



  • Replied 3 August 2017, 4:04 pm EST

    Hello Albert,

    I have shared the FTP credentials through the support ticket 102488.

    regards
  • Replied 3 August 2017, 4:04 pm EST

    "Access is denied" when I click "Support" folder from FileZilla. details like below:

    Status: Resolving address of ftp.componentone.com
    Status: Connecting to 208.103.114.109:21...
    Status: Connection established, waiting for welcome message...
    Status: Insecure server, it does not support FTP over TLS.
    Status: Server does not support non-ASCII characters.
    Status: Connected
    Status: Retrieving directory listing of "/SupportFTP/Public/Ashish/ActiveAnalysis_982.zip"...
    Status: Server sent passive reply with unroutable address. Using server address instead.
    Status: Directory listing of "/" successful
    Status: Retrieving directory listing of "/Support"...
    Command: CWD /Support
    Response: 550 /Support: Access is denied.
    Error: Failed to retrieve directory listing
  • Replied 3 August 2017, 4:04 pm EST

    my Microsoft account : lgxdo100@yahoo.com.

    please tell me more details about how to download after you share with me using OneDrive.

    Thanks
  • Replied 3 August 2017, 4:04 pm EST

    I cannot see any file you shared with me.

    would you please double check for me?

    it is possible I can call you if I have any question?



  • Replied 3 August 2017, 4:04 pm EST

    Hello,

    I have shared the file via OneDrive.

    Regards
  • Replied 3 August 2017, 4:04 pm EST

    Hello Albert,

    Thank you for sharing the FTP credetials with us.
    However, I have lately received an update from the QA team that the build in discussion has some critical issues and cannot be provided to any of our customer.

    I deeply regret that the respective build cannot be provided to you as it might result in some other issues at your end.

    This issue needs a complex fix and unfortunately, it would take some more time. I would keep you posted as I recieve any further update from the development team.

    Regards,
    Ashish
  • Replied 3 August 2017, 4:04 pm EST

    I have not received any email from Microsoft Online Services regarding the file you shared with me.

    and I cannot open the the link in chrome.

    I can send login info to you if you want to try login my personal Microsoft Account to check.


    and it is possible call me or "go to meeting", I think this is easy way to figure out the problem.

    thanks
  • Replied 3 August 2017, 4:04 pm EST

    Hello Albert,

    I tried the same with my personal email ID and received a mail that a file has been shared. Didn't you recieve any mail on your email id i.e. lgxdo100@yahoo.com from Microsoft Online Services regarding the file ?

    Also, can you try to open the following link in Chrome and let me know if it works for you ?
    ftp://ftp.componentone.com/SupportFTP/Public/Ashish/ActiveAnalysis_982.zip

    Regards
  • Replied 3 August 2017, 4:04 pm EST

    almost 2 months pass. Do you know how long the development team can fix the issue?

  • Replied 3 August 2017, 4:04 pm EST

    Hello Albert,

    As mentioned earlier, the fix is not a simple one and would require major changes. The developers did try to incorporate the fix but that resulted in some critical issues which may hamper other existing users.

    Hence, I regret to mention but I do not have any ETA as of now. ​

    Regards
  • Replied 3 August 2017, 4:04 pm EST

    Ashish,

    please upload the files to our ftp server.

    Host: 209.163.240.41
    Login: texpo
    Pass: E"74A66phS&'3hs


    Thanks
  • Replied 3 August 2017, 4:04 pm EST

    please let me know if you are ready.

    thanks Ashish
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels