Skip to Content
avatar image
Former Member

Heirarchy drill in Offline mode - Analysis for Office

Hey,

I have saved Workbook on my local desktop and is now in offline mode. During saving I made sure that the Hierarchy has been drilled down to the lowest level.

However, in offline version, I cannot drill up and down the hierarchy node. Is this possible ? I don't want to create like 25 users in BW just to distribute the offline reports?

Do you have any other suggestion?

Thanks in advance! Best, Vitali

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 19, 2017 at 12:02 PM

    Analysis Office doesn't support offline features; for this functionality you need to be connected to the BW system

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 19, 2017 at 12:30 PM

    Thanks Tammy !

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19, 2017 at 03:57 PM

    Hi,

    you could build a PivotTable in Excel and use this to drill down & up. Maybe this solves your issue.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Vitali,

      you could build a normal Pivot Table without any cell style stuff. The only thing you have to know is when you Display key and text, the headline is only in one field, so Pivot Table wouldn't work. But for this read this post (point 5) and I think your problem should be solved.