1

This is more or less the query I'm after:

WITH [Measures].[rowcount] AS
  COUNT([SomeDimension].Members)

SELECT
  [Measures].[rowcount] ON ROWS

FROM
  [FOO/BAR]

Ultimately I'm after a row count of the fields after some 20 dimensions are applied - for data profiling purposes. But I can't get even this little snip to execute. The editor just dumps me directly into the ABAP debugger (where I have absolutely no expertise).

Any advise on what's going wrong? Thanks!

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
Ryan B.
  • 3,575
  • 2
  • 20
  • 26

1 Answers1

2

Here is a working example tested on SAP BW IDES EHP7.

WITH MEMBER [Measures].[rowcount] AS  COUNT([0D_NW_CODE].[LEVEL01].MEMBERS * [0D_NW_PLANT].[LEVEL01].MEMBERS )
SELECT {[Measures].[rowcount] } ON COLUMNS FROM [$0D_NW_C01]

enter image description here

AecorSoft
  • 414
  • 4
  • 10
  • Seems I didn't appreciate the importance of this [LEVEL01]. Thank you, really. That template helped a ton. – Ryan B. Aug 27 '19 at 21:32