Skip to Content
0

SAP design studio axis labels missing when no data

Jan 10 at 10:52 PM

28

avatar image
Former Member

I have a derived table in the universe and I am building a info chart in design studio based on this.The query of derive table is something like below:-

select month(deploy date) as col1,col2,col3 from table1.

But there is no data for few months but the user wants to see the info chart with bar showing 0 for that month? How can I achieve this. Any ideas??

Thanks

SAP BusinessObjects Design Studio
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Tammy Powlas
Jan 10 at 10:53 PM

Which version / SP of Design Studio are you using? Which version/SP of the BI platform are you using?

0
Comment
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
avatar image
Arijit Das Answered Jan 11 at 07:04 AM
0

I can think of having a time dimension table in universe joined with transaction table. Hence you can get a continuous time axis from the time dimension table.

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users