Transfer Excel formula and sheet to OAC

Mahgoub S.Mohamed

Summary:

Hi

user is share complex exel file formula and it's need see the same format and layout in OAC please advise me for best way to do this i already prpare data in outside but i found some hard way in calculation in data flow , i attached sample for user requrment

Credit_Health_Panel.xlsx

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Amrita Gupta-Oracle

Hi Mahgoub,

Could you elaborate a bit more on your query. Do you want to know how to prepare the layout, or, how/where to perform the calculations?

Anirban Basu-133546

Hi Mahgoub,

Going by the complexity of the excel , I think its better to avoid data flows as it has limited capabilities.

If you are using any ETL then you can shift the transformations at the ETL layer and then use the tables in OAC .If you are not using any ETL tool , then you can write some PL/SQL code for the same and shift the transformations there .

Thanks

Anirban

Bret Grinslade - Oracle Analytics-Oracle

We definitely have customers that build analyses like these. You have a few options. First -- you can put the raw data in to its own dataset or table. Then you can build calculations off of these data points. Depending on the calculations -- data flows can help. They are especially useful for changing the grain of the underlying data. I think the main thing is to break it up in to different areas/problems. Trying to create "one dataset" that is exactly the same as the output will be a challenge. However, you can definitely create things like this with datasets, calculations, and perhaps data flows.

Alternatively, you could create a data model and a subject area -- this is more setup work, but would give you more flexibility.