Authorization issue during Jump Query in BI

[Former Member]

Hi,

We are facing an issue in BI system, whr user is trying to use and query and jump query [also called, report to report interface (RRI) ]

But user is getting authorization error while jumping from main query to the other query?

Could you please help on how to identify what authorization is missing?

Thanks,

Umesh C

[Former Member]

Hi Umesh,

RSECADMIN is used for BI Analysis auth traces and usual ST01 for generic authorization traces. Did you try these 2 primary tools provided by SAP to get to the cause.. Let us know the inforjmation that you get form these 2 tools so that we can help.

~Sri

[Former Member]

Umesh,

We had a issue where jump reports were not working from BI to ECC. Error was "Transaction ENTR is unknown". It was solved by adding t-code RSRR_WEB (Report Report Interface in WEB) to users in ECC target system.

Please see the below link as well...[Transaction ENTR is unknown|;

[Former Member]

Thx for the reply...

Here the user is trying to jump from one query to another query...

ST01 is not having any error logs, but rsecadmin te error log shows the below details, But I am not able to identify the issue:

Please assist....

All Authorizations Tested

Message EYE007: You do not have sufficient authorization

No Sufficient Authorization for This Subselection (SUBNR)

Following CHANMIDs Are Affected:

6 ( 0COMP_CODE )

38 ( 0CREDITOR )

Thanks...

Umesh

[Former Member]

Can you please provide the complete error log..could be that user running the query need to have # and : values in the Analysis authorizations assigned to them or their role for the mentioned dimensions 0Comp_code and 0Creditor.

[Former Member]

Characteristic Content(in SQL Format)

0COMP_CODE

0CREDITOR

0TCAACTVT

( 0COMP_CODE < '0104'

OR 0COMP_CODE > '0105'

AND 0COMP_CODE < '0110'

OR 0COMP_CODE > '0111'

AND 0COMP_CODE < '0129'

OR 0COMP_CODE > '0130'

AND 0COMP_CODE < '0147'

OR 0COMP_CODE > '0149'

AND 0COMP_CODE < '0215'

OR 0COMP_CODE > '0216'

AND 0COMP_CODE < '0234'

OR 0COMP_CODE > '0235'

AND 0COMP_CODE < '0253'

OR 0COMP_CODE > '0254'

AND 0COMP_CODE < '0297'

OR 0COMP_CODE > '0298'

AND 0COMP_CODE < '0304'

OR 0COMP_CODE > '0305'

AND 0COMP_CODE < '0325'

OR 0COMP_CODE > '0331'

AND 0COMP_CODE < '0400'

OR 0COMP_CODE > '0401'

AND 0COMP_CODE < '0403'

OR 0COMP_CODE > '0405'

AND 0COMP_CODE < '0407'

OR 0COMP_CODE > '0408'

AND 0COMP_CODE < '0411'

OR 0COMP_CODE > '0412'

AND 0COMP_CODE < '0414'

OR 0COMP_CODE > '0415'

AND 0COMP_CODE < '0422'

OR 0COMP_CODE > '0424'

AND 0COMP_CODE < '0480'

OR 0COMP_CODE > '0481'

AND 0COMP_CODE < '0483'

OR 0COMP_CODE > '0485'

AND 0COMP_CODE < '0500'

OR 0COMP_CODE > '0503'

AND 0COMP_CODE < '0505'

OR 0COMP_CODE > '0508'

AND 0COMP_CODE < '0510'

OR 0COMP_CODE > '0513'

AND 0COMP_CODE < '0515'

OR 0COMP_CODE > '0516'

AND 0COMP_CODE < '0518'

OR 0COMP_CODE > '0523'

AND 0COMP_CODE < '0525'

OR 0COMP_CODE > '0526'

AND 0COMP_CODE < '0528'

OR 0COMP_CODE > '0529'

AND 0COMP_CODE < '0530'

OR 0COMP_CODE > '0532'

AND 0COMP_CODE < '0537'

OR 0COMP_CODE > '0538'

AND 0COMP_CODE < '0540'

OR 0COMP_CODE > '0545'

AND 0COMP_CODE < '0547'

OR 0COMP_CODE > '0548'

AND 0COMP_CODE < '0550'

OR 0COMP_CODE > '0551'

AND 0COMP_CODE < '0553'

OR 0COMP_CODE > '0555'

AND 0COMP_CODE < '0557'

OR 0COMP_CODE > '0558'

AND 0COMP_CODE < '0560'

OR 0COMP_CODE > '0561'

AND 0COMP_CODE < '0568'

OR 0COMP_CODE > '0569'

AND 0COMP_CODE < '0573'

OR 0COMP_CODE > '0577'

AND 0COMP_CODE < '0579'

OR 0COMP_CODE > '0582'

AND 0COMP_CODE < '0585'

OR 0COMP_CODE > '0586'

AND 0COMP_CODE < '0590'

OR 0COMP_CODE > '0594'

AND 0COMP_CODE < '0602'

OR 0COMP_CODE > '0603'

AND 0COMP_CODE < '0618'

OR 0COMP_CODE > '0626'

AND 0COMP_CODE < '0635'

OR 0COMP_CODE > '0637'

AND 0COMP_CODE < '0642'

OR 0COMP_CODE > '0644'

AND 0COMP_CODE < '0648'

OR 0COMP_CODE > '0649'

AND 0COMP_CODE < '0690'

OR 0COMP_CODE > '0691'

AND 0COMP_CODE < '0731'

OR 0COMP_CODE > '0733'

AND 0COMP_CODE < '0790'

OR 0COMP_CODE > '0791'

AND 0COMP_CODE < '0824'

OR 0COMP_CODE > '0825'

AND 0COMP_CODE < '0870'

OR 0COMP_CODE > '0871'

AND 0COMP_CODE < '0895'

OR 0COMP_CODE > '0896'

AND 0COMP_CODE < '0912'

OR 0COMP_CODE > '0913'

AND 0COMP_CODE < '0962'

OR 0COMP_CODE > '0963'

AND 0COMP_CODE < '1006'

OR 0COMP_CODE > '1007'

AND 0COMP_CODE < '1010'

OR 0COMP_CODE > '1011'

AND 0COMP_CODE < '1024'

OR 0COMP_CODE > '1029'

AND 0COMP_CODE < '1055'

OR 0COMP_CODE > '1056'

AND 0COMP_CODE < '1058'

OR 0COMP_CODE > '1061'

AND 0COMP_CODE < '1097'

OR 0COMP_CODE > '1100'

AND 0COMP_CODE < '1108'

OR 0COMP_CODE > '1109'

AND 0COMP_CODE < '1112'

OR 0COMP_CODE > '1124'

AND 0COMP_CODE < '1126'

OR 0COMP_CODE > '1136'

AND 0COMP_CODE < '1138'

OR 0COMP_CODE > '1139'

AND 0COMP_CODE < '1172'

OR 0COMP_CODE > '1175'

AND 0COMP_CODE < '1179'

OR 0COMP_CODE > '1181'

AND 0COMP_CODE < '1200'

OR 0COMP_CODE > '1224'

AND 0COMP_CODE < '1228'

OR 0COMP_CODE > '1229'

AND 0COMP_CODE < '1231'

OR 0COMP_CODE > '1234'

AND 0COMP_CODE < '1236'

OR 0COMP_CODE > '1237'

AND 0COMP_CODE < '1325'

OR 0COMP_CODE > '1326'

AND 0COMP_CODE < '1503'

OR 0COMP_CODE > '1504'

AND 0COMP_CODE < '1651'

OR 0COMP_CODE > '1663'

AND 0COMP_CODE < '1667'

OR 0COMP_CODE > '1675'

AND 0COMP_CODE < '1677'

OR 0COMP_CODE > '1683'

AND 0COMP_CODE < '1686'

OR 0COMP_CODE > '1688'

AND 0COMP_CODE < '1700'

OR 0COMP_CODE > '1704'

AND 0COMP_CODE < '1707'

OR 0COMP_CODE > '1720'

AND 0COMP_CODE < '1727'

OR 0COMP_CODE > '1731'

AND 0COMP_CODE < '1788'

OR 0COMP_CODE > '1796'

AND 0COMP_CODE < '1800'

OR 0COMP_CODE > '1801'

AND 0COMP_CODE < '1889'

OR 0COMP_CODE > '1895'

AND 0COMP_CODE < '1905'

OR 0COMP_CODE > '1906'

AND 0COMP_CODE < '1910'

OR 0COMP_CODE > '1912'

AND 0COMP_CODE < '1920'

OR 0COMP_CODE > '1926'

AND 0COMP_CODE < '1976'

OR 0COMP_CODE > '1977'

AND 0COMP_CODE < '2001'

OR 0COMP_CODE > '2003'

AND 0COMP_CODE < '2006'

OR 0COMP_CODE > '2019'

AND 0COMP_CODE < '2205'

OR 0COMP_CODE > '2208'

AND 0COMP_CODE < '2300'

OR 0COMP_CODE > '2307'

AND 0COMP_CODE < '2315'

OR 0COMP_CODE > '2325'

AND 0COMP_CODE < '2365'

OR 0COMP_CODE > '2366'

AND 0COMP_CODE < '2380'

OR 0COMP_CODE > '2381'

AND 0COMP_CODE < '2394'

OR 0COMP_CODE > '2395'

AND 0COMP_CODE < '2453'

OR 0COMP_CODE > '2454'

AND 0COMP_CODE < '2489'

OR 0COMP_CODE > '2493'

AND 0COMP_CODE < '2500'

OR 0COMP_CODE > '2505'

AND 0COMP_CODE < '2565'

OR 0COMP_CODE > '2566'

AND 0COMP_CODE < '5154'

OR 0COMP_CODE > '5155'

AND 0COMP_CODE < '5208'

OR 0COMP_CODE > '5210'

AND 0COMP_CODE < '5301'

OR 0COMP_CODE > '5302'

AND 0COMP_CODE < '5502'

OR 0COMP_CODE > '5503'

AND 0COMP_CODE < '5507'

OR 0COMP_CODE > '5508'

AND 0COMP_CODE < '5592'

OR 0COMP_CODE > '5593'

AND 0COMP_CODE < '5595'

OR 0COMP_CODE > '5596'

AND 0COMP_CODE < '5916'

OR 0COMP_CODE > '5917'

AND 0COMP_CODE < '5922'

OR 0COMP_CODE > '5923'

AND 0COMP_CODE < '5992'

OR 0COMP_CODE > '5993'

AND 0COMP_CODE < '6731'

OR 0COMP_CODE > '6732'

AND 0COMP_CODE < '7000'

OR 0COMP_CODE > '7001'

AND 0COMP_CODE < '7483'

OR 0COMP_CODE > '7484'

AND 0COMP_CODE < '8000'

OR 0COMP_CODE > '8004'

AND 0COMP_CODE < '8008'

OR 0COMP_CODE > '8009'

AND 0COMP_CODE < '8036'

OR 0COMP_CODE > '8042'

AND 0COMP_CODE < '8050'

OR 0COMP_CODE > '8051'

AND 0COMP_CODE < '8059'

OR 0COMP_CODE > '8060'

AND 0COMP_CODE < '8100'

OR 0COMP_CODE > '8102'

AND 0COMP_CODE < '8748'

OR 0COMP_CODE > '8750'

AND 0COMP_CODE < '9101'

OR 0COMP_CODE > '9124'

AND 0COMP_CODE < '9126'

OR 0COMP_CODE > '9131'

AND 0COMP_CODE < '9133'

OR 0COMP_CODE > '9148'

AND 0COMP_CODE < '9152'

OR 0COMP_CODE > '9167'

AND 0COMP_CODE < '9169'

OR 0COMP_CODE > '9170'

AND 0COMP_CODE < '9173'

OR 0COMP_CODE > '9178'

AND 0COMP_CODE < '9183'

OR 0COMP_CODE > '9186'

AND 0COMP_CODE < '9188'

OR 0COMP_CODE > '9199'

AND 0COMP_CODE < '9202'

OR 0COMP_CODE > '9204'

AND 0COMP_CODE < '9206'

OR 0COMP_CODE > '9222'

AND 0COMP_CODE < '9224'

OR 0COMP_CODE > '9225'

AND 0COMP_CODE < '9228'

OR 0COMP_CODE > '9230'

AND 0COMP_CODE < '9232'

OR 0COMP_CODE > '9237'

AND 0COMP_CODE < '9239'

OR 0COMP_CODE > '9262'

AND 0COMP_CODE < '9264'

OR 0COMP_CODE > '9269'

AND 0COMP_CODE < '9271'

OR 0COMP_CODE > '9274'

AND 0COMP_CODE < '9276'

OR 0COMP_CODE > '9288'

AND 0COMP_CODE < '9291'

OR 0COMP_CODE > '9311'

AND 0COMP_CODE < '9313'

OR 0COMP_CODE > '9314'

AND 0COMP_CODE < '9316'

OR 0COMP_CODE > '9339'

AND 0COMP_CODE < '9502'

OR 0COMP_CODE > '9503'

AND 0COMP_CODE < '9505'

OR 0COMP_CODE > '9508'

AND 0COMP_CODE < '9512'

OR 0COMP_CODE > '9515'

AND 0COMP_CODE < '9521'

OR 0COMP_CODE > '9523'

AND 0COMP_CODE < '9525'

OR 0COMP_CODE > '9526'

AND 0COMP_CODE < '9529'

OR 0COMP_CODE > '9531'

AND 0COMP_CODE < '9540'

OR 0COMP_CODE > '9541'

AND 0COMP_CODE < '9543'

OR 0COMP_CODE > '9545'

AND 0COMP_CODE < '9550'

OR 0COMP_CODE > '9551'

AND 0COMP_CODE < '9557'

OR 0COMP_CODE > '9558'

AND 0COMP_CODE < '9565'

OR 0COMP_CODE > '9566'

AND 0COMP_CODE < '9568'

OR 0COMP_CODE > '9570'

AND 0COMP_CODE < '9585'

OR 0COMP_CODE > '9587'

AND 0COMP_CODE < '9592'

OR 0COMP_CODE > '9596'

AND 0COMP_CODE < '9610'

OR 0COMP_CODE > '9612'

AND 0COMP_CODE < '9618'

OR 0COMP_CODE > '9619'

AND 0COMP_CODE < '9688'

OR 0COMP_CODE > '9689'

AND 0COMP_CODE < '9790'

OR 0COMP_CODE > '9791'

AND 0COMP_CODE < '9916'

OR 0COMP_CODE > '9917'

AND 0COMP_CODE < '9922'

OR 0COMP_CODE > '9923'

AND 0COMP_CODE < '9992'

OR 0COMP_CODE > '9993' )

AND NOT 0COMP_CODE IN ('#','0001','0100','0107','0120','0126','0138','0145','0152','0171','0175','0180','0181','0188','0195','0197','0200','0206','0213','0221','0229','0232','0240','0244','0247','0257','0261','0263','0265','0267','0280','0285','0290','031

AND ( 0CREDIT

OR = '#'

OR 0CREDIT

OR BETWEEN '#'

AND '0000199999'

OR 0CREDIT

OR BETWEEN '0000300000'

AND '9999999999' )

AND 0TCAACTVT = '03'

Characteristic Content(in SQL Format)

0COMP_CODE I BT 0104 0105

I BT 0110 0111

I BT 0129 0130

I BT 0147 0149

I BT 0215 0216

I BT 0234 0235

I BT 0253 0254

I BT 0297 0298

I BT 0304 0305

I BT 0325 0331

I BT 0400 0401

I BT 0403 0405

I BT 0407 0408

I BT 0411 0412

I BT 0414 0415

I BT 0422 0424

I BT 0480 0481

I BT 0483 0485

I BT 0500 0503

I BT 0505 0508

I BT 0510 0513

I BT 0515 0516

I BT 0518 0523

I BT 0525 0526

I BT 0528 0529

I BT 0530 0532

I BT 0537 0538

I BT 0540 0545

I BT 0547 0548

I BT 0550 0551

I BT 0553 0555

I BT 0557 0558

I BT 0560 0561

I BT 0568 0569

I BT 0573 0577

I BT 0579 0582

I BT 0585 0586

I BT 0590 0594

I BT 0602 0603

I BT 0618 0626

I BT 0635 0637

I BT 0642 0644

I BT 0648 0649

I BT 0690 0691

I BT 0731 0733

I BT 0790 0791

I BT 0824 0825

I BT 0870 0871

I BT 0895 0896

I BT 0912 0913

I BT 0962 0963

I BT 1006 1007

I BT 1010 1011

I BT 1024 1029

I BT 1055 1056

I BT 1058 1061

I BT 1097 1100

I BT 1108 1109

I BT 1112 1124

I BT 1126 1136

I BT 1138 1139

I BT 1172 1175

I BT 1179 1181

I BT 1200 1224

I BT 1228 1229

I BT 1231 1234

I BT 1236 1237

I BT 1325 1326

I BT 1503 1504

I BT 1651 1663

I BT 1667 1675

I BT 1677 1683

I BT 1686 1688

I BT 1700 1704

I BT 1707 1720

I BT 1727 1731

I BT 1788 1796

I BT 1800 1801

I BT 1889 1895

I BT 1905 1906

I BT 1910 1912

I BT 1920 1926

I BT 1976 1977

I BT 2001 2003

I BT 2006 2019

I BT 2205 2208

I BT 2300 2307

I BT 2315 2325

I BT 2365 2366

I BT 2380 2381

I BT 2394 2395

I BT 2453 2454

I BT 2489 2493

I BT 2500 2505

I BT 2565 2566

I BT 5154 5155

I BT 5208 5210

I BT 5301 5302

I BT 5502 5503

I BT 5507 5508

I BT 5592 5593

I BT 5595 5596

I BT 5916 5917

I BT 5922 5923

I BT 5992 5993

I BT 6731 6732

I BT 7000 7001

I BT 7483 7484

I BT 8000 8004

I BT 8008 8009

I BT 8036 8042

I BT 8050 8051

I BT 8059 8060

I BT 8100 8102

I BT 8748 8750

I BT 9101 9124

I BT 9126 9131

I BT 9133 9148

I BT 9152 9167

I BT 9169 9170

I BT 9173 9178

I BT 9183 9186

I BT 9188 9199

I BT 9202 9204

I BT 9206 9222

I BT 9224 9225

I BT 9228 9230

I BT 9232 9237

I BT 9239 9262

I BT 9264 9269

I BT 9271 9274

I BT 9276 9288

I BT 9291 9311

I BT 9313 9314

I BT 9316 9339

I BT 9502 9503

I BT 9505 9508

I BT 9512 9515

I BT 9521 9523

I BT 9525 9526

I BT 9529 9531

I BT 9540 9541

I BT 9543 9545

I BT 9550 9551

I BT 9557 9558

I BT 9565 9566

I BT 9568 9570

I BT 9585 9587

I BT 9592 9596

I BT 9610 9612

I BT 9618 9619

I BT 9688 9689

I BT 9790 9791

I BT 9916 9917

I BT 9922 9923

I BT 9992 9993

I EQ #

I EQ 0001

I EQ 0100

I EQ 0107

I EQ 0120

I EQ 0126

I EQ 0138

I EQ 0145

I EQ 0152

I EQ 0171

I EQ 0175

I EQ 0180

I EQ 0181

I EQ 0188

I EQ 0195

I EQ 0197

I EQ 0200

I EQ 0206

I EQ 0213

I EQ 0221

I EQ 0229

I EQ 0232

I EQ 0240

I EQ 0244

I EQ 0247

I EQ 0257

I EQ 0261

I EQ 0263

I EQ 0265

I EQ 0267

I EQ 0280

I EQ 0285

I EQ 0290

I EQ 0319

I EQ 0323

I EQ 0335

I EQ 0362

I EQ 0431

I EQ 0439

I EQ 0447

I EQ 0467

I EQ 0472

I EQ 0487

I EQ 0534

I EQ 0564

I EQ 0588

I EQ 0597

I EQ 0600

I EQ 0605

I EQ 0610

I EQ 0613

I EQ 0617

I EQ 0630

I EQ 0632

I EQ 0639

I EQ 0646

I EQ 0647

I EQ 0650

I EQ 0651

I EQ 0652

I EQ 0653

I EQ 0654

I EQ 0655

I EQ 0656

I EQ 0658

I EQ 0659

I EQ 0660

I EQ 0661

I EQ 0665

I EQ 0666

I EQ 0668

I EQ 0669

I EQ 0670

I EQ 0671

I EQ 0672

I EQ 0673

I EQ 0677

I EQ 0681

I EQ 0684

I EQ 0686

I EQ 0694

I EQ 0697

I EQ 0703

I EQ 0705

I EQ 0710

I EQ 0718

I EQ 0722

I EQ 0737

I EQ 0747

I EQ 0752

I EQ 0753

I EQ 0754

I EQ 0755

I EQ 0756

I EQ 0757

I EQ 0758

I EQ 0759

I EQ 0760

I EQ 0761

I EQ 0782

I EQ 0797

I EQ 0808

I EQ 0810

I EQ 0816

I EQ 0819

I EQ 0827

I EQ 0834

I EQ 0835

I EQ 0836

I EQ 0837

I EQ 0840

I EQ 0849

I EQ 0860

I EQ 0864

I EQ 0865

I EQ 0868

I EQ 0907

I EQ 0928

I EQ 0935

I EQ 0946

I EQ 0959

I EQ 0965

I EQ 0977

I EQ 0990

I EQ 1000

I EQ 1013

I EQ 1015

I EQ 1020

I EQ 1044

I EQ 1046

I EQ 1050

I EQ 1052

I EQ 1067

I EQ 1069

I EQ 1074

I EQ 1085

I EQ 1087

I EQ 1089

I EQ 1092

I EQ 1102

I EQ 1103

I EQ 1105

I EQ 1106

I EQ 1141

I EQ 1166

I EQ 1170

I EQ 1184

I EQ 1187

I EQ 1239

I EQ 1314

I EQ 1402

I EQ 1562

I EQ 1597

I EQ 1689

I EQ 1690

I EQ 1691

I EQ 1692

I EQ 1693

I EQ 1694

I EQ 1695

I EQ 1696

I EQ 1705

I EQ 1706

I EQ 1725

I EQ 1733

I EQ 1745

I EQ 1751

I EQ 1754

I EQ 1803

I EQ 1819

I EQ 1887

I EQ 2005

I EQ 2185

I EQ 2201

I EQ 2330

I EQ 2332

I EQ 2339

I EQ 2354

I EQ 2368

I EQ 2372

I EQ 2397

I EQ 2437

I EQ 2439

I EQ 2458

I EQ 2512

I EQ 2613

I EQ 2800

I EQ 2801

I EQ 2802

I EQ 2803

I EQ 2805

I EQ 4528

I EQ 5106

I EQ 5110

I EQ 5130

I EQ 5183

I EQ 5185

I EQ 5189

I EQ 5196

I EQ 5203

I EQ 5212

I EQ 5230

I EQ 5240

I EQ 5242

I EQ 5244

I EQ 5265

I EQ 5269

I EQ 5273

I EQ 5276

I EQ 5286

I EQ 5292

I EQ 5306

I EQ 5413

I EQ 5425

I EQ 5427

I EQ 5510

I EQ 5513

I EQ 5523

I EQ 5543

I EQ 5551

I EQ 5565

I EQ 5572

I EQ 5576

I EQ 5587

I EQ 5926

I EQ 5930

I EQ 6737

I EQ 6747

I EQ 6982

I EQ 7481

I EQ 7749

I EQ 8006

I EQ 8007

I EQ 8200

I EQ 8579

I EQ 8644

I EQ 8655

I EQ 8739

I EQ 8765

I EQ 8766

I EQ 8767

I EQ 8821

I EQ 8823

I EQ 8923

I EQ 8925

I EQ 9050

I EQ 9051

I EQ 9055

I EQ 9180

I EQ 9347

I EQ 9351

I EQ 9354

I EQ 9360

I EQ 9361

I EQ 9364

I EQ 9413

I EQ 9425

I EQ 9427

I EQ 9489

I EQ 9500

I EQ 9510

I EQ 9518

I EQ 9533

I EQ 9536

I EQ 9548

I EQ 9554

I EQ 9561

I EQ 9572

I EQ 9574

I EQ 9576

I EQ 9581

I EQ 9601

I EQ 9604

I EQ 9606

I EQ 9616

I EQ 9634

I EQ 9675

I EQ 9683

I EQ 9699

I EQ 9707

I EQ 9722

I EQ 9741

I EQ 9890

I EQ 9926

I EQ 9930

I EQ 9976

I EQ 9982

I EQ 9999

I EQ :

I EQ AT01

I EQ AU01

I EQ BE01

I EQ CA01

I EQ CH01

I EQ DE01

I EQ DK01

I EQ ES01

I EQ FR01

I EQ GB01

I EQ HU01

I EQ IT01

I EQ JP01

I EQ NL01

I EQ NO01

I EQ SE01

I EQ SG01

I EQ TEMP

I EQ TMPN

I EQ US01

I EQ ZA01

0CREDITOR I BT 0000000000 0000199999

I BT 0000300000 9999999999

I EQ #

I EQ :

0TCAACTVT I EQ 03

Not Authorized Selection is not authorized

All Authorizations Tested

Message EYE007: You do not have sufficient authorization

No Sufficient Authorization for This Subselection (SUBNR)

[Former Member]

Pls see the log above...let me know if u need more info

[Former Member]

Pls see the log above...let me know if u need more info

Hi Umesh,

From the above log it is not very clear which set is checked and which set is authorized but nevertheless does 0Comp_code has authorization for : (aggregation) and #(non-assigned)?

If yes, can u also please check if their is difference in the value of comp_code used in the query and in the authorized set?

[arpan_paik]

The query is searching data for a huge area. You can check with Query designer if the same been created for that purpose?

Regards,

Arpan Paik

[Former Member]

Thanks All for replies.....

The error I am getting RSECADMIN auth error relating to 6 ( 0COMP_CODE ) AND 38 ( 0CREDITOR ) ...

Actually the workaround we got it to give a role which has full Company Code Auth (*) in the role through rsecauth...NOW, after this we are no longer getting auth error while jumping the query (though not sure about the completeness of the date in the query)

But I dont think it is a permanent solution, Iam not sure which info object, or which info providers to check? as iam very new to BI Authorization.

Could you please help....

Thanks,.....

[Former Member]

Correct the query does give option for selecting company code while executing it, so thus i think it would take () star as the authorization value. Thus it mean even if Analysis Authorization has required company codes, it would call for () star value, which it did not had. Thus this error....

[Former Member]

Hi,

The comp code in the initial selection needs to be passed into the query which is "jumped to". This is a functional BW problem, not auths. The second query will always fail if it is doing a full selection and the user does not have every single value (or *) which is being evaluated.