en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Lotte Bjørn Jensen  
#1 Posted : Friday, September 20, 2013 3:56:50 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68

Hi

Where do I find a description of how to use the Relational Datamodel Editor in Targit Management Studio?

Best regards

Lotte Bjørn
Ole  
#2 Posted : Friday, September 20, 2013 4:03:32 PM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 320

Hi Lotte,

The manual for TARGIT Management Studio contains a section on the Relational Data Model Editor. If you don't have the manual, you can download it from the Download Center at the TARGIT Portal, www.mytargit.com.

The description in the manual is quite compact, so some prior experience with data modeling (e.g. from SSAS Data Source Views) will be helpful.

BR / Ole
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage Ole Dyring
Lotte Bjørn Jensen  
#3 Posted : Wednesday, September 25, 2013 12:59:39 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68

Hi Ole

Now I've found the manual and it's referring to: See White Paper on Relational Data Sources.
Where do I find the White Paper?
Best regards

Lotte Bjørn
Ole  
#4 Posted : Wednesday, September 25, 2013 2:43:29 PM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 320

Hmmm... I couldn't find a White Paper myself. Instead I found this video: http://tv.targit.com/vid.../targt-bi-suite-realtime

BR / Ole
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage Ole Dyring
Lotte Bjørn Jensen  
#5 Posted : Thursday, September 26, 2013 1:22:48 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68

Hi Ole

I've been viewing the video, and now I'm trying to build a time hierarchy the same way, but I get this failure
second time I drag the date to the period dimension.

UserPostedImage

Best regards

Lotte Bjørn
Niels Thomsen  
#6 Posted : Friday, September 27, 2013 11:51:27 AM(UTC)
Niels Thomsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/5/2011(UTC)
Posts: 103

Hi Lotte

I don't recall if the video refers to a certain build of TARGIT - but anyway in the build(s) where I have tried to construct a time dimension from a date in the Relational Engine the program behaves exactly as you describe.

What you need to do is just to change the sequence of action a little bit. Before you drag the second attribute you need to do "the magic" that is shown in the Video on the propeties of the first level of the hierarchy - then you can drag next level - work with the properties of that level etc...

Hope it makes sense.

Edited by user Friday, September 27, 2013 11:52:46 AM(UTC)  | Reason: Not specified

Hope it makes sense.

Best Regards
Niels Thomsen

https://dk.linkedin.com/in/ncthomsen


Lotte Bjørn Jensen  
#7 Posted : Friday, September 27, 2013 12:08:38 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68

Hi Niels

Can you tell me more about "The Magic"? I can see that he's changing the column definition to t.ex. year and is using datepart on the date, but it doesn't seem to help. What other "Magic" do I need to use? I can see a popup window in the video with functions (datepart). How do I get that popup-window?
Best regards

Lotte Bjørn
Niels Thomsen  
#8 Posted : Friday, September 27, 2013 2:09:57 PM(UTC)
Niels Thomsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/5/2011(UTC)
Posts: 103

The "magic" is just working with the properties of every level of the hierarchy. The pop-up is just a convenient editor that holds the script so it can be copy-pasted to the correct property of the year-, month- or daylevel of the hierarchy.

This shows how e.g. the year level could be set up using properties, before dragging the date once more to create the next level:
UserPostedImage

Hope it makes sense.
Hope it makes sense.

Best Regards
Niels Thomsen

https://dk.linkedin.com/in/ncthomsen


Lotte Bjørn Jensen  
#9 Posted : Friday, September 27, 2013 3:31:42 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68

Now then management-part is working

UserPostedImage

but then Targit fails

UserPostedImage
Best regards

Lotte Bjørn
Niels Thomsen  
#10 Posted : Monday, September 30, 2013 3:34:36 PM(UTC)
Niels Thomsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/5/2011(UTC)
Posts: 103

Ok - I just tried and it works for me. Is you're relational database located on a SQL Server platform?

E.g. if you connect to an access database the SQL-commands can differ a little - in this case the syntax would be datepart("yyyy",[THEDATE])


Hope it makes sense.

Best Regards
Niels Thomsen

https://dk.linkedin.com/in/ncthomsen


Lotte Bjørn Jensen  
#11 Posted : Wednesday, October 2, 2013 10:04:50 AM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68

Arh.... stupid me....

It's an Oracle database, so now when I've changed it to Oracle syntaks it's working. ;o)
Best regards

Lotte Bjørn
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error