Skip to main content
F
FlorisvdPoel
Contributor
September 30, 2022
Solved

Extensible documents - Chart component does not show data in PowerPoint

  • September 30, 2022
  • 2 replies
  • 0 views

Hi everyone,

I am trying to retrieve a Chart (Advanced) in my PowerPoint presentation, making use of the Alt Text functionality and extensible documents.

The chart component works perfectly fine in OneStream. I can see the chart and correct the data. However, when I open the PowerPoint containing a picture with the Alt Text, I get the following message:

FlorisvdPoel_0-1664535883006.png

The message prompts that there are no parameters for the selected item. However, my data adapter is linked to a cube view, which has an entity selection parameter in the cube view POV. When I click 'OK', the PowerPoint opens, but the chart area is empty. When I hardcode the entity in the cube view that is used as a source for the data adapter, I get the exact same error message, but the chart area is populated with data. 

Therefore, I think I'm doing something wrong with the parameter settings of the Chart (advanced) component. However, I cannot figure out what I'm doing wrong. 

Any help would be very much appreciated.

Thanks,

Floris

    Best answer by Cosimo

    Since your underlying data source is a cube view, have you tried generating the cube view within your document? {XF}{Application}{CubeViewReport}{YouCubeView}?

    If it doesn't work with the cube view, then there may be other underlying issues. Can you have someone else try to run the xfDoc from another computer.

    Another thought that comes to mind  is to ensure that your cube view's POV is set to the exact dimension members required to run and that none of the dimensions rely on a user session's POV (i.e. the POV bar on the right panel). 

    Hope any of this helps! 

    2 replies

    C
    CosimoAnswer
    Contributor
    September 30, 2022

    Since your underlying data source is a cube view, have you tried generating the cube view within your document? {XF}{Application}{CubeViewReport}{YouCubeView}?

    If it doesn't work with the cube view, then there may be other underlying issues. Can you have someone else try to run the xfDoc from another computer.

    Another thought that comes to mind  is to ensure that your cube view's POV is set to the exact dimension members required to run and that none of the dimensions rely on a user session's POV (i.e. the POV bar on the right panel). 

    Hope any of this helps! 

      F
      FlorisvdPoelAuthor
      Contributor
      September 30, 2022

      Hey Cosimo,

      Thanks for your answer. Adding the cube view to the PowerPoint xfdoc file did the trick! 

      It also did not work on other computers. And the POV was setup okay.

       

      I am really confused about this workaround. It should not be the case right that the cube view behind the chart should also be in the document for it to work? I have also tried just adding a text box with an XFGetMemberProperty in it so that the parameter would be in the document. However, also no luck. The cube view solution is the only thing that works now. 

      Thanks for your help, enjoy your weekend!

       

      S
      Sai_Maganti
      Newcomer
      September 30, 2022

      For the chart component to work with parameters you need to put the parameter inside the powerpoint file some where just above the image. This way when you run the ppt from OneStream you'll get prompted for the parameter and then the chart will display acordingly.

        F
        FlorisvdPoelAuthor
        Contributor
        September 30, 2022

        Hi Sai,

        When solely adding the parameter to the powerpoint, the chart component does not work. It has to be the cube view.

        Floris

        S
        Sai_Maganti
        Newcomer
        September 30, 2022

        Floris

        It is enough your chart data comes from the cube view.

        Best

        Sai

        Terms & ConditionsAccessibility statement