Skip to Content
author's profile photo Former Member
Former Member

BPC-Data drill down not possible in Excel(not browser)

Hi ,

I do get this error -Data drill down not possible(no data available).I viewed the CV and the seem to be ok.Is there any way i could check tables to see if there is actually any data available?

regards

shyam

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 24, 2008 at 09:38 PM

    If you can, query the database. Or see the SQL tree and you will see the table/ schema.

    Ravi Thothadri

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 24, 2008 at 09:50 PM

    I knew it would be a tough one to give me a direct answer.For instance,when i was trying to have some "new ids" on my dims with some new/changed descriptions i am struggling to see which all tables are impacted on this to have reports/work status's,BPF's changed accordingly...For ex: i change(yes via simple SQL) in the query analyser ,table tbldrillinvoice,then i see its impact in another table..so technically i have to search a whole gamut of tables..I was wondering if somebody was nice enough to give a beginner like me in BPC a gd idea of which all tables would be impacted in which all scenarios(atleast some common tables)

    Yes, i understand that fiddling with tables is not advisable at all,but i am sure a good understanding of tables is reqd.

    thanks

    shyam

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Just so we are all clear, drill down is based on the current hierarchy and dimension you are working with, Drill Through, is based on a SQL query to a table or series of tables that define the underlying details that you are trying toi work within. Driill through requires a query, which is defined by an underlying BPC query table. While, drill through is the on-line drill capacity within a specific dimesion of your deisgn.

      It is only importnat at first to dril down based on a specific dimesional hierachy. While drill though is baed on a detail transaction table developed for that prurpose. Rfere to the help for Drillthrough properties that may a company this process.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 08:54 AM

    James-Thanks very much.Yes i missed out on that one and your suggestion was effective in resolving the issue.

    Petr-Thanks for your detailed explanation as well which was really helpful.Immense thanks to both of you for your support to the BPC Community here.

    I do understand pretty much that i should not play around with the tables.However i am still struggling to see through the tables that would be impacted by the customizations just to get a good feel of whats happening around.I understand this comes out by experience.However i would really appreciate if i could be made aware of the important tables apart from the FAC* tables.I tried searching it out on the Training materials although i fully understand that it would be tough to name them all there.

    regards

    shyam

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.