Error in uploading time hierarchy data to the cloud

[Kawamoto]

I am having a trouble in updating a dataset with a time hierarchy.

I created a dataset in the local LUMIRA desktop from an excel sheet, add a time hierarchy, and tried to upload the dataset to the LUMIRA cloud. However, the system gave me an error and will not accept the data.

Could anyone having the same problem help me on how you have worked around this problem?

Thank you very much for your help and advice.

Kentaro Kawamoto

[TammyPowlas · Accepted solution]

Hi Kentaro - I just tried it and it works for me.

Could you share a screen shot of how your data looks in Excel?  How does the hierarchy look in Lumira?

[Kawamoto · Accepted solution]

Dear Tammy,

Thank you very much for replying. Please let ma attach the screen copies.

It will be nice if you could have a glance at them and provide some feedback if I am doing wrong procedures.

The screens are copied from works in the local LUMIRA desktop.

Excel data looks like below. Year and month data are present

I created hiearchy for year and month, let system create Quarterly data.

As a sample, I created a graph for sales by month.

After composing the graph to a story, I upload the story and dataset to the cloud.

System returns error.

[TammyPowlas · Accepted solution]

Hello Kentaro - I do not see anything wrong with your workflow.  Thank you for posting these details.

However I found this SAP Note http://service.sap.com/sap/support/notes/1995364 that SAP Development is looking into this error. 

Did you download SP1 for Lumira 1.15?  If so I recommend sending this issue to SAP Support.

[Kawamoto · Accepted solution]

Dear Tammy,

Thank you very much for checking my screen. It came up that I did not use the date field. I fixed my excel and changed the column property from starndard to date. Then I had no problem uploading.

Thank you very much for taking time and gives me the information.

Best Regards.

Kentaro Kawamoto

[achab · Accepted solution]

Hi Kentaro,

Is the modification in the Excel file the only thing you did to fix publishing?

Thanks

Antoine