-
sql data reader step is not working in procedure whereas it is running manually
There are bunch of data readers which i have ported along with some cubes and procedures , so everything is fine except the calling sql data reader step in procedure , it is throwing an error and going to error group whereas manually it is running perfectly, can any body help with this. please find the error from the logs.
-
What is the purpose of "Position Changes" in the Data Model Transporter?
We recently executed a backup and restore of our core data model from production to non-production. Everything was aligned momentarily; However, as soon as we developed a couple new objects (cubes, rules, entity formats), the data model comparison tool exploded to show several hundred changes between environments. Of the…
-
Selection in screens with multi-data-models
We have a requirement where a single screen needs to display data views that are based on different data models. The problem is that users have to apply the same selection multiple times (for example: select the year → Data Model 1, and then again select the year → Data Model 2). Is there any workaround for this? One idea…
-
Best practices how to show many columns in dataview (>10 columns with a hundred thousands data rows)
Hi all, I want to know the best practices how to show many columns in dataview with approximately >10 columns with a hundred thousands data rows in a dataview. Because I am stressfull a lot about limitation error rows limit issues. I have read many references from other forums/discussions about this one, and overall of…
-
Filter in Data layout
I have added a filter in data layout and the main value should be 1. Even though in 2 of the members of the entity (whose codes are used as filters) values are here but these members are not visible when in playmode but are visible in dataview when in design mode. Any resolution to this issue.
-
Level 200 Module205: Italy Not populating
In the section where you create the procedure within the capsule, the UK data will load, but the Italy data will not. I have checked the procedure within the data model (ACT - Sales Data Load), and the path/file is set to ALL. In the MAIN group, create a "Text file data reader" step for "ACT - Units and Sales". Set the…
-
Cube Visibility & Cube cells locked by
Cloud version: 12.6 0288217 Hello, I can't get Cube Visibility (Deny cell editing in Database Security) combined with Cube cells locked by to work, even if the cubes are not conflicting. This is the error message shown on the Screen when you log in as a User (not Developer). The error message itself is not explanatory. Is…
-
The Database size got reduced from 24 GB to 19 GB after extract and reload of the database
Recently i performed Max item number change for few entities and for that we extract all of the database and do this change and then reload the database. There is no loss of any data for me, nor there is any issue but the only thing i observed was after the reload of the database the size of database got reduced to 19 Gb.…
-
Data Access Control Architecture
1. Abstract Database and Application security refers in general to the range of tools designed to establish and preserve data confidentiality, integrity, and availability. In Board terms it is the definition of the various access levels so that the users are presented and can modify only data relevant to them and for which…