Focal Point
[CLOSED] SSAS Cube data not coming correctly.

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1297068396

July 10, 2020, 06:28 AM
Rajesh Singh Negi
[CLOSED] SSAS Cube data not coming correctly.
Hi Guys,

We are migrating from 8009 to 8207 WF. Some of our reports are created from SSAS Cube, we observed that data from the master file created from CUBE is returning different data in 8009 and 8207 version.

We have a Dimension in CUBE : EMPLOYEE HIRE LOCATION.

Data we are getting in 8009 Environment: [Employee Hire Location].[Locations].[All].&[-3671]

Data in 8207 we are getting : [Employee Hire Location].[Locations].&[-3671]

Due to this we are not getting the data as expected in report.
Can you help me on this is there any changes we need to make ion ADAPTER Settings.

This message has been edited. Last edited by: FP Mod Chuck,


Webfocus 8.x
Windows
PDF,HTML,XLSX
July 10, 2020, 11:16 AM
FP Mod Chuck
Rajesh

You need to open a case with techsupport to figure out what changed.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
July 10, 2020, 11:38 AM
Rajesh Singh Negi
Hi MOD

Thanks for your time.
I will definitely raise a ticket with IBI.


Webfocus 8.x
Windows
PDF,HTML,XLSX
July 15, 2020, 07:53 AM
Rajesh Singh Negi
Hi Guys ,

The issue is solved there was not need to OPEN a case with IBI. It was just a Setting in SSAS Adapter.

Thanks.


Webfocus 8.x
Windows
PDF,HTML,XLSX
July 15, 2020, 10:23 AM
FP Mod Chuck
Which setting was it?


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
October 09, 2020, 08:46 AM
Rajesh Singh Negi
There is one setting in webfocus server on adapters UNIQUENAMESTYLE set to KEYPATH .


Webfocus 8.x
Windows
PDF,HTML,XLSX