cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

There is no reason to be in the SQL tables directly and it not recommended and if you break something the support solution is going to be restore from backups. You do not need to do anything in SQL to configure drill-thru or any other administrative process. You absolutly should not be making any changes to structure outside of the BPC Administration. There are a LOT of dependencies that the Admin console manages and validations that are not visible in the SQL table structure and can leave the application corrupted if they are not properly processed and checked.

First, do you have the drill-key property defined in one of the dimensions? If so, do you have a valid drill key and associated query assigned to the specific member in that dimension that you are drilling on?

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Ravi Thothadri