Forum Discussion

FlorisvdPoel's avatar
FlorisvdPoel
New Contributor III
3 years ago

Extensible documents - Chart component does not show data in PowerPoint

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 ...
Dashboards
Extensible Documents
  • Cosimo's avatar
    Cosimo
    3 years ago

    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! 

Sai_Maganti's avatar
Sai_Maganti
Contributor II

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.

FlorisvdPoel's avatar
FlorisvdPoel
New Contributor III
3 years ago

Hi Sai,

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

Floris

  • Sai_Maganti's avatar
    Sai_Maganti
    Contributor II
    3 years ago

    Floris

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

    Best

    Sai

    • Cosimo's avatar
      Cosimo
      Contributor II
      3 years ago

      I honestly find it odd that Floris has to include the cube view in the Powerpoint for the chart to render. You would think running the chart would 1st prompt the user to select parameter values but apparently the inserted cube view is performing the prompt and the chart is using the same selected parameters. 

      I guess I got lucky on my end as my xfDocs included cube views and charts that used the same dashboard parameters! 

      • Sai_Maganti's avatar
        Sai_Maganti
        Contributor II
        3 years ago

        Cosimo

        I didn't have to include the CV in the ppt. All I have is my chart with data from my CV and my CV has the parameter and I use the same parameter in the ppt and the alt text has the reference to Chart. Without the parameter included in the ppt the chart don't work for some reason inspite of having the parameter in the CV.

        Sai