Skip to Content
0

Date prompts not showing selection list in SAP Design Studio 1.6

Apr 06, 2017 at 11:38 AM

334

avatar image

Hi All,

I have created a Design Studio Application on Universe.

The prompts are as below:

I have given default values for Logical Date in Universe as

The date format is:

When I execute the Design Studio application, the values for the Logical date appears as Complex Selection(As shown in first Screen shot). When I try to change the values,It gives me a warning that "All selections for dimension Enter Logical Start Date are invalid and have been discarded"

Could you pls suggest how this can be resolved?

Thank you.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Apr 06, 2017 at 12:26 PM
0

I wonder if you could try what is recommended in this note - I can't tell if the resolution is to format it in IDT or ?

https://launchpad.support.sap.com/#/notes/2411261/E

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Tammy,

I have gone through the link you shared.

IDT is not showing any Date functions to convert this in the backend. It is only showing me basic functions like Sum,Min,Max Avg.

Could you suggest if there is anything that can be done from Design Studio.

My requirement is to access an ECC table and show the data in Design Studio. To do that, I created an Infoset on the ECC table and then I created a universe on the Infoset and used in Design studio.

Thanks.

0

Interesting; instead of creating a universe, could you use a BEx query against the ECC table? See https://blogs.sap.com/2012/03/25/what-are-transient-providers/ - I think the dates from a BEx query may work better than the universe (just my guess)

0

Thanks for sharing the link.

I will be trying the same and shall update you if it works.

0