SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

data flow from cubes to SAS Portal

Reply
Occasional Contributor
Posts: 12

data flow from cubes to SAS Portal

Hi All,

 

I am facing an issue where the SAS portal is displaying values which are not in the SAS dataset which sources it. Lo0oks like there is an issue with the OLAP cube formation.

What should be done in such a scenario?

 

Regards,
Sreelekha

Super User
Posts: 9,940

Re: data flow from cubes to SAS Portal

Posted in reply to Sreelekha

Follow the flow of data back. Look at the definition of the web report, then at the information map referenced in the report, and finally at the cube referenced in the information map. You might have a drill-through table with values that do not match the base table (for instance).

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Super User
Posts: 5,853

Re: data flow from cubes to SAS Portal

Posted in reply to Sreelekha

Looks like normal trouble shooting.

Check when and how the cube i generated/updated.

Is the cube structure ok, ot could there be calculations or other structural issues (depending on what type of data you/analysis req).

Data never sleeps
Occasional Contributor
Posts: 12

Re: data flow from cubes to SAS Portal

The issue is the same cube sources the other columns as well. Those values are exactly correct. There is only one column whose valyes are appearing wrong.

Super User
Posts: 9,940

Re: data flow from cubes to SAS Portal

Posted in reply to Sreelekha

How far off are the values? You could either have a numeric precision issue (very small deviation) or an incorrectly used statistic (average instead of sum, for instance, causing a big deviation). Also look if some kind of security is applied via the information map that causes certain values to miss.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 4 replies
  • 150 views
  • 0 likes
  • 3 in conversation