Skip to main content
To homepage To homepage

General Q&A

Ask general questions

128 Topics
M
Visitor
martin.oloughlinVisitor
asked in Legacy & Upgrades
cube filtering

Just after some advice about whether something is possible. I have developed a data-warehouse that encompasses all products, However due to the nature of the business what I want to do is create two separate cubes, both that only report on a selection of the products, i am trying to avoid extra security roles in Targit which is used to browse the cubes or creating extra SQL tables which i believe would enable me to achieve the result but with more to manage. Is it possible to add a filter to a cube so that it only includes some dimension members?

311
J
Contributor
D
Starter
david.kesselheimStarter
asked in Legacy & Upgrades
Truncation SSIS error

Hi, We are trying to read a csv file and truncating some columns because our table would be too large otherwise. Unfortunately deploy and execute fails with this error: "Data conversion failed. The data conversion for column "name" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page."." We are pretty sure it isn't an encoding problem because when we increase the column size ("Length") in "Edit multiple text files"->"Columns" we can read the data just fine so the error must occur because of the truncation. Does anybody know what options we have to use to let TimeXtender know that we are ok with the truncation of the data in the columns? Thanks, David

4801
JTreadwell
Employee
W
Contributor
WimContributor
asked in General
SQL 2016: worth the upgrade?

Hello fellow TimeXtender users, We were wondering: is it worth upgrading from SQL 2014 to 2016 in the scenario where we use TX traditionally: stage - dw - cubes. Has anyone done it and have you seen performance improvements? Thanks! Wim CALM - Co

325
T
Explorer

Most helpful members this week

Badge winners

  • Ingest Expert
    nmohas earned the badge Ingest Expert
  • Ingest Expert
    oscarclevehas earned the badge Ingest Expert
  • Ingest Expert
    fwagnerhas earned the badge Ingest Expert
  • Innovator
    woutersmikehas earned the badge Innovator
  • Innovator
    Roy Vhas earned the badge Innovator
Show all badges

Popular tags

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings