Question Re: Data description import from different file in Technology Q&A

Data description import from different file

JoãoPiteira — Sun, 08 Sep 2024 13:36:12 GMT

Hello!

I'm doing a budget plan in Sap Analytics Cloud. Right now i have a excel file with all my core data, which is sorted with a lot of economic codes (example: 1.1 , 1.0.1 etc), each code has a description (example: 1.0.1 - technology spendings), the descriptions are in a separate excel file, which connects every code with its description.

Is there any way to import the descriptions excel file to my existing model and match the core file codes with the second files description? In a way that i could have a "Description" dimension.

Re: Data description import from different file

William_Yu1 — Mon, 09 Sep 2024 04:28:16 GMT

Hi JoãoPiteira,

If economic codes is a dimension, you can make it as a public dimension. With that, you can import the second file with code and its description imported by mapping to the description column of the dimension.

Best regards, William

Re: Data description import from different file

JoãoPiteira — Tue, 10 Sep 2024 13:16:37 GMT

This worked, thank you! If i may ask another question, if i want to have a column with the code description instead of a description associated to the same column. Is this possible?

Re: Data description import from different file

William_Yu1 — Wed, 11 Sep 2024 00:58:51 GMT

You can select to display property description in the more option of dimension in row axis