Desktop productivity for business analysts and programmers

Format and informat of the drill through table not applied

Reply
Super Contributor
Posts: 326

Format and informat of the drill through table not applied

Hi All,

I'm having problems with the drill through formats. The format set in the source table of the drill through does not apply when the drill through is opened in EG.
The format used is comma25.2 and this can be seen in the metadata, physical table and column properties of the drill through table in OLAP. Unfortunately, when I opened the drill through in EG and checked the column properties, BEST12. is the format specified. How can I modify the format? Howcome it doesn't reflect the format comma25.2?

Thanks!
Respected Advisor
Posts: 4,137

Re: Format and informat of the drill through table not applied

Which SAS version are you using?
Super Contributor
Posts: 326

Re: Format and informat of the drill through table not applied

Hi Patrick,

It's 9.1.3
Respected Advisor
Posts: 4,137

Re: Format and informat of the drill through table not applied

Sounds to me like note 15453 which got fixed with Service Pack 3: http://support.sas.com/kb/15/453.html

http://ftp.sas.com/techsup/download/hotfix/e9_sp_fixes.html

Let us know if you're environment is on this fix level but you still have the issue.

HTH
Patrick
Super Contributor
Posts: 326

Re: Format and informat of the drill through table not applied

Hi Patrick,

I tried installing the hotfix E9BD03 but the issue was not resolved. Do you know the particular hotfix for this? I could not find the specific hotfix that addresses the issue from the hotfix list found in the link you sent.

Thanks!
Respected Advisor
Posts: 4,137

Re: Format and informat of the drill through table not applied

According to the SAS note it's part of SP3 but I couldn't find the exact defect. Just make sure that your Server is at least on Service Pack 3 level.

If it is on SP3 level: Open a track with SAS Tech Support.
Ask a Question
Discussion stats
  • 5 replies
  • 112 views
  • 0 likes
  • 2 in conversation