Data Warehouse

Data in the context of GDPR or sensitive to stock markets require attention in the datawarehouse with regard to securing the data, in some cases this also to the people developing the datawarehouse. We have been looking into several options, and now plan to do a proof of concept on transparent data encryption.   Anybody experience with securing sensitive data in the datawarehouse, either with this setting or in other ways?

I know you can lock a project from editing, but is there a way to password protect a project we install on a client's server so they can't view how we built it?  We've spent hundreds of hours building an ERP integration that we want to sell multiple times and don't want a client or competitor to simply rebuild it by exporting, or just looking at the project design and mimicking it.    

How to write 'case' in Custom SQL, please let me know with example. Here is the situation (SQL query) that I need to perform on Date table & likes to update 'IND' column where DateValue is default column in Date table selectcase when GETDATE()<=DateValue then 'N' else 'Y' end as 'IND' ,* from <table_name> order by DateValue desc

Hi. I aheba question for you all:   I have a table for example link this filed_name:Format Product_id: Integer Delivery_metod: varchar(50) Inventory_id: Integer Inventory_Entries: JSON   Inventory_entries can contain one or several entries in JSON format like this: [{"SKU":"A","Price":"100"},{"SKU":"B","Price":""00"}]   Instead off one line with the json entries nested into one single field i would like to Normalize the tabel into several lines, one for each SKU.   Any ideas?      

Example scenario: Table DimProject has 2 mappings, each from a different source: Mapping 1 = SourceA.Project Mapping 2 = SourceB.Project Now both systems will have the same project number with different meanings.   My question is how do I make a transformation that returns 'A' + [project number] in mapping 1 and 'B' + [project number] in mapping 2. The solution needs be rely on explicitly meaningful conditions, no implicit conditions that drive people crazy trying to decipher what they are for somewhere in the future. Any ideas?

Hi,  i've setup a MDW layer with proper relations between tables. At this point I wanted to create a relation diagriam to visualise to my client the relation between his entities.  my tool of choice was SQL Management Studio. Only then i've realised that DH only create DW_Id as physical primary key and the relations between tables are managed internally   Is there a way in DH to visualize the relations between the tables?  I've already put my vote here https://support.timextender.com/hc/en-us/community/posts/360000924546-Relation-Diagram-based-on-total-layer?input_string=database%20diagram%3A%20visualize%20your%20data%20model  

Hi, I am trying to build a transformation process in TX based on the following SQL code. ------------------------------------------ SELECT distinct[BusinessEntityID] ,B.MonthKey,[StartDate],[EndDate] ,[DepartmentName]FROM [TX_DSA].[dbo].[EmployeeDepartmentHistory] Ajoin dbo.Calendar B ON B.Date >= A.StartDate where b.DateValue >= a.StartDate AND (a.EndDate is null or a.EndDate <= b.DateValue) ---------------------------------------------------- I want intentionally to expand the grain of table A. I tried different Joins and conditional lookups but I just can't reproduce the output. How would you solve this? Thanks in advance grJose

I am joining 2 tables T1 and T2 based on a condition T1.A = T2.B T1.A have values like 'wNFq' and T2.B have values like 'WNFQ', 'wnfQ', 'WnFq', 'wNFq' For a regular join a particular row of 'wNFq' from T1 gets joined with all values: 'WNFQ', 'wnfQ','WnFq' and 'wNFq' of T2 My intention is to join only 'wNFq' from T1 to 'wNFq'. I achieved the same using custom SQL insert and using the below  COLLATE function to join based on case sensitive sequencing using: T1.A COLLATE Latin1_General_CS_AS_KS_WS = T2.B COLLATE Latin_1_General_CS_AS_KS_WS Wandering if there is a different way to achieve this avoiding custom SQL. Appreciate any help on the same.  

Created a conditional lookup based on following : T1 joined to T2 where T1.A = T2.B Looked up T2.C based on the above join condition and stored the value in T1.D Now I need to filter the resultant data set which is on T1 based on certain values of T1.D Unable to put that filter in the Table Data Selection Rule. Even I tried to copy T1.D(look up filed) to T1.E (a separate filed created just to hold the value of T1.D) and filter on T1.E, even that did not work. Appreciate help on the same.

I have the following set of tables: A (key1, key2) B (key2, key3) In that case, every key1 can have multiple key2 attributes in table A and every key2 can have multiple key3 attribues in table B. When I would use a conditional lookup field for table A to get key3, it would only give me one of the key3 attribues, is it possible to take all values? I know I could do it with a simple custom view left joining on key2, but is there are recommended way to do it in Discovery Hub without custom views? So the goal table should be like C (key1, key2, key3)

Dear TimeXtender's Team, What is choice to setting rounding in TimeXtender if we want to set up decimal ?  Like example .. in Original Data is $12,3456, we just want the result is $12,34 (2 decimal) because in TX, it will be $12,35 Thank you,

I'm trying to create a hierarchy of GL accounts and the category they belong to. (i.e. Assets, Liabilities, Equity, Income Expenses).However the Hierarchy is displaying alphabetically.  If it were to be sorted by the first GL account it's associated with, it would sort correctly since GL accounts are numbered in the proper sequence.However, when I tell the Dimension, "Parent Category" (which is the Assets, Liabilities etc) to sort by Attribute Key, when I deploy I get an error saying it can't be used as an attribute because it is not related.Is there a workaround to this?

Is there a way to customize the error text so that in the log it will read something other than "Field X does not comply with validation rule y"

HI  I am having a OLAP cube and a standard measure which needs to be in hh:mm format. currently the number is coming in float. Guidance much appreciated.

I can see the custom data on the table when I go and check advanaced. How to know where does it exactly points to? I am trying to find the location and file name of the excel sheet I loaded.