BO4 - derived tables on individual partitions possible?

[former_member272336]

Hi,

Using bo4 and we have an oracle tabel which is partitioned and wish to have a derived table which allows user to entre a year and week to just see an individual partition of table.

Using syntax below - but get specified partition does not exist when try validate.

select column1, column2...

from table partition ( PART_@Prompt('Enter YYYYWW','N',,mono,free)  )

Anybody able to get this to work?

Thanks

[former_member193452 · Accepted solution]

Hi Phillip,

It was possible in the Universe Designer and here is a kb with instructions:

1187156 - How do you define a prompt so that it refers to different tables depending on the value of your prompt?

https://service.sap.com/sap/support/notes/1187156

I haven't tested this out in IDT yet.

Hope this helps.

Jacqueline

[former_member272336 · Accepted solution]

Hi Jacqueline,

Thanks for reply. will check it out when get a chnace.